T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to get distinct records from table

  Suppose I have 2 table 1)Main 2)History Main table maintain all the records having columns MAIN_S…

  Gaja

  3 replies

  11 years, 11 months ago

  By: SQLCJ

• Can some pull off this query for me..

  Having an absolute rough day today.. not able to write the simplest of simplest queries.. love bein…

  a4apple

  4 replies

  11 years, 11 months ago

  By: Jeff Moden

• Assigning Batchid to Cake Making Process

  Hi , Please observe below records of table Bakery . When cake is order it flows from BaseMaking…

  sunil.mvs

  13 replies

  11 years, 11 months ago

  By: Dohsan

• Parsing xml data

  Hi All, I have a xml as given below . I need to parse this and retrieve the employee ids present in…

  arijit rath

  1 replies

  11 years, 11 months ago

  By: a4apple

• Inserting Null value

  Hi All, I'm trying to insert multiple records, each containing a null value for one of the fields, …

  daniness

  5 replies

  11 years, 11 months ago

  By: Neil Burton

• Embedding a variable into a parameter when calling a stored procedure

  HI all, I want to add the result of a Select statement inside a parameter, not too sure how to pul…

  Jake Shelton

  2 replies

  11 years, 11 months ago

  By: Jake Shelton

• Trying to build a stored procedure with insert into...

  OK, to simplify some annual auditing of DB users (not the SQL logins,) I'm trying to craft a stored…

  jasona.work

  7 replies

  11 years, 11 months ago

  By: jasona.work

• Complex SQL Pivot Query Urgent Help Needed

  Hi Guys, I want to convert the data from Original Table to Reporting View like below, I have tried …

  a1112877

  6 replies

  11 years, 11 months ago

  By: kramaswamy

• What does >+ do?

  I Have a question for all you t-sql experts. I made a type in my code that I just noticed today. …

  Steven.Howes

  12 replies

  11 years, 11 months ago

  By: Eirikur Eiriksson

• Moving Values from Temp table to another tamp Table

  Hi, Below are my temp tables --DROP TABLE #Base_Resource, #Resource, #Resource_Trans; SELECT data.*…

  KGJ-Dev

  2 replies

  11 years, 11 months ago

  By: KGJ-Dev

• Changes not holding in Stored Procedure

  I am connecting to a new SQL Server 2008 R2 database using SSMS from my ADMIN VM workstation. I bri…

  rummings

  10 replies

  11 years, 11 months ago

  By: Grant Fritchey

• Help need in Avoiding Loop

  Hi, Here is my table structure: ;with Users as ( select 1 as UserId, 2 as PendingAmount,10 as Avai…

  born2achieve

  29 replies

  11 years, 11 months ago

  By: Jeff Moden

• Need assistance with XML

  Hello all, I have a table which contains an XML column. This column is set up as "<properties>…

  kramaswamy

  2 replies

  11 years, 11 months ago

  By: kramaswamy

• Aliases in OPENQUERY

  Hi All I have the following query SELECT [KPI].* FROM OPENQUERY(LINKED_OLAP,'SELECT HEAD(TAIL…

  Igor Micev

  1 replies

  11 years, 11 months ago

  By: Lowell

• generate random value before @ in email address

  Hello, Here is my table, CREATE TABLE test_43(id int, email varchar(50)) INSERT INTO test_43 VALUES…

  dallas13

  6 replies

  11 years, 11 months ago

  By: dallas13