T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Left excluding join question

  Hi -- I am writing a query to with left excluding join. TBL1 is a location / date range table with…

  luboxing

  7 replies

  11 years, 6 months ago

  By: TomThomson

• Query Help

  Hi All Expert, I need help with the below.Could somebody pls help me with this. /* I want to trave…

  JackTimber

  12 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• How to split one record into multiple records in query based on start and end date

  Hi, I would like to have records in my Absences table split up into multiple records in my query ba…

  michielbijnen

  1 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Help with the query

  Hi All Experts, Please consider this code block and inline comments to understand what i am trying …

  Shadab Shah

  3 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Eliminate NULL values

  Hi..I need the result from the below SQL code as: IF OBJECT_ID('Tempdb..#tTable1') IS NOT NULL DRO…

  etirem

  7 replies

  11 years, 6 months ago

  By: etirem

• Query works static, but does not dynamically

  I cannot seem to figure this one out, so I have taken to a forum for assistance. I have an SSIS pac…

  joseph.robinson83

  13 replies

  11 years, 6 months ago

  By: ChrisM@Work

• SQL Stored Procedure with parameter help option

  I know ran across this some time ago when researching some other topic, but I would like to add an …

  DB_Newbie2007

  2 replies

  11 years, 6 months ago

  By: DB_Newbie2007

• Are embedded spaces ever valid in non-delimited names?

  Hello experts I am trying to debug a procedure which is timing out, not in every case, but in some …

  Mark Dalley

  4 replies

  11 years, 6 months ago

  By: Mark Dalley

• OPENQERY Syntax to Insert into SQL Server Table from Oracle Linked Server.

  I was trying to figure out what the OPENQERY Syntax is to Insert into SQL Server Table from Oracle …

  Welsh Corgi

  7 replies

  11 years, 6 months ago

  By: ChrisM@Work

• Select group on multiple columns when at least one of the non grouped columns do not all match

  I'd like to first figure out the count of how many rows are not the Current Edition have the follow…

  jeff.born

  4 replies

  11 years, 6 months ago

  By: jeff.born

• Select Query - Unique Orders for date range

  Hi everyone! First time post, I hope this is in the correct place and I give enough info! I have an…

  michaeleaton 36224

  5 replies

  11 years, 6 months ago

  By: Jack Corbett

• SQLCMD error: Msg 102, Level 15, State 1...

  Hello - I am currently putting together multiple SQL files that perform a 7-step set of tasks to r…

  SQL_ME_RICH

  14 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Query column with multi values using IN

  Hi everyone - I am working with a table that has a column which stores multiple data/values that a…

  will_william

  8 replies

  11 years, 6 months ago

  By: will_william

• Subtracting figures within a query

  Hi All I have been going crazy with this problem and am now hoping someone can help me. I have a ta…

  pnr8uk

  1 replies

  11 years, 6 months ago

  By: Cadavre

• Selecting latest record with info

  I have a problem that I've been using what I call a "clumsy" workaround for so far, but would like …

  Rasmus Remmer Bielidt

  2 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson