T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• A question on Where vs Join filtration methodology and order of filtration

  Greetings all. This question has been forming in my mind for a while so now I will present it here…

  shannonjk

  9 replies

  16 years ago

  By: BaldingLoopMan

• Using a variable for a column name within a query and assign result to another variable...

  Essentially, I have a stored procedure that contains a cursor which iterates through records within…

  scott-1009141

  2 replies

  16 years ago

  By: Ray K

• uncommitted transactions

  Sorry, I know this topic is all over but I just don't see what's wrong... a co-worker of mine prese…

  steal

  1 replies

  16 years ago

  By: Dave Ballantyne

• Bit wise in sql server

  I have about 5 columns with 0,1,-1,-2 I want recode these values to 0,1,space, space I am thinking …

  alex2000

  8 replies

  16 years ago

  By: LutzM

• How to print 1st row of one table followed by 1st row of second and so on

  Hi, Is there a way to select records in this fashion? /* Table1: col1 col2 aa 12 bb …

  Santhoshkumar KB

  7 replies

  16 years ago

  By: jcrawf02

• remove only Leading and trailing double-double-quotes

  Hi, I want to remove the Leading and trailing double-double-quotes("") and replaced with a dou…

  RamG

  4 replies

  16 years ago

  By: RamG

• How to query for multiple parent-child records

  Hi, I would like to query a parent record and all child records associated to the child records ass…

  rvenable

  1 replies

  16 years ago

  By: SQLRNNR

• sum-partition over n out of 10 columns

  I have the following: salesdate saleshour pens …

  TheHTMLDJ

  4 replies

  16 years ago

  By: TheHTMLDJ

• Insert using a staging table

  Hi, I have a staging table (dbo.LSR_Prepare) which is used to format/validate data then load into d…

  DerbyNeal123

  2 replies

  16 years ago

  By: SQLRNNR

• insert/delete into indexed table

  Hi, I have a table of more than 6 million records and on daily basis need to delete nearly a millio…

  gugan_ta

  10 replies

  16 years ago

  By: keith.gerritsen

• Need only Unique records

  Hi All! I have a table with tens of thousands of rows. I have a cloumn titled "ID" and I need to re…

  clarks

  3 replies

  16 years ago

  By: NickDBA

• several count in same column

  Hello, I have a table with a column name "Result". This column contains 5 possible values : A,…

  dubem1-878067

  3 replies

  16 years ago

  By: dubem1-878067

• Dynamic SQL - sp_executesql

  Hi SQL - experts, I have twisted my brain around but could not find an elegant solution to this pro…

  georg.schumann

  3 replies

  16 years ago

  By: Lynn Pettis

• How to write a query for this one?

  Good day! I just need help in writing query.. I have records in a table below.. The condition would…

  shield_21

  17 replies

  16 years ago

  By: shield_21

• error in default date

  1. Create table say table1 with column col1 as varchar(2) and col2 as datetime and add default cons…

  rpatil22

  3 replies

  16 years ago

  By: Piotr.Rodak