T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• nt given output server2000

  create procedure data_dd( @a varchar, @b-2 nvarchar) as begin select slno,goals,kpi,weightage,…

  raghuldrag

  14 replies

  13 years, 10 months ago

  By: raghuldrag

• How to combine tables in one straight row?

  Hello friends, I hope every one is in good condition upon reading this forum. I am finding a hard t…

  marksquall

  4 replies

  13 years, 10 months ago

  By: marksquall

• creating procedure in server 2000

  select slno,goals_type,entrydate, goals,date_of_commitment,kpi, weightage,goals_review_date --into …

  raghuldrag

  2 replies

  13 years, 10 months ago

  By: Phil Parkin

• calculate trend of a column

  I have a temp table where Iam inserting data from original table temp_id, temp_test_id, temp_status…

  jaya

  15 replies

  13 years, 10 months ago

  By: Dwain Camps

• Problem with query

  Hi, I have the following scenario as ------- Astore--------------------------Bstore --------Parker …

  Shadab Shah

  7 replies

  13 years, 10 months ago

  By: rhythmk

• bcp with xml insert

  Hi all I am trying to insert a flat text fixed width in to SQL 2008r2. I have tried but not winning…

  jerome.morris

  6 replies

  13 years, 10 months ago

  By: David Webb-CDS

• INSERT into Target table from Source table, redirecting duplicate key rows into ERROR table

  1) Source tables are heaps 2) Target tables are identical except with primary key columns. They oft…

  dcwilson2009

  15 replies

  13 years, 10 months ago

  By: dcwilson2009

• evaluating and combining values from two rows

  I am running into a bit of trouble with the query below, would be great If you could offer some ins…

  thomasrichardson2000

  9 replies

  13 years, 10 months ago

  By: Luis Cazares

• passing more than one value to a SP

  I need to execute this stored procedure. Problem is that I need to pass in more than one value. At …

  thomasrichardson2000

  6 replies

  13 years, 10 months ago

  By: thomasrichardson2000

• how to use STRTDT token in a JOB

  If anybody knows about token in sqlserver ...Please provide me one smalll example for STRTDT token …

  Krissh_pallu

  1 replies

  13 years, 10 months ago

  By: OTF

• Drop Table if exists

  HI, For Droping a table if exists I am using below commands ,Is there any other efficient way of do…

  Rakesh.Chaudhary

  9 replies

  13 years, 10 months ago

  By: Michael Valentine Jones

• subquery

  hi can we user order by inside subquery?

  harri.reddy

  8 replies

  13 years, 10 months ago

  By: Gail Shaw

• Will indexed view help this query?

  Hi I have a fact table with around 100 million rows. Below is my query to pull top 10 records. ( i …

  S_Kumar_S

  10 replies

  13 years, 10 months ago

  By: S_Kumar_S

• How to delete data from Product table by ProductID in AdventureWorks

  I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Datab…

  manhthao.dn

  1 replies

  13 years, 10 months ago

  By: rVadim

• depend objects

  hi, how to find number of objects your stored procedure depend.

  harri.reddy

  1 replies

  13 years, 10 months ago

  By: sandeep rawat