T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• ROW_NUMBER() function with a difference

  Hi all This one has got me stumped..... I'm trying to track patient movements around our hospital a…

  richardmgreen1

  8 replies

  9 years, 3 months ago

  By: richardmgreen1

• Get Relation ship between TeamLead and SE

  Hi, Table Emp: Id Name Designation Teamlead 2 Ravi TL 1 3 Krishna…

  suresh0534

  3 replies

  9 years, 3 months ago

  By: Jeff Moden

• Return Column Names of changed values between rows

  Hi, first post, I have search the forum but found nothing directly related to my issue. Given 2 row…

  austinjreid

  4 replies

  9 years, 3 months ago

  By: rob.miller 20642

• Using FOR XML EXPLICIT with XQuery: how to remove empty namespace?

  Consider this (very simplified) scenario : DECLARE @Records TABLE ( Idint, Codevarchar(10), …

  Kurisotofa

  1 replies

  9 years, 3 months ago

  By: Kurisotofa

• Nested Case?

  Right now I have this and it is not working. CASE CAS.TERM_YYYYMMDD WHEN '' Then convert(varchar,C…

  gehrlekrona

  6 replies

  9 years, 3 months ago

  By: gehrlekrona

• Moving data older than 30 days

  Hello, SQL Newbie here - need to move data to another table after it's 30 days old - not getting an…

  regrahc

  5 replies

  9 years, 3 months ago

  By: Jonathan AC Roberts

• HTML Email Body To Combine 3+ tables

  Hi All, I am trying to add more than 3 tables results in the HTML body. THe code is below... DECLAR…

  MSSQLBuddy

  3 replies

  9 years, 4 months ago

  By: Phil Parkin

• Trigger: Looping though multiple rows in the deleted table?

  Hi, I'm trying to create a trigger that will delete a row from a second table once i delete a row f…

  andrew.stokes

  18 replies

  9 years, 4 months ago

  By: darpanshah23

• Most efficient way of finding and storing where there are duplicate entries

  Hi I'm just learning about CTE and the WITH statement. I find it trickier to write at the moment bu…

  mastersql

  4 replies

  9 years, 5 months ago

  By: mastersql

• Select a column not in Group By clause

  hi friends seems a book table with columns : Id,Title,Subject,Price i want to get the most expensiv…

  dr_csharp

  9 replies

  9 years, 5 months ago

  By: Jeff Moden

• Planning out basic TSQL to manipulate table data

  Hi Can someone help me get into the thinking of knowing how to fix data in SQL tables (by trying NO…

  mastersql

  4 replies

  9 years, 5 months ago

  By: mastersql

• Can DatabaseMail attach a formatted Excel file?

  I have the following SP that will email me an attachment of the results of a specific query: EXEC m…

  adam-639168

  24 replies

  9 years, 6 months ago

  By: adam-639168

• I am trying to find the record that already exists, and I get the Msg 128, Level 15, State 1 error.

  if EXISTS (select tm.mbrs_id from temp_Mbrship tm join mbrship m on tm.mbrs_id = m.mbrs_id…

  sslaven50

  2 replies

  9 years, 6 months ago

  By: Lowell

• collation trouble with big int

  Hi i am getting :Cannot resolve the collation conflict between "Latin1_General_BIN" and "Latin1_Gen…

  spin

  3 replies

  9 years, 6 months ago

  By: mhuzzi

• ORDER BY in a cursor

  Is there a limitation on being able to order the select statement you are using for a cursor? In th…

  TheRedneckDBA

  17 replies

  9 years, 6 months ago

  By: MMartin1