Viewing 6 posts - 1 through 6 (of 6 total)
If you only need the table temporarily, you could could create #tempTable which you can then use in SELECT * FROM #tempTable
July 23, 2004 at 10:09 am
Oh i forgot - if cID is a numerical field then change the eighth line from
SELECT DISTINCT cID INTO [tab2] FROM [tab1]
to
SELECT DISTINCT RTrim(Cast(cID as char(2))) as cID INTO...
June 22, 2004 at 8:06 am
But that would mean giving the user the right to run any SELECT statement they wanted. I only want them to be able to run the sp. Is it possible...
June 22, 2004 at 7:48 am
tab1 - original data table
tab2 - temp table
tab3 - final output
assuming you have the same number of cID rows for each vID this should work
CREATE PROCEDURE [dbo].[ANewProc]
AS
declare @myVar1 varchar(1000),@myVar2 varchar(1000),@myVar3...
June 22, 2004 at 7:42 am
Sorry I was being stupid - there was another problem, passing the wrong data type into the sproc (and then into the function).
May 6, 2004 at 7:27 am
like this?
SELECT [yearName] INTO #YearTemp FROM [zYears] y
JOIN dbo.iter_intlist_to_table(@Years) i ON y.yearID = i.number
Thanks for the suggestion but it's still not working...
May 6, 2004 at 6:39 am
Viewing 6 posts - 1 through 6 (of 6 total)