Topics
Started by
Posts
Last post
Hi, I have i temp table as CREATE TABLE #TEMP (ID INT) In this temp table i would be having 2 or mo…
1 replies
Hi I must have done something really bad in a previous life as most of my current work involves da…
6 replies
dear friends, I need to group records. the sample data below is result of collected data from diffe…
8 replies
Hello Everyone I am working on a query that uses a Computed Value to determine the Value for the ca…
4 replies
Hi - I have two tables in the same database. Table1 has a structure like this: AID IsStaffTask 1 …
16 replies
I know there is a function in sql to grab the a field value for the next row. I have seen it befo…
4 replies
I have a recordset that returns the following data: ItemNumberDisplaySeqNum 101 2 3 4 20…
8 replies
Hi all, I need to write a stored procedure that moves large amounts of old data on a nightly basis …
11 replies
hi, need help removing leading zeros from alpha-numeric column: Before After 12345 = 12345 00123…
11 replies
I have a challenge. One of my jobs is to produce reports on data found in 7 different databases (an…
1 replies
Hi All, I need to dump the XML query results into a file using the stored procedure below without …
6 replies
Pls give me a query for to select second maximum of the result set. a,b is column names. insert (a,…
5 replies
Is it possible to do write statement like : select item, dbo.StoredProcedure1(QtyAvailable) from It…
1 replies
Okay, there has to be a better way to to what I want to accomplish, I just can't figure it out. I …
6 replies
Hi all, I have to make the following, but I've had no luck getting it done. Can you please help? …
6 replies
Viewing 15 topics - 4,786 through 4,800 (of 10,647 total)
You must be logged in to create new topics.