T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• pivot the coloum when occurences are not known

  This is my MS SQL query select x1.ItemName, x4.ContractorCommodityCode, x4.ShortMaterialDescripti…

  kishore99me17

  1 replies

  15 years, 10 months ago

  By: WayneS

• Using a Linked server name as a variable

  I’ve created a solution to a problem I had but I’m not sure it’s the best away about it doing it. B…

  Djcarpen11

  5 replies

  15 years, 10 months ago

  By: jvanderberg

• Inserting Data Into Table Variable from Extended Stored Procedure

  Hello Everyone Hope that your day is going well. I have an extended stored procedure, I can fire it…

  AndrewSQLDBA

  3 replies

  15 years, 10 months ago

  By: Tarun Jaggi

• Read XML and Insert into Table with condition

  SETUP: CREATE TABLE [dbo].[MEDICINES]( [MEDICINE_NUM] [int] IDENTITY(1,1) NOT NULL, [MEDICINE_NA…

  Chaitanya Patil

  2 replies

  15 years, 10 months ago

  By: Chaitanya Patil

• Null Fun

  Hi, More of a gotcha than a question, although I'm curious as to what is happening in the situation…

  irobertson

  9 replies

  15 years, 10 months ago

  By: Jeff Moden

• insert error check

  The data does not exist in main table INSERT INTO MAIN_TABLE SELECTCOLUMN1, COLUMN2 FROM TEMP_TAB…

  TRACEY-320982

  3 replies

  15 years, 10 months ago

  By: TRACEY-320982

• Dynamic Query

  Hi Here I have a Table such as the following : IDintPrimary Key TitlenVarchar(500) Parent_ID…

  platipino

  2 replies

  15 years, 10 months ago

  By: platipino

• generate the header after every unique rows

  here looks my source table declare @test-2 table (Name varchar(3), userid char(5)) insert into @t…

  rahulsony111

  7 replies

  15 years, 10 months ago

  By: Eugene Elutin

• DATEDIFF function resulted in an overflow on one instance not the other

  Any idea why I get the "datediff function resulted in an overflow... error on one instance of SQL S…

  SSSolice

  7 replies

  15 years, 10 months ago

  By: SSSolice

• Deleting with a c ursor

  sorry to post this twice This a the basic statement USE master; GO SET NOCOUNT ON; GO DECLARE AllDa…

  Jaime E. Maccou

  1 replies

  15 years, 10 months ago

  By: John Rowan

• Pivot Table

  Dear All, May I ask your help on how can I make the date range my column, based from this I will ju…

  jessajr

  7 replies

  15 years, 10 months ago

  By: The Dixie Flatline

• how to manage insert update and delete operation in one procedure

  Hii.. how to manage insert update and delete operation in one procedure.. Thanks.

  Vaghasiya Nilesh

  2 replies

  15 years, 10 months ago

  By: Tarun Jaggi

• Extended Stored Procedure Returning One Column, not one Row

  Hello Everyone I am still working with one of the extended stored procedures. One comes back in nor…

  AndrewSQLDBA

  2 replies

  15 years, 10 months ago

  By: Jeff Moden

• Import Export Wizard Error

  Hi, I'm just importing some tables from one server to another server. But now i'm getting this erro…

  tripri

  1 replies

  15 years, 10 months ago

  By: Adiga

• comma seperated result in a subquery

  Hi All, I need to produce a comma seperated result in a subquery that way reducing the record c…

  ramadesai108

  2 replies

  15 years, 10 months ago

  By: ramadesai108