T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 months ago

  By: ChrisM@Work

• Issue with stuff function

  Hi, Can any one corrrect my stuff function code..i want to get the output as 1','2','3','4; a…

  atlancharlo

  2 replies

  14 years, 4 months ago

  By: Manjuke

• concatenate parent and org base members in a hierarchy

  Hi fellow SQL gurus, I have a organization hierarchy table below. ID Parent Organization …

  yingchai

  6 replies

  14 years, 4 months ago

  By: yingchai

• (Re)Sorting records

  Hi!!! Let's consider next tables: create table Prods -- table of products (id int, name nvarchar(…

  halford13

  25 replies

  14 years, 4 months ago

  By: drew.allen

• using the with keyword

  I have a stored procedure like: Decalare @WebServiceGetResults XML = NULL DECLARE @BroadViewData TA…

  Faye Fouladi

  3 replies

  14 years, 4 months ago

  By: Faye Fouladi

• Querying Multiple Bit Columns Dynamically

  I have the following table structure for keeping Attribute Flags for products CREATE TABLE [dbo].[…

  Daniel H

  8 replies

  14 years, 4 months ago

  By: Jason Selburg