SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Bulk load error File Could Not Be Opened

  Trying to run a bulk load: INSERT INTO ICE_ContractPriceLimit(ReinsuranceYear, Record…

  Sean Grebey

  3 replies

  9 years, 12 months ago

  By: drew.allen

• Type conversion may affect CardinalityEstimate

  The query below ran fine but I am trying to correct the "type conversion in expression may affect C…

  mceventphoto

  6 replies

  9 years, 12 months ago

  By: mceventphoto

• sql commands in a job

  hi i want to run in a job the following SQL commands update Reports set SSIS=1 where ReportID=50 EX…

  gxdatareal

  10 replies

  9 years, 12 months ago

  By: OceanDrop

• pICKING EARLIEST DATE

  I need to pick earliest Security Date for each Security Id ..see attached sample text.. for securit…

  ssisguy

  3 replies

  9 years, 12 months ago

  By: ssisguy

• stored procedure then using the result set in SSIS

  Hi I'll start with the first issue I have a number of staging tables that, apart from the name, hav…

  DamianC

  2 replies

  9 years, 12 months ago

  By: DamianC

• Error in dynamic sql

  Hi i am getting error when i am running this query. Msg 102, Level 15, State 1, Line 7

  sks_989

  15 replies

  9 years, 12 months ago

  By: sks_989

• Database table design for scheduling solution

  I have a Configuration table with number of reports to be run, Weekly or Monthly. The configuration…

  hoseam

  4 replies

  9 years, 12 months ago

  By: hoseam

• issue with single quotes in the column values

  Hello Good Evening, I have a simple table named clientslist with columns Cust_Id, FirstName, LastNa…

  asita

  4 replies

  9 years, 12 months ago

  By: Eirikur Eiriksson

• Recurring deadlocks

  I've been having recurring and continue deadlocks due an store procedure with this code: --UPDATE…

  sql-lover

  12 replies

  9 years, 12 months ago

  By: ChrisM@Work

• Who is using a specific table

  Hi, I am trying to find a way to track who is querying a specific table. Is there a way to find it…

  Rem70Rem

  2 replies

  9 years, 12 months ago

  By: Gail Shaw

• Remove/Keep record based on group

  Hi, I have the following data: declare @Policy table ( Download varchar(20), AccountNum varchar(20)…

  scottcabral

  9 replies

  9 years, 12 months ago

  By: OceanDrop

• Need help with datatype Time conversion

  Hello All, I have source table with column nvarchar(20). the data looks like below. Duration 120:…

  Mac1986

  7 replies

  9 years, 12 months ago

  By: Mac1986

• indexes-non clustered

  hi all how to sort non clustered indexes ? any suggestion on this

  db8

  18 replies

  9 years, 12 months ago

  By: Eric M Russell

• Strange behaviour

  Hi all, Recently i any idea for fixing this ?

  monamym

  3 replies

  9 years, 12 months ago

  By: Sergiy

• Looking for the best way to create a comma-delimited values string for each record sin resultset without a cursor.

  If someone can give me a hand on how to most efficiently modify the attached SQL without a cursor (…

  VoldemarG

  2 replies

  10 years ago

  By: Eirikur Eiriksson