Topics
Started by
Posts
Last post
I have table in which the accountnumber will contain both numeric and character data. When d…
17 replies
Hi I'm writing a stored procedure in sql server 2000. I get some data from a table and put it into …
4 replies
I'm trying to update specific columns in a table with data returned from a DBCC but cannot fig…
7 replies
I need to calculate Cost of Goods sold for a particular item. Basically, I have 2 tables. One…
7 replies
Hi all, I am trying to use the UPDATETEXT functionality across a linked server and am not sure if i…
5 replies
By: pgraves
I have a view written that extracts part number and qty booked as scrap from our inventory tables. …
13 replies
i need help on this.when i run this proc i am getting duplicates. set …
6 replies
By: Vladan
I'm stumped - why does the first query perform worse? The table has appx 20 million records. There …
11 replies
I have an issue whereby I need to split records with a duration > 30 mins, creating a new record…
20 replies
I have an issue where I have a variety of stored procedure calls that for different client bases co…
3 replies
By: Sergiy
Hello, I want to move a vba script to the SQL Server, so I can schedule it. This data is dumped fr…
2 replies
Hi I have a problem which is driving me nuts. The stored procedure (listed below) runs OK on existi…
6 replies
Hi I need to be able to generate the last Friday after passing on a date, say for example using tod…
11 replies
how to split select result to dynamic field i explain i have table like this sn fld 1 …
5 replies
I need to query a list of numbers and find out how much space is between them. e.g.: 1 10, 8 blanks…
5 replies
Viewing 15 topics - 4,906 through 4,920 (of 17,082 total)
You must be logged in to create new topics.