Search results for query: *

CREATE FUNCTION claim_procs ( @claim varchar(12) ) RETURNS @pivot TABLE ( proc1 char(5), qty1 int, proc2 char(5), qty2 int, proc3 char(5), qty3 int ) AS BEGIN declare @temp_pivot table ( proc# char(5), id_num int IDENTITY(1,1), rec#...

Hi stnkyminky, It took me awhile to refresh my memory. So I was trying to create a table claim#,proc1,qty1,proc2,qty2,proc3,qty3 using the following query: select claim#,y.proc1,qty1,y.proc2,qty2,y.proc3,qty3 from claims_tables, udf_claim_procs(claim#) y I mistakenly expected that for...

Thank you for your response. You are probably right. I assumed that in my case the UDF result set(table) is working like a correlated subquery in the FROM clause and produces result set for each claim# from the outer query. I'll try to modify UDF. Thanks again

Hi there, I'm running the following query (SQL Server2000): select claim#,y.proc1,qty1,y.proc2,qty2,y.proc3,qty3 from claims_tables, udf_claim_procs(claim#) y udf_claim_procs is a user-defined function accepting one parameter claim# which is a primery key for claims_tables, and...

Thank you for you response. Unfortunately it does not work that way when subreport is based off a stored procedure with the same set of parameters that a main report. when I link the reports on a set of parameters, subreports promt for the main report passed parameters and for subreport's...

If anybody knows how to link a main report to a subreport on a parameter value if both are based off store procedures? I would like the main report's parameter values are passed to the subreports store procedures. I know how to do that if subreports a based off linked tables, but need to...

If I undestand correctly what you need to do - the solution is very simple: update asset set department = u.department from asset a,users u where a.login = u.login

In fact what your query does is the following: select * from activity where product_code between 'committee/104' and 'committee/199' and thru_date >= getdate() and action_codes in ('m','a') order by product_code What exactly you want to do?

Try this: Execute ('ALTER TABLE eodReport ADD' + @idx + ' int')

Follow the recommendations in the article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304692 I used those recommendations when moved SQL Server DBs across the network.