T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• T-SQL Variable vs String Equivalent

  Got a question with some coding standards. There are developers declaring a variable to a constant…

  sqlpadawan_1

  15 replies

  13 years ago

  By: ChrisM@Work

• SQL /Procedure - for Transpose and Calculation

  Hi Team, I have a Complex requirement. Source: -------- NAME PAYMENT_TYPE PAYMENT SUDHIR SAL 30.3 S…

  sudhirnune

  29 replies

  13 years ago

  By: ChrisM@Work

• T-SQL Help

  This seems like a very simple question but for some reason the answer is eluding me. Given the foll…

  Dave62

  3 replies

  13 years ago

  By: Dave62

• Column name or number of supplied values does not match table definition

  Greetings, I have a vendor provided procedure that returns two result sets. I am trying to insert t…

  Chrissy321

  3 replies

  13 years ago

  By: Chrissy321

• TSQL help

  Hi , I have a table from where I want to filter out some records as given below. CREATE TABLE #Mi…

  PSB

  6 replies

  13 years ago

  By: PSB

• Dead Lock Question

  Hi Guys, I have two questions. 1) My first question, how i can find out on which table of my dat…

  rocky_498

  3 replies

  13 years ago

  By: ScottPletcher

• Create table Using the Structure and Data from the Dynamic SQL

  Hi All, I need to create a table which will be having teh structure of the Result of the PIVOTED Qu…

  sudhirnune

  8 replies

  13 years ago

  By: sudhirnune

• small case but stuck here now

  I've never noticed or had the issue before: I have a sp with some datetime parameters: ALTER PROCE…

  halifaxdal

  2 replies

  13 years ago

  By: halifaxdal

• Need help with Dates

  Dear friends, I'm new to TSQL and need help please - I have to Calculate a field value as Position…

  dhananjay.nagarkar

  2 replies

  13 years ago

  By: dhananjay.nagarkar

• Inserting missing records using multiple fields as the key

  Hi, I have a complex problem that I'm pretty sure should have a very simple solution. If I could ju…

  christy-720576

  4 replies

  13 years ago

  By: christy-720576

• how to convert the below subquery into join..single update statment with joins

  here is the complete query..the ulitmate aim is the update the claim table... but it should be only…

  surendiran.balasubramanian

  3 replies

  13 years ago

  By: ChrisM@Work

• Checking to see if a time is between two times

  Hi all, I'm trying to break down events by hour of day as 00-23. So if an event has a duration of 5…

  greg.bull

  12 replies

  13 years ago

  By: ChrisM@Work

• Function for similar phrases

  Hi All, Is there any built in function available for checking the similarity of the phrases eg: US…

  deepzzzz

  8 replies

  13 years ago

  By: Sergiy

• Query performance help needed

  I have multiple pairs of "Offers" and each Offer is comprised of several lists of "Items". My pairs…

  aostanley

  2 replies

  13 years ago

  By: Sergiy

• split single row into multiple lines

  Hi, Can any one help me please How to split single row into multiple lines (Not rows) Thanks G…

  gracebite

  5 replies

  13 years ago

  By: Luis Cazares