T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Manupalting ParentID in the table

  I have table with data like this, which gives me a tree structure using parent ID. Seq ParentID …

  skb 44459

  3 replies

  11 years ago

  By: Sean Lange

• Nesting xml

  Hello, I am working on xml from SS2k12 results. I can get it to work with for xml auto; elements bu…

  lmnorms

  14 replies

  11 years ago

  By: lmnorms

• Inserting binary string at an offset to exsting data in a Text type field

  Good morning, I am supporting an application which stores Geometry values in tables for use with Sp…

  duncanburtenshaw

  7 replies

  11 years ago

  By: Koen Verbeeck

• Key Values pairs in string to table

  Hi there, I kind of got stuck with the following problem: A logger (it's Nlog to be specific) log…

  daamruth

  9 replies

  11 years, 1 month ago

  By: ankurtyagi

• Output random dates that falls on a weekday

  I have a column called Transaction Date. I'd like to populate a new date that falls within 12 days …

  JStevenson1

  2 replies

  11 years, 1 month ago

  By: JStevenson1

• Execute a select statement continually - for instance every 5 minutes

  This is probably easy, but I can't find it mentioned.... Anyway, I need to connect to our SQL estat…

  rarara

  5 replies

  11 years, 1 month ago

  By: Sean Lange

• Select records between a date range

  This is my query: SELECT * FROM [MyDateTable] WHERE CONVERT(VARCHAR,StartDate,101) BETWEEN '02/01/…

  Nisha-475382

  18 replies

  11 years, 1 month ago

  By: Jeff Moden

• Sort Order

  Hi, I have one column in table like code. The table contains data like: 01 02 03 04 05 04A 05A 06 I…

  suresh0534

  1 replies

  11 years, 1 month ago

  By: LutzM

• indexed persisted computed columns

  I would like to create a persisted computed column and put an index on it but given all of Microsof…

  lnoland

  2 replies

  11 years, 1 month ago

  By: lnoland

• help me write sql

  I have a table (with data) like the following : Site-id product_id mode quantity date_…

  tirthadip

  3 replies

  11 years, 1 month ago

  By: spaghettidba

• Multiple aggregates using PIVOT

  Hi all, Am working on a reporting project which extensively uses the backend stored procedures. We'…

  Hariharan-202345

  8 replies

  11 years, 1 month ago

  By: samjoseph_p

• Trigger miswritten for bulk update?

  I am not a dba, more of a front end guy. My employer has made what I think is a mistaken decision…

  pbaldy

  9 replies

  11 years, 1 month ago

  By: pbaldy

• Need HELP with using IF or CASE in Where clause..

  Basically, I'm trying to do the below... ============================== DECLARE @period VARCHAR(10)…

  crabjoe

  2 replies

  11 years, 1 month ago

  By: Lynn Pettis

• Getting the MIN value from multiple columns

  Hi all, I need to find a (reasonably) simple way to get the lowest value from multiple columns alon…

  jhager

  2 replies

  11 years, 1 month ago

  By: Lynn Pettis

• Convert Row Data in 1 Field to Many Columns

  Hello this is my first post and my TSQL is average at best so any help will be much appreciated I w…

  Japster

  13 replies

  11 years, 1 month ago

  By: Sean Lange