T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• group and split the overlapped date

  hi, i have a question about this query problem declare @MeterContract table ( MeterContract int ide…

  x_japanfans5312

  4 replies

  14 years, 9 months ago

  By: x_japanfans5312

• multi-table query: returning data when one table has nothing?

  here is a sample simplified query: SELECT A.name, B.address, C.country FROM names A, addresses B, c…

  rafo

  5 replies

  14 years, 9 months ago

  By: rafo

• update a table

  Hi all, Any help is really apprecitaed. create table outputdatavesrion (Id int, outputid Int, outpu…

  Deepthy

  3 replies

  14 years, 9 months ago

  By: sturner

• Failed conversion when converting date and / or time from character string

  Hi, SELECT CONVERT(VARCHAR(30), CAST (CAST('110607120921' AS VARCHAR) AS DATETIME) ,110) I am get…

  PSB

  2 replies

  14 years, 9 months ago

  By: Jim Mackenzie

• sqlCmd large query

  I need to run a script that generates a table and inserts 300k records. sqlcmd truncates results to…

  steve conard

  6 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• Using a variable as the column in an update statement

  I have a table thats evolving into a look up table for windows/sql servers. I'd like to include dr…

  jshurak

  3 replies

  14 years, 9 months ago

  By: jshurak

• Using SELECT INTO a bad practice?

  Hi everyone, We have lots of reports which use SELECT INTO to insert data into the temp tables. I w…

  sunny.tjk

  21 replies

  14 years, 9 months ago

  By: Jeff Moden

• Update Action_Flag in fact table

  Hi All, I want to update my flag column based on incoming row i.e if suppose accounti…

  abhisheksrivastava85

  1 replies

  14 years, 9 months ago

  By: Sean Lange

• Adding certain rows to a query

  I have the following table (OFF_WELL_DATE is DATETIME datatype; OFF_WELL is int and has the number …

  marcoviy

  1 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• The multi-part identifier could not be bound.

  I am going to punch myself in the face. I have tried everything to get this to work and I keep gett…

  hkflight

  6 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Looking for help in T-SQL

  I've tables as following, CREATE TABLE [dbo].[PaymentItem]( [idx] [int] IDENTITY(1,1) NOT NULL, […

  Qira

  7 replies

  14 years, 9 months ago

  By: Welsh Corgi

• Update error

  Hi All, I am trying to update table with group by function but i am getting following …

  abhisheksrivastava85

  4 replies

  14 years, 9 months ago

  By: Don Halloran

• CASE 'inside' COALESCE

  Hiya, I have the following statement; ISNULL(COALESCE(ap.ABP_Name,at.ABT_Name,sp.SKP_Name,st.SKT_Na…

  lanky_doodle

  3 replies

  14 years, 9 months ago

  By: lanky_doodle

• money or decimal type

  Hi. i do a shopping site and i need to keep products' price. Which data type do i use? i think to u…

  sa.ordekci

  2 replies

  14 years, 9 months ago

  By: Jayanth Kurup

• here is the smart question.............

  I have created two partitions on different columns for same table. I posted queries below ON Dateti…

  sqlmaverick

  1 replies

  14 years, 9 months ago

  By: Steve Jones - SSC Editor