Search results for query: *

Thanks. I'd have run into that brick wall all day. Now I can move on to the next task.

I am trying to run a stored procedure that initially takes a dynamic SQL input string (@query), proccesses the dynamic string which is supposed to create a temp table which is referred to by later segments in the stored procedure. Each time I run the procedure I get an error that says 'Invalid...

I have an ASP page which has several dropdown boxes which allow the user to select multiple items. I have been trying to get the stored procedure to return the filtered recordset but am having trouble with the appropriate use of apostrophies in the string parameters. Also, is my use of the...

I tried the code suggested by tlbroadbent within my stored procedure but can't get it to return any records. I've gotten the following code to work by passing the dynamic SQL statement using "Set rsGraph = cmd.Execute" within my ASP. I would really like to use the stored procedure...

I am trying to create a stored procedure which will return counts so that I can graph the results. I am using a GROUP BY ... WITH ROLLUP to create the default recordset which will have the count column, and two others (selected by the user). I would like to pass the names of the user selected...

I have an ASP page which displays statistics of my database (# of records matching specific criteria). There are approx. 50 stats that need to be gathered and passed back to the calling page. I have the following code to return the first 4 stats, but rather than returning the "MA&quot...

I'll read up on Crosstab queries. Thanks for the suggestion.

I tried using UNION but the result was a single column recordset. If possible I'd like to return a single record having 50 columns, each having a column name which corresponds to the text string criteria (ie. CRW). Thanks for the help.

Is there a way to have a stored procedure return the results of approximately 50 queries as a single recordset? Each query returns the number of records matching a particular parameter and I need the results of 50 queries to populate a results table on an ASP page. The individual queries are...