Topics
Started by
Posts
Last post
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
Hello Please help me to do this CREATE TABLE #X1 (vcEmployeeUniqueID VARCHAR(20), vcLastName VARC…
5 replies
Would like to Run Stored Procedure on remote server and store the results in temp table. I am hopin…
3 replies
Im performing some calculations and I need to round up the 2 decimal places to the next highest pla…
2 replies
I am calling a stored procedure from an SSRS report. My stored procedure declares a table variable …
1 replies
Hi guys Trying to gear up my T-SQL skills When dealing with subqueries, like below select Col1 from…
8 replies
Viewing 15 topics - 4,786 through 4,800 (of 10,636 total)
You must be logged in to create new topics.