T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Query tuning - avoid Case statement on this query

  Hi All Could you please help me to write this query with out CASE statement? Also wanted to know wr…

  muthu.saro

  43 replies

  15 years, 8 months ago

  By: TomThomson

• Retrieving max date and last but one max date

  hi, I 've scenario like this. I want to retrieve data like VIN LastRODate LastbutoneRODate --…

  Prema sambandam

  10 replies

  15 years, 8 months ago

  By: Derrick Smith

• Columns to rows

  Hi I have a table (T1) like this T1: Column1 column2 column3 row11 row12 row13 I want …

  pzmrcd

  9 replies

  15 years, 8 months ago

  By: WayneS

• How do you change the partitioning column of a table

  I have a partitioned tabled that uses a partition scheme but we've just noticed that the wrong colu…

  jm99

  3 replies

  15 years, 8 months ago

  By: winash

• query to get dbname,totalsize,reservedsize of all databases in sql 2000

  Hi, required query for me to work on sql 2000 server is query to get dbname,totalsize,reservedsize …

  syamala.popuri

  1 replies

  15 years, 8 months ago

  By: tommyh

• distinct / top....???

  Hi, My data looks somethingl like this UserID AnswerId Value 123 1 Mr 123 2 …

  lahatfield

  3 replies

  15 years, 8 months ago

  By: hallidayd

• How to select two dimensional data

  I have a sql server table with the following data: PrimaryKey ForeignKey DataType Value 1 …

  nadarajan_v

  8 replies

  15 years, 8 months ago

  By: Toby Harman

• How to display Sub Report as pop up window in SSRS 2008

  Hi all I got one Requiremeent in that I need to design a two reports lets say ex: report 1 & R…

  deepak.a

  8 replies

  15 years, 8 months ago

  By: ramuis78

• Query to find similar data from many other tables

  Hi All, I have 100 tables with the exact same column structure but different data. All these tables…

  apat

  2 replies

  15 years, 8 months ago

  By: apat

• Update "Case When" or anything like that

  Hi @all I have no idea how to get a solution for my problem. A table like that: kPriority, kPageId,…

  sven.roth

  2 replies

  15 years, 8 months ago

  By: sven.roth

• I have never tried this before.

  Greetings again helpers. I have a .csv file with 5 columns: postID varchar(3) datePosted varchar(7)…

  simflex-897410

  10 replies

  15 years, 8 months ago

  By: Alvin Ramard

• Query to get a running total for each row?

  Basically I have a table that stores the definition of a fixed-length record. I want to be able to…

  josh_thoma

  6 replies

  15 years, 8 months ago

  By: josh_thoma

• Get duplicate Records

  Hi all, I have two tables one of the table columns like tbl_emp Id Total sto…

  yjeevanrao

  11 replies

  15 years, 8 months ago

  By: tommyh

• query by todays date +7

  I have to set up a SQL Script that extracts the appointment data I need for 7 days from now. I am r…

  LoosinMaMind

  4 replies

  15 years, 8 months ago

  By: Gail Shaw

• Trim field. Remove everything past a certain character

  Hi I have the following field in a refernece table ... ARMPMAEWC : ARMPM I have the following field…

  LoosinMaMind

  4 replies

  15 years, 8 months ago

  By: LoosinMaMind