Topics
Started by
Posts
Last post
MSSQL 2000 I am using the following procedure to create a simple cursor, and within that cursor to …
1 replies
The situation: We have 2 servers, one for web and one that runs SQL Server 2000. Last week our serv…
5 replies
Hi, Thanks in advance. Does any one have SQL Script to find out when "data" was modified/updated in…
3 replies
Guys, I have scenario where in a column - col004 I have following data col001col004 ______________…
25 replies
Hello, Some suggestion from you: A Table should be read and then purged it to fill again later: the…
5 replies
I'm executing a line of code from a remote box that is linked into a remote server. (sa-->…
1 replies
I have a stored procedure in a main database that I'd like to use in several other databases. …
5 replies
How can I get the TOP 1 result per group, not per result set? Example: --DROP TABLE #Test CRE…
3 replies
Hi Guys I need to calculate the percentage in a new column and I have posted the samle data The per…
2 replies
Test Data: CREATE TABLE #Example ( ProductID int, ProductName varchar(15), …
6 replies
Hi, I have a table consisting of two fields, both int, CompanyID and CategoryID CompanyID, Category…
5 replies
I have a sp shown as below, I will pass parameter @criteria = 'MajorDeliveryChannel' Both E…
6 replies
Hi, I have a column name strpropertyname VARCHAR(30) which is available in more than 25 tables. Its…
6 replies
Hi, I have executed the following query... select text from syscomments where id = 2099048 This is …
2 replies
I have a stored procedure that updates a number of records in a table. As soon as I run the s…
3 replies
Viewing 15 topics - 4,141 through 4,155 (of 17,082 total)
You must be logged in to create new topics.