Try this:

Select

prdid as 'product number',

sum(quano) as 'quantity ordered'

from SalesOrderTable

where prdid = 'XYZ'

GROUP BY prdid -- Added this now

Guess you have left the GROUP BY clause 😛

A 2-part INSERT might help you..

First INSERT - SourceTable data (only Name col) into Target

Second INSERT - JOIN SourceTable and TargetTable and insert into TargetConnection..

Got it; Now, as Dixie says, either Quirky Update or Cursor can save you. I am still pondering if it will be possible by a Recursive-CTE..Got to think..

I couldnt get the logic behind the grouping.. can you please be more elaborate on your explanation?? This certainly is do-able with set-based code..

You can utilize BCP commands and call xp_cmdshell to execute the BCP statements..

To read abt BCP, click here

calvo (4/28/2011)

---

lol...love it. You just worked...

I totally concur 🙂 he is awesome, like how The Miz in WWE says, Wayne is awesome 🙂

Stefan Krzywicki (4/28/2011)

---

ColdCoffee (4/28/2011)

---

Aren't CTE and SubQuery synonymous except for the fact that...

Aren't CTE and SubQuery synonymous except for the fact that CTE has an...

Stefan Krzywicki (4/28/2011)

---

ColdCoffee (4/27/2011)

---

Try this:

declare @table table

( catid int, catname varchar(25) , refid int )

insert into @table values

(1 ,'Lenovo', 21),

(2 ,'Sony', 22),

(2 ,'Sony', 22),

(3 ,'Dell', 23),

(4 ,'Toshiba', 24),

(4 ,'Toshiba', 24)

;...

Change

SELECT DATEADD(MM, N,@StartDate) [Month]

FROM NumbersTable

WHERE N < @NumOfMonths

to

SELECT DATEADD(MM, N,@StartDate) [Month]

INTO dbo.TempTable -- Add this line alone

FROM NumbersTable

WHERE N < @NumOfMonths

Look into the commented line 🙂

No Usha, you CANNOT join 1 SPs.. only tables and views can be joined..

vicki528 (4/28/2011)

---

i have come up with an alternative solution... may b this will help... its using while loop. you just have to input the starting and ending year like 2000...

How about this?

DECLARE @StartYear INT

,@EndYear INT;

SET @StartYear = 2010

SET @EndYear = 2011

DECLARE...

It would help great up if you show the real data, as in, mock-up of ur real data instead of the column names.. and also all the columns in the...