Topics
Started by
Posts
Last post
Hi, I've got a huge Union query as the result of using the SQL XML functionality of SQL2K. There ar…
3 replies
How can I compare values in two text fields? Any help is appreciated. Thanks -GJK
8 replies
I have set up a linked server between two sql servers (both with SQL 2k/sp 3a). When I issue a dist…
5 replies
Hi, In the past we've used the TSEQUAL function to guarantee concurrency in our sprocs. Howev…
4 replies
The following is from a stored procedure ... CREATE PROCEDURE spUPINupdate_NSI(@Profile_ID varchar(…
4 replies
Example: declare @stmt varvhar(255) set @stmt = 'SELECT COUNT(*) FROM EMPLOYEE' EXECUTE (@stmt) &nb…
3 replies
Help Please... I have a four col result set from a union query. id desc count flag …
7 replies
I am trying to read a CSV file inside a Stored Procedure. I have a temporary table and using the be…
1 replies
I have a stored procedure which uses TABLOCK hint when executing. It works fine from QA. However, w…
1 replies
Hi, I've seen something like this here before and have been unable to dig it up. I need to be able …
2 replies
Hi, I have 2 very similar sprocs. 1) spJobHistoryGet SELECT * FROM tblJob WHERE isJobCompleted = …
2 replies
I have a stored procedure in SQL server 2000 that has a statement like this SET …
4 replies
I am using the following script to attempt to obtain a file list from a mapped drive. (The drive is…
7 replies
I am writing a stored proc to generate html from a result set however I always get the dotted line&…
8 replies
Here is a query that is getting me general results: CREATE PROCEDURE [dbo].[stpGetRBC] @CNB v…
1 replies
Viewing 15 topics - 13,891 through 13,905 (of 17,082 total)
You must be logged in to create new topics.