T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Table that has all the dates from 2000 till today

  HI. I need a date table that has all the dates from 2000 till today. the Table should look like as…

  patelronaks1983

  11 replies

  14 years ago

  By: John_Hill

• FIFO problem....

  Hi all I’ve been using this brilliant solution for FIFO calculation that is found here, (Dave’s one…

  sterjo

  5 replies

  14 years ago

  By: sterjo

• Updating multiple values from 1 table to another

  How can I update multiple values in 1 table based on the values from another table, do i need to us…

  umar.memon

  15 replies

  14 years ago

  By: Sean Lange

• Preparing Demo database for sales purpose

  Hi Gurus, Could you please tell me how to prepare a demo database for sales team? I have to write …

  ArjunaReddy

  9 replies

  14 years ago

  By: Lynn Pettis

• Read Text File

  I am working in an SQL Server 2008 R2 environment and I wish to add a routine to my T-SQL script th…

  JayWinter

  4 replies

  14 years ago

  By: MVDBA (Mike Vessey)

• EXECuting a dynamic string

  I am urgently in need of some help. My colleague and I have developed a script (that works) but use…

  Darryl Wilson

  8 replies

  14 years ago

  By: Sony Francis @EY

• Query XML

  I'm wanting to query an XML site, which is really just an RSS feed. I want to be able to put the d…

  jordon.shaw

  3 replies

  14 years ago

  By: Orlando Colamatteo

• Need T-SQL for this requirment

  I have a table where it lists all the "ServerName", "DBName", "DBSize", "Date"...but this table has…

  SQLisAwe5oMe

  6 replies

  14 years ago

  By: SQLisAwe5oMe

• passing information to sql trigger

  I have a trigger that will write out an audit trail record with the changed values to an audit file…

  johnr104

  5 replies

  14 years ago

  By: mtassin

• Question about Index Usage

  Hi, I had been working on some code improvements for performance gains every now and then. I was go…

  chandan_jha18

  2 replies

  14 years ago

  By: Gazareth

• use with dynamic sql

  I'm trying to do in a script: SET @DYNSQL = 'USE ' + @DBName + ' SELECT name AS [File Name] , phys…

  Sailor

  3 replies

  14 years ago

  By: Sailor

• Triggers

  Hi all, I am new to sql server, How to write a trigger which stops the DML operation on a table for…

  maheshkrishnas

  16 replies

  14 years ago

  By: Eugene Elutin

• Translate this PL/SQL code into T-SQL for SQL Server.

  Dear All, Its is very urgent , I am new to PL/SQL. Kindly help me to translate this PL/SQL code int…

  reluc23

  5 replies

  14 years ago

  By: reluc23

• SSMS stops while showing query execution plan

  hi when i am showing estimate execution plan,SSMS just stops working. what causes it to stop workin…

  riya_dave

  6 replies

  14 years ago

  By: Eugene Elutin

• Like query from another table

  Hi, I have a table Account with two columns Ac_no and code_list. Ac_no Code_list 12345ab…

  Dhruvesh Shah

  7 replies

  14 years ago

  By: Dhruvesh Shah