T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Cross tab like query

  Dear All, I am creating a report of State wise Article Price for all states of India. I have data i…

  hiYusuf

  1 replies

  13 years, 8 months ago

  By: drew.allen

• SSRS: Automatically Selecting Items in one drop down based on the values selcted from another drop down

  I know that I can specify default values for a a multi selected parameter, but is there a way that …

  NeddyRock

  3 replies

  13 years, 8 months ago

  By: SQLRNNR

• Compare Values

  I have a table A with following clmns, ( ID (int), Date (datetime), Value (float)) I have a view B …

  LOOKUP_BI-756009

  3 replies

  13 years, 8 months ago

  By: LOOKUP_BI-756009

• how to rollover data from zipcode to state level?

  I have zipcode data (around 60,K records). I want to roll over by state: for example: State zip…

  sql4us

  1 replies

  13 years, 8 months ago

  By: Lowell

• Openrowset for Excel missing data

  I am trying to use this statement to read the data from an xls file for processing: SELECT * FROM …

  TimothyAWiseman

  3 replies

  13 years, 8 months ago

  By: Sylvain Audet

• IDENTIFIERS !!!

  Hi All, I have recently answered some questions under 'QOD' section. I saw the below one and it loo…

  karthik M

  3 replies

  13 years, 8 months ago

  By: Jeff Moden

• Like vs Contains

  I have come across a problem I am trying to understand. I have done weeks of searching and reading…

  Dan.Humphries

  5 replies

  13 years, 8 months ago

  By: Dan.Humphries

• sql Cardinality

  Hi All, I have rectnly read the below article on simple-talk website. http://www.simple-talk.com/sq…

  karthik M

  8 replies

  13 years, 8 months ago

  By: GSquared

• Add one min when time same

  Hi guys, I have a table which has below records. I have to add 1 min when time comes in second reco…

  Sagar Sawant

  6 replies

  13 years, 8 months ago

  By: Johan Bijnens

• case function

  the below query doctorid columns having data like ALL and doctorId's (100,101,121 ...)..IF doctorid…

  dastagiri16

  3 replies

  13 years, 8 months ago

  By: spaghettidba

• Assistance with getting DB name returned in the following SQL ...

  Hi, I am trying to write some SQL which will show me the size of my database files, so that I can m…

  barryFS

  14 replies

  13 years, 8 months ago

  By: Ninja's_RGR'us

• Getting the top record when max date filter returns multiple rows

  I have a query to import specific client data from an unnormalized set of tables brought over from …

  Ron Kunce

  10 replies

  13 years, 8 months ago

  By: drew.allen

• Datetime

  Dear All, select opening_bal,authorised_date from t_period_value_balance where group_no ='CENVAT'…

  Subrata Bauri

  4 replies

  13 years, 8 months ago

  By: Subrata Bauri

• Refer to a calculated column in query to calclulate another column

  I want to calculate a column for a query as a function of table columns, say: Select ColA*ColB*ColC…

  Jim

  1 replies

  13 years, 8 months ago

  By: drew.allen

• What is the '!' for?

  I should probably know this but what is the '!' for? SELECT * FROM sys.dm_exec_sessions WHERE Statu…

  krypto69

  3 replies

  13 years, 8 months ago

  By: krypto69