T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Using "not like" to filter out non-numeric values from varchar field

  I am putting a SELECT statement together where I need to evaluate a results field, to determine how…

  miles_lesperance

  6 replies

  11 years, 12 months ago

  By: crmitchell

• Need Help for the following problem

  I have the Baseline number and I have to populate the next columns based on the following formula 2…

  mdsharif532

  4 replies

  12 years ago

  By: mdsharif532

• Finding Gaps in Dates

  Hello! I'm fairly stumped with a problem at the moment... I'm trying to find gaps in times in a t…

  Andrew Kernodle

  6 replies

  12 years ago

  By: Andrew Kernodle

• Retrieve last 7 days date question

  Hi, The following query was used for retrieving dates for the last 7 days . Untill February this qu…

  PSB

  5 replies

  12 years ago

  By: ScottPletcher

• Working with stored text file in TSQL

  I'm looking for a way to look into a field containing a text file and work with the content line by…

  keith.westberg

  19 replies

  12 years ago

  By: keith.westberg

• Table compare

  Hello, I have two tables I am trying to compare as I have created a new procedure to replace an old…

  djj

  2 replies

  12 years ago

  By: djj

• Need help in Select case with tricky logic

  hi, Having trouble some using select case for the below logic. with sample as ( select 6 as Ite…

  born2achieve

  6 replies

  12 years ago

  By: born2achieve

• Finding previous even numbered month and appropriate year from given date

  Hi, I'm trying to write some T-SQL to return the previous even numbered month and appropriate year …

  Tony Green

  2 replies

  12 years ago

  By: pietlinden

• Get output of SQL Procedure and assign it to a variable used in WHERE Clause

  Get output of SQL Procedure and assign it to a variable used in WHERE Clause Later I want to use th…

  ms-techie

  3 replies

  12 years ago

  By: SQLBlimp

• Pivot Table

  I run this code: SELECT Gruppo_Assegnatario, [100] as stato1, [101] as stato2, [102] as stato3 …

  Trieste

  5 replies

  12 years ago

  By: Trieste

• A simple query needs your help

  I have two tables to be joined Doc: ID, DivID Division: ID, Div CREATE TABLE [dbo].[Doc]( [ID] [i…

  halifaxdal

  5 replies

  12 years ago

  By: halifaxdal

• HierarchyID/Indexing - Could use some help

  Hi experts of the internet! I've got a weird issue, and I'm hoping you guys can help me out. I'm …

  mike.wertman

  8 replies

  12 years ago

  By: mike.wertman

• Schema

  Can someone please give me example SQL code to do the following: * Create Scheme xyz * Add views to…

  mike 57299

  9 replies

  12 years ago

  By: mike 57299

• Overlapping Date Ranges

  How can I set the following overlapping date rages / count to a contiguous date range / count in SQ…

  membership 18918

  1 replies

  12 years ago

  By: Lynn Pettis

• Get output of SQL Procedure and assign it to a variable used in WHERE Clause

  Get output of SQL Procedure and assign it to a variable used in WHERE Clause Later I want to use th…

  ms-techie

  1 replies

  12 years ago

  By: Gail Shaw