T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Update a record based on another record

  Hello all, I am looking for a way to update a record based on an already existing record. For ins…

  kwoznica

  10 replies

  15 years ago

  By: kwoznica

• Left join return wrong/incorrect count from each joined table

  I have following sample script to produce/understand the problem: CREATE TABLE [dbo].[tblVideo]( …

  Shamshad Ali

  2 replies

  15 years ago

  By: Shamshad Ali

• SQL Query

  There is a table Students with structure as follows: Sid SName TeamId 1 S1 …

  Praxo

  5 replies

  15 years ago

  By: Jeff Moden

• 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

  15 years 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

  15 years ago

  By: rafo

• update a table

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

  Deepthy

  3 replies

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years ago

  By: Don Halloran