Search results for query: *

Tried specifying all fields and it worked perfectly. Thanks for the replies SQLSister and fluteplr. No more head pain.

I have two views that pull two sets of data. The order of the columns in the two views are exactly the same: View1 - Standard, WaterLevel, FixedCost View2 - Standard, WaterLevel, FixedCost I then run a SQL statement that creates a union: Select * From View1 union Select * From View2...

Terry, thanks very much. I was passing the list with single quotes around the whole thing, but not building sql statement dynamically. I did this, and it works fine. Thanks for the help, and sorry about the similar post on the in clause, but I couldn't find it Friday in a search. Have a...

I am using Cold Fusion to call a stored procedure and pass a list of values to the "Where" clause (ie. Where ID IN (1,2,3...)). The procedure errors because when the comma delimited list is passed, the stored procedure thinks that the delimiting commas are seperating additional...

Thanks for the replies. Terry, Your suggestion to break up the unions into steps worked perfectly. I appreciate the help. After searching at length for an answer somewhere, you have finally given me the solution. You've made my day! Trey

I am running SQL Server 2000. If the total number of tables can cause a problem then this might very well be the case. When combining all of the views in the stored procedures using unions, the total number of tables would most definitely be over 16 in my case. I will attempt to use the temp...

I am getting this same error. When I reduce the number of unioned views to five the procedure runs fine. If anyone has any information it would be greatly appreciated.