SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Decrementing total

  I have an procedure that uses a cursor to decrement a total in one table based on value in another.…

  Robert Klimes

  5 replies

  9 years, 9 months ago

  By: vs.satheesh

• filter out not numeric values

  Hello, I have script: Select CASE WHEN (ABS.VALUE<90 AND ABC1.VALUE<140) THEN 1 ELSE 0 END AS…

  al.yukhvidin

  5 replies

  9 years, 9 months ago

  By: GSquared

• Database attached to SSIS packages in SQL Agent

  Hello Everyone, I have over 50 SQL agent jobs with SSIS packages and over 120 Databases on my SQL s…

  AlianaRivera887

  6 replies

  9 years, 9 months ago

  By: FridayNightGiant

• TSQL dilemma

  Code snippet: use testdb2 go DECLARE @filevalue varchar(50), @VarFileName varchar(50); exec dbo.Get…

  fizzleme

  3 replies

  9 years, 9 months ago

  By: fizzleme

• How to Eliminate or flag duplicate records

  Hello Everyone, I am having a table with millions of rows in it and there are the columns are like …

  Shekhar Mishra

  4 replies

  9 years, 9 months ago

  By: Shekhar Mishra

• is there any over head of begin try cahce ?

  hi, i wanted to know , is there any overhead of begin try cache, like is there any situation it tak…

  rajemessage 14195

  6 replies

  9 years, 9 months ago

  By: Luis Cazares

• where i should put set trasaction isolation level read uncommited/ snapshot

  hi, stmt 1) CREATE PROCEDURE xyz1 AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets…

  rajemessage 14195

  1 replies

  9 years, 9 months ago

  By: John Mitchell-245523

• select into / insert into error not recognizing columns invalid columns

  Same Server, Different database Source table CREATE TABLE [dbo].[EvalOne]( [UserID] [int] NULL, […

  bdkdavid

  7 replies

  9 years, 9 months ago

  By: Phil Parkin

• SSIS Refuses to capture a single row result set as a variable.

  I am running a simple query "select FileName from testtbl where substring(FileName,18,8) =(select …

  fizzleme

  8 replies

  9 years, 9 months ago

  By: fizzleme

• XML import to tabel in ms sql

  Hi, I need to get data from an XML file and inserted in a table in ms sql. XML file is changed and …

  mite

  6 replies

  9 years, 9 months ago

  By: mite

• SQL Server begin transaction and commit inside of an cursor

  I have stored procedure as following, and I am using a batch file to call this sp. anyone can help …

  ypeng5

  2 replies

  9 years, 9 months ago

  By: ypeng5

• DATEPART / DATENAME

  Hello, We're Tuesday. It's important for what's coming. I encountered an issue on the DATENAME func…

  Johan_1975

  4 replies

  9 years, 9 months ago

  By: Johan_1975

• Using data windows in 650M rows table

  I have a 680M rows table. This table contains data for each customer. I need to have a rollup table…

  celia.moreno

  5 replies

  9 years, 9 months ago

  By: ChrisM@Work

• Computed column with leading static number

  static number (12345) + ID number

  nilknarf

  9 replies

  9 years, 9 months ago

  By: Sergiy

• Performance difference with filter index and with out filter index

  Hi, I have a table 'AAA' Structure: CREATE TABLE AAA (ID BIGINT PRIMARY KEY CLUSTERED,Name VARCHAR(…

  dudekula.kareemulla

  2 replies

  9 years, 9 months ago

  By: ScottPletcher