Topics
Started by
Posts
Last post
Hi. I have 2 tables I wish to compare. Products ProductHistory The current record in Products is wr…
18 replies
Hi All, Racking my brain trying to find a way to return the earliest date from 3 different date fie…
15 replies
Trying to update one of several fields by examining each in order and updating the first that meets…
8 replies
Hi all I am having a hard time figuring out how to write query: Data is like this: 1stname2ndName …
7 replies
I've tables and rows as follow, declare @timerH table (idx smallint,troutehidx smallint,seq tinyint…
6 replies
Hi, I am trying to update columns within a table when several conditions are true (see below). UPDA…
1 replies
hi, I have 2 tables with few columns. i need to show the combination of both tables in a report. pl…
1 replies
I have read that most problems can be solved without resorting to a cursor or while loop. How can I…
4 replies
I am trying to tune a query. The results I ended up with is essentially the same as what is in prod…
6 replies
Hi, I'm having some strange results with T-SQL. I have a table with an ID column. This table has a …
4 replies
We want to be able to break down some really big inserts because they keep filling our log file, ex…
3 replies
I have a #Temp table with between 50,000 and 150,000 rows in it and a permanent table with a couple…
14 replies
I have 15dbs that get loaded daily to dev / UAt etc. This leaves me with approx 90 orphaned logons.…
10 replies
Hello All, My envinronment is SQL 2005. The data in my table is as follow: ID Test 1 …
2 replies
SELECT * FROM FRATERNAL.CONTACTS WHERE MODIFIED_DT = '2009-10-06-12.22.15.008000' returns 1 row SEL…
4 replies
Viewing 15 topics - 4,066 through 4,080 (of 12,234 total)
You must be logged in to create new topics.