|
shinoykurian
Starting Member
United Arab Emirates
4 Posts |
 Posted - 04/22/2009 : 03:04:10
|
Hi guys, I am getting an error message for the below query, can some one help.
DECLARE tables_cursor CURSOR
FOR
SELECT RESCOD,ITMCOD FROM psmastbl WHERE rescod='GSH'
OPEN tables_cursor
DECLARE @restaurant varchar(3)
DECLARE @tablename decimal
FETCH NEXT FROM tables_cursor INTO @restaurant,@tablename
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC ('SELECT * FROM PSMASTBL WHERE RESCOD='+@restaurant)
print @tablename;
print @restaurant;
FETCH NEXT FROM tables_cursor INTO @restaurant,@tablename
END
CLOSE tables_cursor
DEALLOCATE tables_cursor
error
Msg 207, Level 16, State 1, Line 1
Invalid column name 'GSH'.
1
GSH
Msg 207, Level 16, State 1, Line 1
Invalid column name 'GSH'.
2
CREATE TABLE [dbo].[PSMASTBL](
[APPDAT] [decimal](8, 0) NOT NULL,
[RESCOD] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ITMCOD] [decimal](4, 0) NOT NULL,
[ITMNAM] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT (' '),
[SHTNAM] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT (' '),
PRIMARY KEY CLUSTERED
(
[APPDAT] ASC,
[RESCOD] ASC,
[ITMCOD] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
INSERT INTO PSMASTBL( APPDAT, RESCOD, ITMCOD, ITMNAM, SHTNAM) VALUES ( 20090101, 'GSH', 1, 'TEST1', '222')
INSERT INTO PSMASTBL( APPDAT, RESCOD, ITMCOD, ITMNAM, SHTNAM) VALUES ( 20090101, 'GSH', 2, 'TEST2', '333')
INSERT INTO PSMASTBL( APPDAT, RESCOD, ITMCOD, ITMNAM, SHTNAM) VALUES ( 20090101, 'GSH', 3, 'TEST3', '444')
Thanks!
Shinoy |
Edited by - shinoykurian on 04/22/2009 03:27:45
|
|
|
sanoj_av
Posting Yak Master
India
117 Posts |
Posted - 04/22/2009 : 03:37:44
|
DECLARE tables_cursor CURSOR
FOR
SELECT RESCOD,ITMCOD FROM psmastbl WHERE rescod='GSH'
OPEN tables_cursor
DECLARE @restaurant varchar(3)
DECLARE @tablename decimal
FETCH NEXT FROM tables_cursor INTO @restaurant,@tablename
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC ('SELECT * FROM PSMASTBL WHERE RESCOD='''+@restaurant+'''')
FETCH NEXT FROM tables_cursor INTO @restaurant,@tablename
END
CLOSE tables_cursor
DEALLOCATE tables_cursor
|
Edited by - sanoj_av on 04/22/2009 03:39:11 |
 |
|
Error in Execute command
