T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Issue with stuff function

  Hi, Can any one corrrect my stuff function code..i want to get the output as 1','2','3','4; a…

  atlancharlo

  2 replies

  14 years, 7 months ago

  By: Manjuke

• concatenate parent and org base members in a hierarchy

  Hi fellow SQL gurus, I have a organization hierarchy table below. ID Parent Organization …

  yingchai

  6 replies

  14 years, 7 months ago

  By: yingchai

• (Re)Sorting records

  Hi!!! Let's consider next tables: create table Prods -- table of products (id int, name nvarchar(…

  halford13

  25 replies

  14 years, 7 months ago

  By: drew.allen

• using the with keyword

  I have a stored procedure like: Decalare @WebServiceGetResults XML = NULL DECLARE @BroadViewData TA…

  Faye Fouladi

  3 replies

  14 years, 7 months ago

  By: Faye Fouladi

• Querying Multiple Bit Columns Dynamically

  I have the following table structure for keeping Attribute Flags for products CREATE TABLE [dbo].[…

  Daniel H

  8 replies

  14 years, 7 months ago

  By: Jason Selburg

• 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 months ago

  By: ghanshyam.kundu