T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Row count in temp table

  I have a temptable in my SP where I insert values into the temptable 7 times.i need to keep track …

  Sachin4all

  17 replies

  15 years ago

  By: TheSQLGuru

• SQLCMD problem?

  Hi everyone, when I run the below code manually, I get many results, but when I run it using SQLCMD…

  shahgols

  3 replies

  15 years ago

  By: mister.magoo

• Expression from SSIS to TSQL

  SUBSTRING(ADDR,1,(LEN(ADDR) - LEN(TRIM(REVERSE(SUBSTRING(REVERSE(ADDR),1,FINDSTRING(REVERSE(ADDR),'…

  rocky_498

  8 replies

  15 years ago

  By: SJTerrill

• Inserting into an Table with Identity Column from n number of tables

  Hi, The issue I have is that I have created a Table with Identity option set for the first column. …

  Hakuna Matata

  13 replies

  15 years ago

  By: Jeff Moden

• Building an ARRAY and then LOOP through results

  Looking for information on how to structure the following using t-sql: I am trying to get informati…

  c2k

  5 replies

  15 years ago

  By: Orlando Colamatteo

• SELECT TOP 0 * INTO

  I am running on a 2008 R2 server that has two databases on it. I ran a SELECT TOP 0 * INTO that se…

  knechod

  6 replies

  15 years ago

  By: The Dixie Flatline

• Update Triggers

  hi Objective:I need to find out what are the columns that were updated and the old and new values …

  koustav_1982

  6 replies

  15 years ago

  By: The Dixie Flatline

• FOR XML PATH Question

  Does anyone know how to turn a result set with four rows into one row comma delimited? For example,…

  Mike Scalise

  3 replies

  15 years ago

  By: Mike Scalise

• Need to filter by date range...

  I have the following the tsql that gets me exactly what I need, except its based on the whole recor…

  sql_jr

  16 replies

  15 years ago

  By: Jeff Moden

• Expanding functions within a script

  Can someone possibly help me? I want expand 2 functions within my script so that I don't have to …

  chas.clarke

  6 replies

  15 years ago

  By: Jeff Moden

• While...Union

  I've searched everywhere for a method of combining *many* tables in a database, but everytime i sea…

  kindalost

  3 replies

  15 years ago

  By: Jeffrey Williams

• How do you avoid dynamic SQL with this code?

  Perhaps I should have stayed in bed. I woke up for a code review today and one of the first stored…

  zach_john

  11 replies

  15 years ago

  By: zach_john

• incorrect syntax using replace

  HI all, Iam trying to debug a code, we get some data from a foreign sql server using BCP. the probl…

  prasadau2006

  2 replies

  15 years ago

  By: Sean Lange

• Single Procedure for IUD operations for each masters

  is it advisable to have single procedure for each reference master's Insert,update and delete opera…

  vmssanthosh

  1 replies

  15 years ago

  By: Sean Lange

• Dynamic Cursor not returning updated records

  I'm trying to reduce the number of records that are returned with each fetch next using this cursor…

  Phil Church

  13 replies

  15 years ago

  By: Sean Lange