T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• how to get data from a table all in one result row

  I'm need help with a query. The table has an id, a name, and a type. Sample: ID Name …

  Denise McMillan

  2 replies

  11 years, 8 months ago

  By: Denise McMillan

• select from XML type ntext

  My sample XML is: Some Value1 Some Value2 some Value3 some Value4 Some Value5 …

  chandrika5

  7 replies

  11 years, 8 months ago

  By: benemngaycuoi511

• Division by zero on a SQL Instance while a different Instance run correctly

  Hi I run the same query against two DB, one is the publisher and other is the subscriber. The two D…

  clearbystander

  6 replies

  11 years, 8 months ago

  By: John Rees

• HOW TO STORE THE PROCEDURE VALUES TO TABLE VARIABLE

  HI, i got one doubt ... SP_SPACEUSED 'table' the above statement can produce some data... how can i…

  dastagiri16

  1 replies

  11 years, 8 months ago

  By: Gail Shaw

• CTE

  in Which Sensory we use CTE

  coolrana.kumar69

  2 replies

  11 years, 8 months ago

  By: Steven Willis

• Strange query gives strange results

  Hi, I found a view using a "bad practices example" query and I can't understand the results it give…

  odepriester

  8 replies

  11 years, 8 months ago

  By: odepriester

• Help using LIKE and IN(select product from referenceTable) and wildcards

  Here's the issue/problem: I've got a reference table with a list of software 'products' I've got a …

  tim.hansen

  2 replies

  11 years, 8 months ago

  By: tim.hansen

• Ugly SQL Statement takes to long to run. I need speed up help

  SELECT DISTINCT TOP 40 A.INV_ITEM_ID ,SUM(A.QTY_REQUESTED) AS QTY_REQUESTED ,ISNULL((SELECT SUM(B.Q…

  twdavis-893252

  2 replies

  11 years, 8 months ago

  By: ChrisM@Work

• Is this a "gaps and islands" problem? Finding gaps in overlapping times.

  The following can be pasted into SSMS so that it is both more readable, and easier get your teeth i…

  GPO

  24 replies

  11 years, 8 months ago

  By: GPO

• Why is my query not working as expected?

  So, I am writing a view and I want it to be an indexed view. The first query I wrote is: SELECT P.…

  kevin.unglesbee

  3 replies

  11 years, 9 months ago

  By: ChrisM@Work

• Soundex Function - Search and Matches

  Hi, We are using Soundex function too find near matches. Its works fine for English language as its…

  firoz.riz

  1 replies

  11 years, 9 months ago

  By: Steven Willis

• check if value is integer

  How do you check if the value is a whole number? declare @a int, @b-2 int set @a = 7 set @b-2 = 3 i…

  newbie101

  9 replies

  11 years, 9 months ago

  By: Sean Lange

• How to Sort SQL Results in Your Own Preferred Order

  I know I've seen this somewhere before but just can't remember where it is and how to write it, ba…

  halifaxdal

  7 replies

  11 years, 9 months ago

  By: kevin_nikolai

• changing the output format in select statement

  i get values in a coulmn NAME (- column name) as rows i need to get the output in a single line Exa…

  ssurekha2000

  1 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• Question on pivot tables

  I have been collecting performance data through Typeperf. I'm trying to create a pivot table for re…

  Ryan D.

  9 replies

  11 years, 9 months ago

  By: Jeff Moden