T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Slow Recursive CTE

  Hi All I am using a CTE query for recording a list of purchase order numbers separated by a comma f…

  sonia.luthra

  4 replies

  13 years ago

  By: sonia.luthra

• Weird Question About Querying with Dates

  Okay so this is a very odd situation, one that I have not seen before. I'm trying to query a tabl…

  Polymorphist

  10 replies

  13 years ago

  By: Eric M Russell

• Database Design question regarding Normalized Tables

  Hey all, Got a theoretical question for you guys. Let's say I have a table that contains informatio…

  kramaswamy

  12 replies

  13 years ago

  By: john.arnott

• calculating ratios

  Hello, I am trying to calculate a ratio, i am pretty sure the problem is in the line * SUM([SUMTOTA…

  michaelmfranz

  2 replies

  13 years ago

  By: michaelmfranz

• Need urgent help in a tricky t-SQL

  Hi, Trying this for a long time but no results 🙁 need some help from experts here. I have the fol…

  Sachin Vaidya

  12 replies

  13 years ago

  By: math martinez

• Odd performance caused by Where Clause

  So I have this odd issue that I can't figure out how to solve. I have a poorly written view which …

  JblakTSql

  6 replies

  13 years ago

  By: Phil Parkin

• Convoluted DeDuplicate Related Records

  I'm not sure the right terms here, but I have a puzzle, that is easy to see, but I'm stuck on how t…

  homebrew01

  2 replies

  13 years ago

  By: homebrew01

• Output of Dynamic variable to next query

  Hi All, I have a table named tbl which contains 250 rows I have a Varaible @CNT = SELECT count(*) f…

  jeganbenitto.francis

  2 replies

  13 years ago

  By: jeganbenitto.francis

• bcp Errors

  I am trying to run the following statement, but get errors. Any help would be appreciated. DECLARE…

  Charlie-551146

  8 replies

  13 years ago

  By: kmclin

• Need Help in Converting Rows to Columns

  Hi All, Can anyone help me in below problem. I have below result set dtDatesDocIdPrefixCNT …

  jeganbenitto.francis

  3 replies

  13 years ago

  By: Cadavre

• Wrong Index Being Used

  I was wondering if anyone has seen this before and has any idea why it is happening. This is occuri…

  Roger Sabin

  21 replies

  13 years ago

  By: Gazareth

• Is This Cursor Empty ?

  I'm looking at some code for the first time, and am puzzled (happens a lot). The cursor "Membership…

  homebrew01

  2 replies

  13 years ago

  By: homebrew01

• daily weekly monthly calculate sum

  hi guys, i need urgent sql query,kindly help me i need sql output like given parameter @startdate a…

  bhupesh.nic

  6 replies

  13 years ago

  By: gregs-1000765

• Select Distinct last records

  i have a table with three fields id,bank_id,amount it has alot of data....how i can select last ent…

  MuhammadShafiq

  6 replies

  13 years ago

  By: MMartin1

• Interview Questions

  Hi Input 1 2 3 4 5 6 7 8 9 10 11 12 Output i want 1 4 7 10 2 5 8 11 3 6 9 12

  vs.satheesh

  7 replies

  13 years ago

  By: Jeff Moden