-
IF ELSE in SQL Server stored procedure
I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type...
Last updated: -
I have managed to get the prompt to work, but when i type a number into prompt it displays all outputs on webpage, like nodiscount5%discount etc, could someone please sort my program so it just shows one output, then i can study my errors and learn from it. thankyou. <HTML> <HEAD>...
Last updated: -
DO…LOOP and IF ELSE THEN statements
I am writing a basic program where two types of data are added: 1. a salespersons ID and 2. an amount of cars sold within a month from that salesperson. I have found out how to set the code where the numbers will go where they need to, but adding extra ones does not work, and trying to add any more...
Last updated: -
Which Conditional Statemnt Is More Efficient in VB.NET 2005 IF ELSE OR Switch Case ?
Last updated: