T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Issue with replace function in sybase

  Hi, can any one tell me why its showing "incorrect synatx near the keyword replace" in sybas…

  atlancharlo

  10 replies

  14 years, 4 months ago

  By: Jim Mackenzie

• calculate date difference in form of months and days

  hi folks i need to calculate difference between two dates in month with days format suppose my endd…

  ghanshyam.kundu

  3 replies

  14 years, 4 months ago

  By: ghanshyam.kundu

• help with Case Statement

  I would like to modify the following sql statement: UPDATE pf SET pf.OnAirOfferSpotName = bv.OnA…

  Faye Fouladi

  2 replies

  14 years, 4 months ago

  By: Faye Fouladi

• help with sql query

  i have a query that gives a result set i am doing an insert of that result into a temp table #t1 ta…

  koolme_85

  4 replies

  14 years, 4 months ago

  By: Welsh Corgi

• t-sql query to populate some data into a new table

  i have a table T1 in which i have 10 columns for example col1 , col2 , col3,......col 10 . now the …

  koolme_85

  7 replies

  14 years, 4 months ago

  By: koolme_85

• Decimal Number format as String

  Hi, I was given the requirement to display a decimal data column as string for a particular column.…

  Bruce Li

  9 replies

  14 years, 4 months ago

  By: Ron McCullough

• grouping by regions except in one case

  I don't do enough sql programming anymore to be able to figure out the following: if I have course…

  mgoldade

  3 replies

  14 years, 4 months ago

  By: mgoldade

• Splitting user defined table type parameter into multiple tables

  Hi all, I've been trying to split an input parameter table into multiple tables while ensuring that…

  dan_skov

  2 replies

  14 years, 4 months ago

  By: dan_skov

• SET IDENTITY_INSERT advice - whats session mean?

  Hi I need to write an undelete SP. Records are deleted by moving to a deleted table. The PK on the…

  terry999

  4 replies

  14 years, 4 months ago

  By: Ant-Green

• Conditional check Option

  dear All I am new in sqlserver 2005 I Have an one doubt for finding the Values in Particular colum…

  sqlfriends@sql.com

  2 replies

  14 years, 4 months ago

  By: ghanshyam.kundu

• SQL Server Query Help

  I have 2 tables with below table structures Create table Client (ClientID Int, clientName Nvarchar…

  Lucky9

  3 replies

  14 years, 4 months ago

  By: Lucky9

• delete duplicate record

  one of the way to delete duplicate record is on sql authority website. I've used it many times but …

  dva2007

  15 replies

  14 years, 4 months ago

  By: Jeff Moden

• alter table alter column question regarding how many columns can be altered in 1

  alter table statement. i want to change the collation for all the columns in a table. i already hav…

  roy.tollison

  8 replies

  14 years, 4 months ago

  By: LutzM

• count all staff employed at mid year, null date problem

  Hi I'm using SQLS 2008. I want to select all the staff who were employed by a company at a mid y…

  Desolation Row

  2 replies

  14 years, 4 months ago

  By: Desolation Row

• Exception Handling in SqlServer Trigger to allow base table transaction to commit but handle the error

  I'm very familiar with Oracle and I'm trying to find the comparable code in SqlServer world. Basica…

  thomas.salley

  2 replies

  14 years, 4 months ago

  By: TomThomson