T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Nested While loop

  Hi all, I am having some trouble parsing multiple values within two parameters. The goal is to loo…

  @Mike

  13 replies

  14 years, 6 months ago

  By: Jeff Moden

• return code from stored procedure in Sql management studio query window

  I have a stored procedure we use for returning suceed or failure code to a commandline batch file. …

  sqlfriend

  2 replies

  14 years, 6 months ago

  By: sqlfriend

• Using TSQL to unzip rar file but I don't see the files.

  I'm running the following TSQL EXEC master..xp_cmdshell '"C:\Program Files (x86)\WinRAR\unrar" e -y…

  dndaughtery

  13 replies

  14 years, 6 months ago

  By: Steve Jones - SSC Editor

• Help need for better query

  CREATE TABLE TABLEA ( purpose VARCHAR(10), contactTime datetime ) INSERT INTO TABLEA SELECT 'Takeca…

  krishusavalia

  1 replies

  14 years, 6 months ago

  By: LutzM

• Problem with using Datediff in weeks

  Hi all, As the subject suggests I am having a problem with using the datediff function in a query I…

  Craig Pa

  4 replies

  14 years, 6 months ago

  By: calvo

• Regarding comparing Indexes

  can someone help me in comparing the indexes from two database. I have a db Adventureworks, i migra…

  MsSqlNew

  5 replies

  14 years, 6 months ago

  By: R.P.Rozema

• Query Tuning Excersise

  Dear all, I am working on tuning a query and thought to share my experience with you and ask some q…

  chandan_jha18

  5 replies

  14 years, 6 months ago

  By: Ninja's_RGR'us

• i want to display alternative records..

  idname 1Giri1 2Giri2 3Giri3 4Giri4 5Giri5 6Giri6 7Giri7 8Giri8 9Giri9 10Giri10 how to di…

  dastagiri16

  1 replies

  14 years, 6 months ago

  By: Gail Shaw

• how to store result of 1 sp into sp

  hi i want to stored one sp result into another stored procedure in variable ,how to do that?

  daveriya

  10 replies

  14 years, 6 months ago

  By: SQLRNNR

• Count with Group By clause

  I need to pull the number of donors and the organization ID's of those donors (I need the orgID's a…

  hkflight

  6 replies

  14 years, 6 months ago

  By: NotoriousDBA

• query to get data in one row by avoiding duplicates and should populate null in case of no value

  Hi, I am having data in 2 tables in the following format and I should get data in a single row with…

  NLV

  1 replies

  14 years, 6 months ago

  By: NotoriousDBA

• date time format conversion

  I know this is very silly thing but i am kind of lost. sometimes 2 + 2 = 5 happens script is like t…

  ekant_alone

  14 replies

  14 years, 6 months ago

  By: drew.allen

• pivot problem

  qwer

  krishusavalia

  1 replies

  14 years, 6 months ago

  By: LutzM

• Subquery returned more than 1 value.

  I get this error when trying to run this query: Subquery returned more than 1 value. This is not pe…

  duanecwilson

  6 replies

  14 years, 6 months ago

  By: drew.allen

• Alternative way of Linked Server to Get Data from Different SQL Servers

  Hi, Greetings of the Day!!! I have two different servers. I have to write a query to select data fr…

  pandeybrijendra

  5 replies

  14 years, 6 months ago

  By: ghanshyam.kundu