T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• varchar to datetime convertion challenge

  I have a table w/a varchar(10) column (MoYear) which has the month and year with '/' between (i.e. …

  latingntlman

  8 replies

  13 years ago

  By: Sergiy

• HierarchyID navigation - given a specific node, return the child rows, move up a level, rreturn the child rows, move up a level and repeat

  Hi, I have an existing piece of code that navigates through a hierarchy and was trying to figure ou…

  _greg

  2 replies

  13 years ago

  By: _greg

• Derived Column with value in previous row + current

  I have a data set that has ID and Total fields. Now I need a result set that has a third column, "A…

  SQLCurious

  5 replies

  13 years ago

  By: Lynn Pettis

• creating table error?

  Hai Friends, Im creating one table for web application these is my table structure. after wrote…

  raghuldrag

  9 replies

  13 years ago

  By: Gail Shaw

• Extract a string between two special characters

  Hi Everyone, Can anyone of you please help me to get the T-SQL to extract a string between two spec…

  ksrikanth77

  3 replies

  13 years ago

  By: ksrikanth77

• Parent/Child and Recursion

  I have data in a table like this: Parent Child 300001 110081 300001 102157 300001 …

  VA123

  2 replies

  13 years ago

  By: Adi Cohn-120898

• Stuck with a getdate time range?

  Hi All, Sorry if this has been asked somewhere all ready but I've struggled to find the answer! I…

  hewitg 82815

  2 replies

  13 years ago

  By: Adi Cohn-120898

• Table variable is not automatically dropped in TempDB

  hi, I have created procedure like . USE [master] GO /****** Object: StoredProcedure [dbo]. Scri…

  dastagiri16

  6 replies

  13 years ago

  By: Sergiy

• Cannot shrink log

  My Transaction log is about 3GB and I can't shrink it. It is using a FULL backup and I try over and…

  tshad

  10 replies

  13 years ago

  By: Sergiy

• filter duplicate students via T-SQL

  /* I need to filter for duplicate students: --------------------------------------- For same studen…

  kevin_nikolai

  23 replies

  13 years ago

  By: Sergiy

• datetime comparison behaving oddly

  I think I'm about to fill a gap in my knowledge base, because I've been banging my head against thi…

  ronmoses@gmail.com

  8 replies

  13 years ago

  By: Sergiy

• error in Transactions... need urget help

  hi, i have below code declare @V_AreaId int = 1 declare @V_Area nvarchar(30)='xxx' declare @V_Pin…

  $t@r

  3 replies

  13 years ago

  By: Sergiy

• How To Avoid The Duplicate Records....

  Hi Friends... I Having Table For The Following Structure.. create Table EmployeeDet (EmpID int,EmpN…

  sarwaanmca

  12 replies

  13 years ago

  By: Jeff Moden

• No result set

  I have this query: declare @controlnumber varchar(13) set @controlnumber = '0210300000001' select *…

  phamm

  1 replies

  13 years ago

  By: Lynn Pettis

• Stored Proc Novice Help

  Hi all, I'd be really grateful if someone could help me (probably something very basic I'm missing!…

  WWDMark

  2 replies

  13 years ago

  By: WWDMark