T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• DEMO_CODE = 'DE1'

  Hi everyone. I have these two records in [prj_demo_data] table: prj_code demo_code decmo_…

  RVO

  5 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• t-sql load values from stored procedure into a temp table

  I would like to know if the following sql can be used to obtain specific columns from calling a sto…

  wendy elizabeth

  1 replies

  11 years, 10 months ago

  By: Jeff Moden

• comparison in the merge statement about null values

  I use the merge statement in a sproc to insert, update and delete records from a staging table to a…

  sqlfriend

  28 replies

  11 years, 10 months ago

  By: Paul White

• 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months ago

  By: adss2009