T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Forcing the Order

  Obie kabie. Granted that indexing is incomplete here, but the optimizer isn't whining about it miss…

  Evil Kraig F

  14 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Add Primary Key to Existing Table

  I need to add a primary key to an existing table of 30000 rows. Is there no way to do this without …

  hkflight

  8 replies

  14 years, 10 months ago

  By: jarid.lawson

• Unexpected 'Case else' behavior

  Hi All, I am trying to populate a column in my table with data from a set of potential values. To d…

  Tom Rippetoe

  10 replies

  14 years, 10 months ago

  By: Tom Rippetoe

• Combining two tables to create a cross set

  Please forgive the title; here's the deal. I have table1 with the 100 rows; 1,2,3,4,5, etc... table…

  SteveGravley

  2 replies

  14 years, 10 months ago

  By: SteveGravley

• Need help on SQL statement

  My sql as following, declare @tMenuCollection table (idx int,parentID int,menuNme varchar(50),navig…

  miss.delinda

  7 replies

  14 years, 10 months ago

  By: miss.delinda

• current month and ytd join question

  ok, so i have written a query that gives me the counts for current mont. I have also written a quer…

  danielle476

  2 replies

  14 years, 10 months ago

  By: danielle476

• Backup script with specific needs

  Hey guys. I have looked for a script for this for some time - but haven't been able to find EXACTLY…

  kingrudedog

  3 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Pivot or?

  Here is the table, mind you it's in a raw format and is for testing only so it not named properly. …

  tictoc

  35 replies

  14 years, 10 months ago

  By: tictoc

• Problem with fetch and cursor

  Hi, For the past two days, I was trying to manipulate the results from test table to test_temp tabl…

  yingchai

  5 replies

  14 years, 10 months ago

  By: yingchai

• UPDATE with WHERE clause frowned upon by OUTPUT?

  Hi Folks, Wondering if you can help me... I was trying to help a friend with something and landed u…

  diamondgm

  5 replies

  14 years, 10 months ago

  By: diamondgm

• Goruping records with 1 to many relationship

  I am trying to extract data from a source table where groups of fields in one table can relate to m…

  eseosaoregie

  3 replies

  14 years, 10 months ago

  By: eseosaoregie

• Which Way Is Faster?

  I'm trying to tweak some of my scripts for increased speed, and I realized there are a few areas th…

  jarid.lawson

  8 replies

  14 years, 10 months ago

  By: jarid.lawson

• How to find all customers that has 2 different tickets in order

  I have a table of customers (CustId , Name , Phone,City ) and table of tickets (TicketId,CustId,Sub…

  Shai Bar-Lev

  3 replies

  14 years, 10 months ago

  By: Jeff Moden

• DATEADD ignoring DATEPART

  Can someone tell me why my statements are adding days instead of weekdays? The returns on all of t…

  K430

  4 replies

  14 years, 10 months ago

  By: K430

• need script to take back up of only failed backup jobs for the user databases (by cheking the latest backup job failures)

  Hi everyone, I am looking for the script to take the backup of only failed backup jobs example i ha…

  smileswithharish86

  1 replies

  14 years, 10 months ago

  By: Michael Valentine Jones