T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Merge Statement - Capturing Insert, Update & Delete Counts

  With a Merge Statement is there a way to Capture the Insert, Update & Delete Counts? For bette…

  Welsh Corgi

  7 replies

  14 years ago

  By: Welsh Corgi

• Trouble using GO or other batch command.

  Hello all. SQL Server 2008 T-SQL question but not necessarily about new features. I am stumped. I a…

  kpwimberger

  13 replies

  14 years ago

  By: Gail Shaw

• What is the difference between SubQuery and Joins in terms of Performance

  Hi All, What is the difference between SubQuery and Joins in terms of Performance, I know tha…

  ravi@sql

  4 replies

  14 years ago

  By: Gail Shaw

• SELECT next "jobs" to do

  Hi all, there are two tables, one contains the users, the other contains jobs to be taken by the us…

  Teutales01

  4 replies

  14 years ago

  By: Mark Fitzgerald-331224

• FK referencing PK in *same* table

  Quick Please 🙂 Please tell me what key phrases will lead me to more information about why some tabl…

  xenophilia

  13 replies

  14 years ago

  By: Orlando Colamatteo

• how do you filter against a datetime field?

  I need to filter results of a query by Start and End Date. A simple select * from TICKET where cre…

  KoldCoffee

  8 replies

  14 years ago

  By: Michael Valentine Jones

• Filter Extended Properties by Schema

  I need to filter the statement listed below that it only returns schema that I specify in the WHERE…

  Welsh Corgi

  5 replies

  14 years ago

  By: CapnHector

• Query help to exclude records

  Hello SQL Experts, I have a Inventory data like below Id|Trantype|TranID|TranDate|Qty|QOH| 1|S|S…

  misstryguy

  8 replies

  14 years ago

  By: misstryguy

• Need some help figuring out my first trigger

  I'm creating my first trigger to update a field in another table when a new record is created in an…

  joshd 1807

  5 replies

  14 years ago

  By: joshd 1807

• Repeat and Unique customers at multiple locations

  Hi, Let's say I have a table of locations (currently 3 but can grow), a table of customers, and a t…

  pixelwiz

  10 replies

  14 years ago

  By: pixelwiz

• how to delete all except results of select statement

  How can I delete everything from a table except for the results of a select statement? Like this: …

  Denise McMillan

  10 replies

  14 years ago

  By: drew.allen

• Concatenating xref table columns

  Hello all I have agents in agent table and also cities they can sell for i have a cross ref table w…

  Sachin4all

  3 replies

  14 years ago

  By: roryp 96873

• SQL CLR

  Hi I am looking to get GEO spatial data for supplied postode's for this I want to use SQL cLR,I man…

  SSNEW

  2 replies

  14 years ago

  By: Lowell

• need assistance with MERGE sytax

  trying to compare table A (target) with table B (source) and insert any records that don't exist in…

  a.eckel

  7 replies

  14 years ago

  By: a.eckel

• Blocking Issue

  I am executing below query ....when i execute ..It keep on in executing mode. I think it might be l…

  sqlmaverick

  6 replies

  14 years ago

  By: Evil Kraig F