Topics
Started by
Posts
Last post
Hello, We have a large number of Intermediate and Aggegate tables that are populated daily. We have…
6 replies
I need help with the query below. The OpenedTot column has a value of 1 for each row which is not c…
5 replies
Basically I have 2 tables, I need to update a field in one if there is NO match to the other Update…
3 replies
OK, here's my problem: I have an orders table, oeOrders, which has a primary key based on a billing…
3 replies
Hi Guys, I have to build a select statement as a varchar (@SQL) then iterate through it one line at…
18 replies
Hello, I was looking for some documentation on how to reference a database on a different instance …
3 replies
When running one of our procedures we get teh following error msg. "Error encountered with Exceptio…
2 replies
I tried to add a new constraint : ALTER TABLE dbo.Issuers ADD CONSTRAINT Chk_Issuers_Rating_MustBe_…
4 replies
I have a table called Start_Times_T that has a field called Time_VC, Time_VC is a varchar field tha…
5 replies
How do I subtract 1 day from a date? For example, if GETDATE() returns 2004-12-12, how do I make it…
3 replies
Displaying every combo of unique id values I have a table with an ID and desc ID Desc 1 …
18 replies
I keep getting the following error when trying to execute a trigger which updates a linked server. …
2 replies
Hi, I am new to SQL Server but not to the SQL language. I currently have a select clause which prod…
3 replies
I am looking to adapt the below query to rename a particular field if it is duplicated. It can have…
5 replies
Is there a function within SQL to convert any negative values to positive and the positive ones to …
6 replies
Viewing 15 topics - 11,611 through 11,625 (of 17,082 total)
You must be logged in to create new topics.