T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• On update, log old/new values along with column_name into another table

  Hi, I need to log data into a log table when there is update to a table. On every UPDATE to most co…

  Santhoshkumar KB

  3 replies

  15 years, 5 months ago

  By: Santhoshkumar KB

• Eliminate Duplicate Descriptions for UNIQUE Key value

  I have a master file that I have inherited which has duplicate Rows for the same Account Code due t…

  BitLeftOfCentre

  11 replies

  15 years, 5 months ago

  By: LutzM

• "Invalid Column" syntax error when using IF EXISTS

  This is annoying and I can't seem to find a solution I like. At my workplace, we have to build our …

  Brandie Tarvin

  2 replies

  15 years, 5 months ago

  By: Brandie Tarvin

• Generic insert scuppered by a timestamp column

  Hi, I have a loop to populate tables from a production database into a UAT database whilst applying…

  Alan G-436699

  3 replies

  15 years, 5 months ago

  By: Brandie Tarvin

• "Case When Then" Issue When Concatenate After Calculation

  Hi, I have a data that is stored in MB. I was trying to convert from MB to GB if the data is over …

  EjSQLme

  8 replies

  15 years, 5 months ago

  By: EjSQLme

• Incrementing a column during an UPDATE

  I have some database corruption and need to write an SQL script to rectify it. Basically I have som…

  Toby Summerfield

  6 replies

  15 years, 5 months ago

  By: Toby Summerfield

• Try/Catch does not work.

  I came sccross a problem where Try/Catch block did not catch an error. Here is a part of my code wh…

  Mark Shvarts 1

  13 replies

  15 years, 5 months ago

  By: sushrenu_sajjan

• INSERT EXEC can't be nested!

  use distribution; declare @sql varchar(1000) set @sql='sp_replmonitorhelpsubscription NULL,NULL,N…

  webc

  6 replies

  15 years, 5 months ago

  By: webc

• is there really no way to do this? turn rows into columns?

  /* I've been looking in vain for a while now for a solution to the problem of turning rows into col…

  bagofbirds-767347

  9 replies

  15 years, 5 months ago

  By: Lowell

• Change Connection with T-SQL

  Hi. Normally we change connection to another server by Right click or click (Change Connection butt…

  Ronsi-384491

  7 replies

  15 years, 5 months ago

  By: scott.pletcher

• Combine Two Tables

  Hi, I'm trying to select distinct records from TableA and TableB below, but I'm getting multiple re…

  EjSQLme

  4 replies

  15 years, 5 months ago

  By: EjSQLme

• Frequently used joins

  Hello: I 'm starting to manage a very big non-documented database created by another people. I wish…

  lverea-783150

  2 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Concatenate multiple text fields in a view

  Hi all, My problem is as follows: I have a table that contains fields as shown below ctxt int clan …

  Alexander de Rooij

  4 replies

  15 years, 5 months ago

  By: Alexander de Rooij

• CATCH blocks are resumptive, unless ...

  another subtle gotcha! with TRY CATCH CATCH blocks are resumptive unless there is another TRY block…

  DataDog

  4 replies

  15 years, 5 months ago

  By: DataDog

• Msg 241, Level 16, State 1, Line 1

  getting this error when I run this function: Msg 241, Level 16, State 1, Line 1 Conversion failed w…

  sql_ques

  1 replies

  15 years, 5 months ago

  By: spaghettidba