T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Trigger with computed column criteria

  Would a update after trigger work if the where clause criteria contains a computed column? The com…

  Erin.

  1 replies

  13 years, 1 months ago

  By: Erin.

• Combine variable and select statement

  I want to combine this select statement and a variable(@EndUserDel) to get result.how can i do that…

  vahid.arr

  3 replies

  13 years, 1 months ago

  By: Bob Kaplan

• Why do some of these procedure calls have syntax errors?

  I am using 2012 (but I think I have had similar issues with 2005 and 2008) Why is it that the last …

  Tobar

  11 replies

  13 years, 1 months ago

  By: Tobar

• DateDiff function help

  Hi Friends, I'm new to TSQL and in my code I'm using - datediff(day,[WorkForce_JobPosting].[Job Pos…

  dhananjay.nagarkar

  3 replies

  13 years, 1 months ago

  By: Kingston Dhasian

• query returns empty row

  hi all, please find the following code DECLARE @intid as varchar(100) ='''BSEC0002''' + ',' + '''B…

  anand222123

  3 replies

  13 years, 1 months ago

  By: anand222123

• Need Help Deconstructing Tree Hierarchy Adjacency menu Table with T-SQL

  I have a Menu table with a structure like this: MenuID, MenuDesc, ParentMenuID, Sequence The Menu i…

  kwalter 22547

  11 replies

  13 years, 1 months ago

  By: mickyT

• XML with NameSpaces in each Node.

  HI Guys, I came to a situation where I have to load XML file in SQL server tables. I have worked in…

  krishnasavalia

  1 replies

  13 years, 1 months ago

  By: Jason Wolfkill

• Single value MIN and MAX dates from multiple rows

  This post has the code and an Excel Workbook with results and expected results (Red text) My query …

  SQL_Enthusiast

  4 replies

  13 years, 1 months ago

  By: Lynn Pettis

• Group a set of chain values

  I have the following table in SQL Server 2008 DECLARE @UnitConvert table ( ID int identity(1,1),…

  SQL006

  8 replies

  13 years, 1 months ago

  By: SQL006

• remove duplicates IF matches

  So I have the following statement: SELECT ca.Caseid,[weeknum],[monthName], Response1_Num , Response…

  Brad Marsh

  21 replies

  13 years, 1 months ago

  By: Brad Marsh

• XML nodes extraction

  Hi, Thanks for your help in advance, working with XML nodes for the first time and finding it frus…

  olibbhq

  2 replies

  13 years, 1 months ago

  By: olibbhq

• Update master from detail

  I have a timesheet master table and a related timesheet detail table. Each detail row could trigger…

  Jim

  1 replies

  13 years, 1 months ago

  By: Sergiy

• Is a doomed transaction inevitable if deadlock occurs in a trigger (SQL Server 2008 R2)?

  Hi all, Below are two scenarios, however, what I am trying to accomplish is to catch deadlock error…

  davidsatz

  13 replies

  13 years, 1 months ago

  By: davidsatz

• In Need of some expert query help

  The below query I have been piecing together is really slow. I was wondering if any of you might be…

  mbrady5

  4 replies

  13 years, 1 months ago

  By: Gail Shaw

• Need guidance on how to Insert a new record between existing records

  Here is a the table structure: MemberNbr Varchar(11) MemberCardNumber Varchar(10) EffectiveDate Int…

  Nilssond

  3 replies

  13 years, 1 months ago

  By: ScottPletcher