T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need to consolidate Queries sysjobs, sysjobhistory, sysjobschedules

  I need to modify the first query listed below so that it contains information from the second query…

  Welsh Corgi

  8 replies

  12 years ago

  By: Welsh Corgi

• Pivot and Unpivot in same query

  Hi, I have below table and within same query i need pivot and unpivot. create table #temp(name1 va…

  latitiacasta

  4 replies

  12 years ago

  By: TEJABI

• SQL Query Help - Thank you.

  Hi Guys, I need some help please, I have two tables listed below, the first table has employees pay…

  DiabloSlayer

  2 replies

  12 years ago

  By: DiabloSlayer

• Matching Closest Time between two columns between tables

  I have a temperature table with a column that shows the how many hours old a newborn was when his/h…

  Vertigo44

  2 replies

  12 years ago

  By: Dwain Camps

• Trouble with a MERGE statement

  My experience with MERGE statements is kind of limited so please bear with me. I'm trying to modify…

  RP_DBA

  6 replies

  12 years ago

  By: RP_DBA

• What am I Missing ? Converting Legacy Code

  We have some legacy code with old style *= LEFT JOINs that I need to convert. I'm getting error:…

  homebrew01

  2 replies

  12 years ago

  By: homebrew01

• Question on Indexes

  Hi all, Got a couple of quick questions regarding indexes. Lets say I have a table with five column…

  kramaswamy

  1 replies

  12 years ago

  By: Gail Shaw

• How to show total sales?

  Hi Friends, My Table struct create table cust ( cust_id int , city varchar(20), pincode int, sa…

  raghuldrag

  6 replies

  12 years ago

  By: serg-52

• Need to return Jobs that are in Progress

  Hi SQL Gurus :-), I have a query that returns the jobs that have completed for the nightly processi…

  Welsh Corgi

  6 replies

  12 years ago

  By: MyDoggieJessie

• Split a pipe delimited string into two columns

  Hello all, I have a single string "XYZ00001|Test_b|XYZ00002|Test_a|XYZ00003|Test_c" that will cont…

  Moe_Szyslak

  5 replies

  12 years ago

  By: Jeff Moden

• t-sql use two cte

  In existing t-sql 2008 that I need to modify, there is already an existing cte that looks like th…

  wendy elizabeth

  14 replies

  12 years ago

  By: The Dixie Flatline

• Filter Records In Table

  I have a table that has multiple records as illustrated in the simple list below. The real list is…

  defyant_2004

  9 replies

  12 years ago

  By: defyant_2004

• ON Cascade Delete Option..

  Hi I Understand, when you delete a row in the parent table, the database server also deletes any r…

  Dark Knight

  2 replies

  12 years ago

  By: SQLBlimp

• Identifying Current Record

  I have a snapshot table of about 15 million records in the form of: InvoiceIDLineItemIDSnapshotD…

  rka

  6 replies

  12 years ago

  By: Grant Fritchey

• Catch Block with GOTO statement

  Hi All, I have a Stored Proc which populates a table and then uses BCP to output the table into a f…

  dbalmf

  7 replies

  12 years ago

  By: dbalmf