Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wes987654
- Content: Threads
- Order by date
-
query vs stored procedure
I have a query that runs perfectly and it uses a function fn_split. It works just fine but when I put this query in a procedure it no longer works and tells me that fn_split is undefined?... Any ideas? I would also like to know what the ; infront of the with is for if someone would enlighten...- wes987654
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Query suggestions
I have the query below that tells will get an item number where a order exists. I pass in a string of 'SBCORD10949415', 'SBCORD10953377' as a parameter. I need to be able to tell if any ordernumbers passed into the parameter do not exist so I can flag them in the UI. Any ideas on how to go...- wes987654
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
