Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Soldano16
Starting Member
2 Posts |
 Posted - 2008-05-07 : 10:58:15
|
| This procedure runs and I see my GM names come up one at a time but I get no tables created.Sorry about the sloppy code - I'm not a real pro.declare @@GM Char(100) declare @SQL VarChar (2000)Declare spot cursor scroll forselect GM from BIM_Historical_Performance.dbo.Performance_Masteropen spotfetch first from spot into @@GMWhile @@Fetch_Status =0BEGINset @SQL = 'select Comp, Billto, Cust_name as Customer, Branch, BAC, [MgMt_Type], BondValue as Bondbucks , BondValueAlloc as Allocbucks, c1 as Curcode, u1 as CurUnderP$, s1 as Cur3mthBIMsales, p1 as performance, I1 as Inside, [IS_since] as Insidesince, O1 as Outside, [OS_since] as Outsidesince, c2 as CodeM-1, c3 as CodeM-2, c4 as CodeM-3, c5 as CodeM-4 ,c6 as CodeM-5, GM into ' +@@GM + ' from BIM_Historical_Performance.dbo.Performance_Master where BIM_Historical_Performance.dbo.Performance_Master.gm = ' +@@GM EXEC (@Sql)Fetch NExt from spotEnd |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-07 : 11:04:40
|
| Did you put a PRINT to check what SQL string it builds each time? |
 |
|
|
|
|
|
|
|
Why are my tables not being created?