T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• trigger to call a program to write a text file onto a folder in the server

  Hi to all I have created a trigger to call a program that is written by our program. The program i…

  eseeweb

  13 replies

  12 years ago

  By: crmitchell

• forming a dynamic query

  have a sp with 4 parameters the values of this parameters is obtained from application currently i …

  ssurekha2000

  21 replies

  12 years ago

  By: Jeff Moden

• Current year begin and end dates

  I am working on some payroll related code which currently has the following hard-coded CASE stateme…

  alicesql

  8 replies

  12 years ago

  By: Jeff Moden

• Max with distinct two columns and corresponding third column

  Hi, i need to write a query and can't get it to work no matter how it try. Here's what i need: T1 -…

  stsniper

  5 replies

  12 years ago

  By: bkmsmith

• Select One of Three Values that are Not NULL

  Hello Everyone I hope that you are having a very nice day. I am working on some data that is JOINin…

  AndrewSQLDBA

  3 replies

  12 years ago

  By: Eirikur Eiriksson

• problem in logic for finding a Recursive Cte

  hi, hope everybody doing good, here is my problem this is my data DECLARE @Tbl AS TABLE (Mainid…

  thava

  11 replies

  12 years ago

  By: thava

• Turning raw data into a grid layout

  Hi all, not sure how best to explain what I'm trying to do so will try to break it down as easy as …

  Tava

  14 replies

  12 years ago

  By: alex_2356

• Create batch file to selectively run SQL files

  I have about 1200 sql files in one of my folders. Almost all of these files do data inserts and upd…

  SQLCurious

  9 replies

  12 years ago

  By: SQLCurious

• Delete Table records with Bakup

  Hi Team, using below query DELETE FROM Table_name WHERE Date_column < GETDATE() - 30 am able to …

  Minnu

  7 replies

  12 years ago

  By: Jeff Moden

• Query XML data for blsnkd

  Hi I am try to see if there are any blanks in a node of a table that has xml data in one of the col…

  jdbrown239

  1 replies

  12 years ago

  By: Eirikur Eiriksson

• Altering a table is taking lot of time

  Hello, I have a table , having 900 records. I tried altering the table but it is taking decades to …

  Shadab Shah

  5 replies

  12 years ago

  By: Grant Fritchey

• TimeZone conversion in sql server 2008

  How i can convert my timezone in sql server, My requirement is to save date in client time zone no…

  purushottam2

  6 replies

  12 years ago

  By: adss2009

• t-sql start position of number value in a string

  In t-sql 2008 r2, I would like to know how to select a specific string in a varchar(50) field. The …

  wendy elizabeth

  6 replies

  12 years ago

  By: Luis Cazares

• Outer Join performance

  Can someone please give me advise on a better way to write the following? SELECT a.BoxId, b.field1 …

  robin.pryor

  12 replies

  12 years ago

  By: Eric M Russell

• Remove a Simple Duplicate

  Hello Everyone I found some duplicate data as I was going thru the logic of a data pump. The entire…

  AndrewSQLDBA

  4 replies

  12 years ago

  By: a4apple