T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Execution Plan with Sort

  I am playing around with and continuing to learn SQL. I am using the AdventureWorks2012 database wi…

  ken_cox

  3 replies

  13 years ago

  By: ken_cox

• Store Procedure Help

  Hi Guys, I need big favor. I create new table Table_Track (ID, StoreProcedureName, CreatedDate, C…

  rocky_498

  4 replies

  13 years ago

  By: Sean Lange

• BCP Error : Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.EXTGEN_InitSessionContextSp'.

  DECLARE @Cmd VarChar(4000) DECLARE @SProcName VarChar(40) DECLARE @SP_Parm1Value VarChar(4…

  skb 44459

  19 replies

  13 years ago

  By: Orlando Colamatteo

• How to read XML file with multiple children and load it in SQL Server

  I have an XML file in the below given format. How can I import it into SQL Server using OPENXML or …

  SQL Kidu

  7 replies

  13 years ago

  By: Mark Cowne

• multiple a number with time dataType

  i want to minus two time(time(7) datattype in sql 2008) datatype and multiple(hour and minute) it t…

  vahid.arr

  4 replies

  13 years ago

  By: Cadavre

• Need Help with TSQL for Date Display

  Dear Friends, Currently from the DB table I get the Date and Time in DATE TIME STAMP format 1/2/20…

  dhananjay.nagarkar

  7 replies

  13 years ago

  By: dhananjay.nagarkar

• Find the first appointment by patient and month

  I am trying write an efficient t-sql query that will return, for a specific date range, the first a…

  bbk0919

  2 replies

  13 years ago

  By: bbk0919

• Performance tuning

  Hi, SELECT FS.Bol#, FS.CustNum, FS.PostedDate FROM dbo.FACT_SalesAnalysis FS where ocr IN ('r') AN…

  PSB

  6 replies

  13 years ago

  By: ScottPletcher

• Ranking functions, views, and predicates

  So, I ran into a nifty little "bug" I'll call it. From what I can find this was an issue in SQL Se…

  Tony Fountain

  15 replies

  13 years ago

  By: Sergiy

• Update a column based on values in the same column

  I am trying to update the GP%age column without a loop. I have a table with 3 columns: PostDate, Ca…

  John Hanrahan

  7 replies

  13 years ago

  By: John Hanrahan

• How to select a column based on the value of another column

  If I have a table that has: id | answer1 | answer2 | answer3 | answer4 | answer 1 abc …

  markcrosbie

  4 replies

  13 years ago

  By: Evil Kraig F

• How to select from a temporary table using a dynamic query

  How do I sleect from a populated temporary table using a dynamic query declare @Tmp table (.....) …

  markcrosbie

  2 replies

  13 years ago

  By: markcrosbie

• Performance Problem

  Hi, I have been struggling with a procedure for a few days. even though the tables sizes are not ve…

  chandan_jha18

  2 replies

  13 years ago

  By: ScottPletcher

• OPENROWSET - SYNTEX ERROR NEAR @CMD

  -- this works fine SELECT a.* FROM OPENROWSET('SQLNCLI', 'Server=sql01;Trusted_Connection=yes;', 'S…

  skb 44459

  1 replies

  13 years ago

  By: Eugene Elutin

• status on a given date or date range

  I have a situation where we need to be able to query the status a claim was at any given time. For …

  Dena Mansfield

  11 replies

  13 years ago

  By: Lynn Pettis