T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months ago

  By: Lynn Pettis

• Bushy plan vs left-deep

  I have read about Bushy plan and left deep in some articles. Bushy plan will consume more memory as…

  karthik M

  1 replies

  13 years, 1 months ago

  By: ChrisM@Work

• SQL Refusing to use an index

  I've just had a designer come to me with a really odd problem. A query, joining two tables on a pr…

  Rayven

  5 replies

  13 years, 1 months ago

  By: Sergiy

• Substring with IF or CASE statement

  Hi, I am trying to import into SQL Server 2008 R2 a list of strings as follows: =KET+N.207-13-F4001…

  Avdecha

  2 replies

  13 years, 1 months ago

  By: Avdecha