T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• select rowid?

  Hey, i wonder what's the most efficient way to get a "rank" of a record in a table set. An example:…

  memymasta

  2 replies

  14 years, 7 months ago

  By: memymasta

• T-SQL

  I have 6 fields: Eg ID,dept,sum1,sum2,total and company I have 6 distinct companies, I need to cr…

  mak12

  1 replies

  14 years, 7 months ago

  By: GSquared

• Aggregating monthly sales data by column

  I've been given a task to create a query to return 3 years of sales data in monthly aggregate forma…

  rrdavis07

  7 replies

  14 years, 7 months ago

  By: Usman Butt

• How can we compress the tables in a database

  Hi, How can we compress specific tables in a database. Please helpme out In advance thank you 🙂

  ARUN KUMAR AGUNURU

  3 replies

  14 years, 7 months ago

  By: SQLRNNR

• CASE HELP

  I have a table that contains items in the pipeline that are being manufacture at different times bu…

  Maique

  7 replies

  14 years, 7 months ago

  By: Maique

• Help Stored Procedure

  Hi all, I have these data: / * ID id_part ord lev 1606 1513852 183 2 1606 1513853 184 3 1606 151385…

  xRafo

  4 replies

  14 years, 7 months ago

  By: xRafo

• Query Help

  What is best to rewrite the below query instead of using temp table or cursors.. Thanks for your he…

  Mvs2k11

  5 replies

  14 years, 7 months ago

  By: MyDoggieJessie

• Join not returning expected result.

  I have a database where I am trying to draw summery data for a simple display. If I have data in th…

  Hylton Tregenza

  6 replies

  14 years, 7 months ago

  By: tfifield

• need help with query to select with subquery

  I'm having trouble getting this query to work and will appreciate any ideas. select number, avalue,…

  Denise McMillan

  6 replies

  14 years, 7 months ago

  By: ChrisM@Work

• list of rates for a product between date range

  This is the table ProductRate, rate is set for a product for different date range SET ANSI_NULLS O…

  SQL006

  3 replies

  14 years, 7 months ago

  By: Kingston Dhasian

• Previous Decemeber Totals based on date

  I currently use a query to create a YTD summary report of trade data. I would like to extend it to …

  eseosaoregie

  4 replies

  14 years, 7 months ago

  By: eseosaoregie

• Merging resource activities

  If i have the following table CREATE TABLE [dbo].[Activities]( [Id] [int] IDENTITY(1,1) NOT NULL, […

  dtwilliams

  1 replies

  14 years, 7 months ago

  By: John Mitchell-245523

• Active Directory and T-SQL

  With AD as linked server and usage from openquery i can connect to the AD. Hower, i can’t edit the …

  D. van Braak

  8 replies

  14 years, 7 months ago

  By: Usman Butt

• Pivot/Unpivot, Geography UK region polygon data, trying to build polygon from either a column based result set of a row based result set

  Hi All I need to create a region polygon, for the attached data set. There are a number of lat/long…

  Ant-Green

  13 replies

  14 years, 7 months ago

  By: HowardW

• getting multivalue from a function

  Dear DBA's, I have a giant query which joins lots of tables. I have something like this: select ...…

  ashkan sirous

  16 replies

  14 years, 7 months ago

  By: ChrisM@Work