What is Hungarian notation?

INSERT INTO TableB

SELECT 1, BreakQty1, Discount1 FROM TableA WHERE BreakQty1 IS NOT NULL -- or you condition

UNION SELECT BreakQty1 + 1 , BreakQty2, Discount2 FROM TableA WHERE BreakQty2 IS NOT...

You need 5 SELECTs also.

If you want to insert 1 to 5 records, you need 5 INSERT statements.

or

You can use UNION.

Use 5 INSERT statements.

Do you see

SET ROWCOUNT = 5000

in your SP?

My Enterprise Manager does not show record count.

DBCC CHECKIDENT

declare @WOW NVARCHAR(2000)

set @wow =

'Use XXXX

DECLARE @table_from_cursor nvarchar(150)

DECLARE @SQLString nvarchar(2000)

DECLARE @StringForExcecute nvarchar(2000)

DECLARE table_cursor CURSOR FOR

SELECT ...

The below 2 lines are both strings.

This sentence has no single quotes.

'This sentence are in quotes'.

Try it anyway. You will find the next problem in your script.

maybe

SET @StringForExcecute = ''''+@SQLString+''''

should be

SET @StringForExcecute = @SQLString

Peso,

I have been reading many of you and a few others's excellent solutions.

I know join is much more efficient.

I have learned that from you and Jeff M and a few...

SELECT CONVERT(VARCHAR, v.Number) + ' to ' + CONVERT(VARCHAR, v.Number + 1) AS [Hit time],

(SELECT COUNT(*) FROM @LoginTrack Z WHERE DATEPART(hour, Z.LoginDateTime) = V.Number) AS Hits

FROM master..spt_values AS v

WHERE...

DECLARE @T TABLE (ID int, CustID int, PhoneID int)

INSERT INTO @T SELECT 1, 1, 10

UNION SELECT 2, 2, 10

UNION SELECT 3, 3, 11

UNION SELECT 4, 1, 12

UNION SELECT 5, 2,...

Server: Msg 164, Level 15, State 1, Line 4

GROUP BY expressions must refer to column names that appear in the select list.

SELECT test.TestID, IFNULL(location.LocationName, '-') AS LocationName, IFNULL(product.ProductName, '-') AS ProductName

FROM Test as test