T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Simple Query could be possibly more elegant?

  Just wondering, I have this query: select ProductID, SUM(OrderQty) nOrderQty, SUM(ScrappedQty) n…

  Rokh

  4 replies

  13 years, 8 months ago

  By: Ninja's_RGR'us

• Help for FOR XML PATH

  Hello, I'm can't seem to figure out how to get my XML to format the way I need it. I created a sa…

  john.parker 39819

  2 replies

  13 years, 8 months ago

  By: john.parker 39819

• Dynamically checking rows in a table for data changes in SQL

  I have a table (example testing code below) that has a number of records grouped for a particular i…

  Griffster

  11 replies

  13 years, 8 months ago

  By: Griffster

• SQL Job with IF Criteria

  I would like to create a job for SELECT datediff(n, dc_date ,last_start_date) FROM PARM if the outp…

  skb 44459

  2 replies

  13 years, 8 months ago

  By: Lowell

• Email Trigger If Statement

  Hi all I'm creating a trigger that should send a mail if a stockcode is created in the inventory ta…

  spin

  2 replies

  13 years, 8 months ago

  By: Phil Parkin

• TSql help

  I cannot get this to work. I believe it is because of the date columns (they do not match exactly).…

  npeters 86796

  3 replies

  13 years, 8 months ago

  By: Jeff Moden

• SQL Standards

  Hi All, I searched on google and came to know about the list of SQL standards. SQL-86 SQL-89 SQL-9…

  karthik M

  1 replies

  13 years, 8 months ago

  By: Jeff Moden

• BULK INSERT From Source Containing Too Many Fields

  Is there a way to capture improperly formatted source records when all of a source file's records c…

  lawrence.raiders

  1 replies

  13 years, 8 months ago

  By: kramaswamy

• I need a view to insert records to a table

  I've gotta set up a view that either drops; re-creates and inserts records into a physical or temp …

  latingntlman

  2 replies

  13 years, 8 months ago

  By: Lowell

• Returning Month (number) as char(2)

  Trying to return current month as a char(2) Ex - July would return '07' I need two characters exact…

  j_maloney

  3 replies

  13 years, 8 months ago

  By: j_maloney

• Stored procedure problem

  Hi Folks, I have some issues with stored procedure on SQL Server 2005. My Conditions: 1-by date r…

  maxcoder1@gmail.com

  2 replies

  13 years, 8 months ago

  By: Sean Lange

• Fill in the blanks...

  I have this query that is giving me issues, if you have any suggestions they are apperciated! Task:…

  marty.seed

  6 replies

  13 years, 8 months ago

  By: ColdCoffee

• Create a field incremental counter

  I have a SQL 2005 table (Table_A). One field (File_Name) may contain many instances of the same val…

  DerbyNeal

  2 replies

  13 years, 8 months ago

  By: Steve Jones - SSC Editor

• Tranpose Column values into Column name

  Hi All, I have to transpose column values into column name. I see there is a little bit trick in th…

  karthik M

  7 replies

  13 years, 8 months ago

  By: karthik M

• Inserting data into a column with different colation

  Hi, I have a table where the columns are set to Polish collation (in order to store Polish characte…

  phil_mw60

  1 replies

  13 years, 8 months ago

  By: Lowell