|
ProgramX
Starting Member
Romania
4 Posts |
 Posted - 09/20/2006 : 08:29:46
|
Hello !
In order to achive this :
USE db
if exists(select * from sysobjects where name = 'proc_proba_coll_row')
begin
drop PROCEDURE proc_proba_coll_row
end
go
CREATE PROCEDURE proc_proba_coll_row() AS
-- Declare the variables to store the values returned by FETCH.
DECLARE @var_column varchar(200),@var_table_def varchar(7000)
----------------------c2
DECLARE collumn_cursor CURSOR FOR
SELECT dbo.syscolumns.name
FROM dbo.syscolumns LEFT OUTER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
WHERE (dbo.sysobjects.name = 'Centrale')
OPEN collumn_cursor
-- Perform the second fetch.
FETCH NEXT FROM collumn_cursor
INTO @var_column
SET @var_table_def = @var_column + ' varchar(200)'
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM collumn_cursor
INTO @var_column
SET @var_table_def = @var_table_def + ',' + @var_column + ' varchar(200)'
END
CLOSE collumn_cursor
DEALLOCATE collumn_cursor
----------------------c2
CREATE TABLE newTableName (@var_table_def)
GO
Server: Msg 170, Level 15, State 1, Procedure proc_proba_coll_row, Line 34
Line 34: Incorrect syntax near '@var_table_def'.
Please could you hlp me to debug this |
|
Transform rows to columns.
Forum Locked
