T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• schema changed after the target table was created. rerun the select into query

  Hello I am using select into a temporary table as part of an etl package. There are multiple packag…

  MichaelMontgomery

  16 replies

  14 years ago

  By: Paul White

• Create Table since a store procedure

  Can I create a table since a store procedure in Sql 2008? I need to send the name of the table and …

  sistemas_casinomnes

  1 replies

  14 years ago

  By: David Webb-CDS

• Add Schema to missing Index Script

  I want to include the schema as one of the columns since the tables are duplicated in two different…

  Welsh Corgi

  10 replies

  14 years ago

  By: Welsh Corgi

• Date in EST

  I am replacing my "end date" to getdate () when it is null.Something like below isnull(temp.end_tim…

  komal145

  3 replies

  14 years ago

  By: komal145

• Function to check each colum and return result

  Hi, I have the following table: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING …

  SQL_Kills

  21 replies

  14 years ago

  By: SQL_Kills

• Need a SQL Query

  Hi everyone, I have table named ENCOUNTER_PARTY CREATE TABLE ENCOUNTER_PARTY( ENCOUNTER_KEY INT, PA…

  vaibhav.tiwari

  12 replies

  14 years ago

  By: vaibhav.tiwari

• Benefits of INDEX(0) and INDEX(1) hints

  The INDEX(1) query hint forces the query to use an INDEX scan or seek. Are there exactly two ways …

  Golfer22

  1 replies

  14 years ago

  By: Gail Shaw

• Comparison Across Columns

  Hello there. I'm currently wracking my mind over this issue, which is probably stupidly simple, bu…

  Andrew Kernodle

  20 replies

  14 years ago

  By: ScottPletcher

• Past 3 month's average every month

  Hello, All. I've managed to stump myself on a query. Here's what I need: One of the metrics my comp…

  apratsunrthd

  5 replies

  14 years ago

  By: apratsunrthd

• Delete query with like option is not working

  Hi friends , I need to Delete from table with conditions : Example of my query!!! Delete from TAb…

  komal145

  2 replies

  14 years ago

  By: komal145

• Delete query with like option is not working

  Hi friends , I need to Delete from table with conditions : Example of my query!!! Delete from TAb…

  komal145

  2 replies

  14 years ago

  By: komal145

• Delete query with like option is not working

  Hi friends , I need to Delete from table with conditions : Example of my query!!! Delete from TAb…

  komal145

  2 replies

  14 years ago

  By: Lynn Pettis

• Store output in Tables of Store Procedure which gives OUTPUT in more than 1 DataSet (Table)

  Dear All, Hi I have a Store Procedure which gives OUTPUT in 2 Data Sets (Tables). Now I need to sto…

  bharat sethi

  2 replies

  14 years ago

  By: SQL Padawan

• IN vs Exists

  Hi All, I have a basic doubt on using IN/EXISTS. When to use IN over Exists/Exists over IN? I heard…

  SQL*

  9 replies

  14 years ago

  By: FunkyDexter

• Pull Out Min Date in QUERY

  Hi FOrumer's I have my query to get the min date from sample2 table using the ESN andreturndate as …

  Kaniguan_SQL

  3 replies

  14 years ago

  By: Dwain Camps