T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• distinct/grouping problem

  Hi all, I have a table like below: CODEDescriptionDateReferenceNo OPENEDOpened2011-02-0311…

  tig2810

  3 replies

  14 years, 10 months ago

  By: The Dixie Flatline

• T-sql to Concatenate the rows

  Hello All, I am kind of new to T-SQL and I have a situation here. I have the below shown table stru…

  mpalaparthi

  4 replies

  14 years, 10 months ago

  By: ColdCoffee

• Update Query based on multiple tables and multiple criteria

  Hi: I'm fairly new to all of this, but I would like to erform the following: UPDATE Purchasing SET …

  steve.anderson 7639

  18 replies

  14 years, 10 months ago

  By: tfifield

• Return rows affected by an UPDATE in an SP

  Hey guys and gals . . . I've been messing with this code all morning, and haven't been able to get …

  Ray K

  14 replies

  14 years, 10 months ago

  By: Brandie Tarvin

• can we change the instance name

  Is it possible to change the instance name in sql 2008 after installation. We gave the wrong instan…

  bharathkumar.pammiramesh

  1 replies

  14 years, 10 months ago

  By: Welsh Corgi

• SQL procedure for customer classification

  We have a NET SALES table (customer, calendar_month, net_sales), We classify customers based on the…

  thysvdw

  10 replies

  14 years, 10 months ago

  By: Cadavre

• need help in Pivot query

  Hi All , I have a table with columns ProjectID ,YearofOperation WeekNo,PorjectParameterSchedule, Pr…

  roshanmaugustine

  2 replies

  14 years, 10 months ago

  By: Jeff Moden

• need help in grouping cyclic rows

  Hello all, I have an interesting question. I have a table with following data. column1 column2 coun…

  striker-baba

  4 replies

  14 years, 10 months ago

  By: Jeff Moden

• Loading records from two tables at specific interval….INSERT INTO?

  I want to add records to two tables at a specific interval so I may test Merge Replication. I a…

  michaelm-574845

  2 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Need Round Robin- For loop in T-SQL

  Can any one write Round Robin- For loop in T-SQL? Ex: Like follows..... (i =1; i<=10; i++) Print…

  theunique1011

  11 replies

  14 years, 10 months ago

  By: Jeff Moden

• single column data spit into multiple columns to another table

  Hi I have one table it is having only one colun length is 120 char. the data is like this …

  ashok_bayyana

  10 replies

  14 years, 10 months ago

  By: Jeff Moden

• Compare Lists within a Table

  I am trying to figure out how to compare lists in a table. I want to find if any two Lists have the…

  Goldie Lesser

  6 replies

  14 years, 10 months ago

  By: Jeff Moden

• try this !!

  check this out. if you are having adventure works data base it is there. u can check ALTER PROCEDU…

  ghanshyam.kundu

  2 replies

  14 years, 10 months ago

  By: Jeff Moden

• renaming a txt file

  hi, Just I am renaming the one txt file code :-- Declare @dt datetime ,@SQLstmt varchar(100) Se…

  ashok_bayyana

  8 replies

  14 years, 10 months ago

  By: Jeff Moden

• tsql command to check the default filegroup

  Hello What is the tsql command to see the default filegroup on a database? Thanks

  invaliddba

  1 replies

  14 years, 10 months ago

  By: Welsh Corgi