Topics
Started by
Posts
Last post
Hi all, I have a query that uses the optional T-SQL extension second FROM word in an sql query: del…
5 replies
By: Sergiy
I have two stored procedures that update a table. The 1st updated a column called PingReceivedCount…
3 replies
By: Sergiy
Hello all. I run a bunch of DBCC tasks this weekend using sp_MSforeach... and it work great. I have…
1 replies
By: sbauer
I see many people (in my working environment and also here in this forum) ask "strange" questions a…
16 replies
By: Sergiy
Hi All, I have a stored Procedure which calls 2 other procedures Through a cursor.These two nested …
1 replies
By: sbauer
Hello, I want to avoid using cursors, however I am stuck in this problem: I have two tables. In ta…
5 replies
I've a table where it holds data for calls I want to set a column to 1 or 0 depenting on a function…
12 replies
Hi I want to delete specific tables from database .Let us say I have to delete tables which names s…
5 replies
In SQL 2000 ; complex query using linked server fails with [Microsoft][ODBC SQL Server Driver…
2 replies
Hi, i have got a hierarchy of samples that have activities carried out on them. when i edit a batch…
1 replies
Hi, I'm trying to set up an audit trail of amendments on fields that a customer chooses to monitor.…
2 replies
I have a 4 parts of query in the first 3 parts iam inserting the output into a temporary tables(by …
2 replies
hi all, I need query for the following requirement. Table1 has four columns as col1,col2,col3 …
1 replies
Hello All, We have several tables that grow by large amounts of data on a daily basis. The first t…
3 replies
Hello, I'm a little rusty on sql querries, and need to check myself on the following query; SELECT …
4 replies
Viewing 15 topics - 7,246 through 7,260 (of 17,082 total)
You must be logged in to create new topics.