T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• manager - employee relationships

  I'm trying to create a recursive cte that can select manager - employee next level down - employee …

  SQLHeap

  9 replies

  14 years, 10 months ago

  By: Jeff Moden

• Get Max Row Only if no Ties

  Hi Sample Data: CREATE TABLE #test (key_value INT, test_value INT); INSERT #test SELECT 1, 2 UNION …

  OTF

  6 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Issue with Unpivoting values in SSRS 2008

  Hi All, i have 9 columns say qso,cp,cd,qsoYESpercentage,cpYESpercentage,cdYESpercentage,qsoNOpercen…

  prasadinpatni

  2 replies

  14 years, 10 months ago

  By: soochkoam

• Missing Numbers (ranges) in Multiple Columns

  I see lots of examples where one needs to parse a csv list to find the gaps of missing values or a …

  SSSolice

  4 replies

  14 years, 10 months ago

  By: SSSolice

• Help needed with SQL command

  Hello, I have a table: AccountNo, Period, Amount 100, 11/02, 100 100, 11/03, 110 100, 11/04, 120 11…

  c.reusch

  2 replies

  14 years, 10 months ago

  By: srikant maurya

• Can you use a tally table to drive inserting X number of records in another table?

  I was setting up to do a demo on how to eliminate duplicate records from a heap and, after reading …

  Christian Bahnsen

  6 replies

  14 years, 10 months ago

  By: Jeff Moden

• Delete Validation of Master Record

  I have Table of ClientMaster and 4 Tables of Purchase, Sale, Receive, Transfer. ClientID is passing…

  yusufforu

  3 replies

  14 years, 10 months ago

  By: Lowell

• Indexed View Issue - Error converting data type nvarchar to numeric

  Hi I am having a strange issue selecting data from an indexed view... I have created an indexed vie…

  Wolfmeister

  6 replies

  14 years, 10 months ago

  By: Wolfmeister

• To select one month old record

  HI All, i want to retrieve the records from the sql server database table where the condition is o…

  hidayath

  7 replies

  14 years, 10 months ago

  By: Cadavre

• Assistance with SQL

  This is an SQL that gets SALES information. But I am having difficulty getting SALES information fo…

  DSR0308

  26 replies

  14 years, 10 months ago

  By: GSquared

• XML Returning &amp instead of &

  I am fairly new dealing with XML but I know there are special characters that XML does not like. So…

  BoilerJ

  16 replies

  14 years, 10 months ago

  By: GSquared

• JOINing on many tables...

  I was wondering about how a JOIN works for 3 or more table. I understand that a LEFT JOIN will get …

  daveb-840383

  10 replies

  14 years, 10 months ago

  By: ModestyBlaise84

• "Subquery returned more than 1 value" error when querying linked server

  I'm building a data warehouse that queries databases that are sometimes located on linked servers. …

  kabcampbell

  8 replies

  14 years, 10 months ago

  By: kabcampbell

• Assistance with subquery in an ISNULL

  Need some assistance with a subquery in an ISNULL.... What I am trying to accomplish is the followi…

  Paul Morris-1011726

  6 replies

  14 years, 10 months ago

  By: Sioban Krzywicki

• What are the rules for CAST or CONVERT, and INT vs BIGINT?

  I get why the first one doesn't work, it is too big for an INT. But what about the next two? It see…

  jpSQLDude

  6 replies

  14 years, 10 months ago

  By: jpSQLDude