Topics
Started by
Posts
Last post
I was wondering how can I check who has created the table in sql server 2005? Right Click -Properti…
6 replies
The below query is giving me 4 rows instead of 1 row i.e I am getting the same answer 4 times in my…
3 replies
Using TSQL, is there a way to determine whether a .txt file is in use by another process ?
1 replies
Hi Trying to get the below query to work and having a little trouble, Basically if you run it as is…
8 replies
Hi Everyone, This one has be puzzzled. I have a sp that runs fine on its own like so: exec dbo.dsbn…
3 replies
Hi I run the following statements as part of a stored procedure. The output is approx 300,000 rows …
5 replies
I am trying to build a report for errors that i encounter when reconciling a customer report. The f…
2 replies
I have created a stored procedure that accepts a date as parameter and then goes on to produce an o…
2 replies
I have recently seen a few T-SQL queries starting with “WITH” I understanding what’s happening I am…
55 replies
Hi all, I've got a code that simply loops through rows in a table using cursors. I've noticed for e…
4 replies
Hello, I was given the task to write a query to produce both Discharge Information and Incompletes.…
5 replies
Hi, I have this structure of stored procedure : CREATE PROCEDURE sp1 ( @ret varchar(100) output ) A…
13 replies
hi friends, i think people in this group hate cursor and i agree with it. Just looked into our exis…
4 replies
Hi all, I need to create sql script which will go through all records and find smallest unused numb…
38 replies
I want to pass selected Ids to stored procedure to get details from client table. If I dont pass se…
11 replies
Viewing 15 topics - 7,126 through 7,140 (of 10,647 total)
You must be logged in to create new topics.