SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• efficient Querying - NOT EXISTS

  hi, I have 1+5=6 tables, each of which have records around 200 million. I am required to aggregate …

  etl2016

  8 replies

  9 years, 10 months ago

  By: Jacob Wilkins

• Workaround for returning an nvarchar(max) from linked server SP

  Hoping someone can help on this one... A previous consultant wrote a 'Change request' system for us…

  DJH-445911

  2 replies

  9 years, 10 months ago

  By: DJH-445911

• Historical Date

  Hi, I need to wipe out just today's data and insert new ones . Yesterday's data should be untouched…

  PSB

  11 replies

  9 years, 10 months ago

  By: Sergiy

• Alternating weekly schedule

  I'm trying to create an Agent job that alternates it action each Saturday. In other words: first w…

  Mick Opalak

  3 replies

  9 years, 10 months ago

  By: Mick Opalak

• Which sp runs when a job fails and we notify operator via email

  Hi, In Sql Server 2012, I have setup (via checkbox in each job) to email the operator when any of m…

  Paul Bukowski

  4 replies

  9 years, 10 months ago

  By: Paul Bukowski

• Remove duplicates in result set

  Hi All, I'm fairly new to TSQL world. I have a requirement to remove recitative records from result…

  Mac1986

  6 replies

  9 years, 10 months ago

  By: Luis Cazares

• Reading "dynamic" XML string into table

  Hi All, I've been searching the web for an answer, but I can't seem to find an answer for the quest…

  kevinp81

  1 replies

  9 years, 10 months ago

  By: Eirikur Eiriksson

• Trouble with dates

  Thanks in advance to all who take the time and read this and offer help. I appreciate it! On to my …

  Fred Stemp

  8 replies

  9 years, 10 months ago

  By: Fred Stemp

• Gaps and islands sql : Condense upstream data

  Hi , There is data from upstream of different buses usage with StartDateKey and EndDateKey . The…

  sunil.mvs

  24 replies

  9 years, 10 months ago

  By: J Livingston SQL

• Looking For A Way to Check Data Spread Across Multiple Records; Looping Most Likely Involved

  Hello All, Please see the table below: Column A - Column B - Column C ----------- ------------- …

  scottisom

  4 replies

  9 years, 10 months ago

  By: ScottPletcher

• strange problem with varchar(8000) getting cut at 4000 characters

  Ok I am on a project that has lots of dynamic sql. So I have a case where I have statements that co…

  Jeffery Williams

  50 replies

  9 years, 10 months ago

  By: Jeffery Williams

• Query Result

  Hi All I have following table and its data Create table #ServiceDesk (ServiceName varchar(20),Crit…

  vijay_uitrgpv

  3 replies

  9 years, 11 months ago

  By: Eirikur Eiriksson

• Looking to "hack" the "Script As DROP"

  I hope someone can assist me. I'd like to know where I can find the code behind the SQL engine's "S…

  Brandie Tarvin

  15 replies

  9 years, 11 months ago

  By: Brandie Tarvin

• Please help with CURSOR - My 1st attempt and learning.

  So I just learned about using Cursors in my SP to loop through a dataset. So I set up a dummy test.…

  pvong

  4 replies

  9 years, 11 months ago

  By: Luis Cazares

• Find column values based on min and max of other columns

  Hi All, I have a Table which has Columns ID,IDDATE,JID,FROMID,TOID Values Below SELECT721 AS ID,…

  nm.rajesh

  5 replies

  9 years, 11 months ago

  By: John Mitchell-245523