SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How can I see a DEPENDENCY TREE for objects used inside SP1 Stored Proc, and for each object referenced further inside each object, etc.?

  --------------------------------------------------------------------------- NESTED DEPENDENCIES:&nb…

  VoldemarG

  9 replies

  11 months, 2 weeks ago

  By: YSLGuru

• Sample between two dates for two date ranges ???

  Hi Having an issue  trying to figure out how to get my sample population where there are two date …

  jbalbo

  2 replies

  1 year ago

  By: drew.allen

• AttachDbFileName in Connection String in Vb.Net code gives errors.

  While using AttachDbFileName in the connection string to attach database to localdb,The following e…

  IT researcher

  3 replies

  1 year ago

  By: Johan Bijnens

• Invalid column name Error

  hi all, I'm trying to run this query to select from table (as html) to be used for sending an email…

  tanehome

  7 replies

  1 year ago

  By: tanehome

• Adding records between records

  Hi, Trying to figure out how to approach this... I will have data where these is an ID and a date. …

  jbalbo

  6 replies

  1 year ago

  By: Ken McKelvey

• Type 2 SCD without merge

  I 'lost' the code that was used to do type 2 SCD without a merge statement. I'm still hoping to fi…

  JustMarie

  5 replies

  1 year, 1 month ago

  By: Blade69

• Adding dates between data ???

  HI, Sorry for being so obscure on this problem, just not sure where to start. I have some data,  S…

  jbalbo

  2 replies

  1 year, 1 month ago

  By: ScottPletcher

• query to find the date/s that each user missing to signed in his attendance

  Good Day Everybody, I've missing something in this query but I can't catch it, it keeps give me err…

  tanehome

  2 replies

  1 year, 1 month ago

  By: ScottPletcher

• calculate and decimal

  Hi everyone, I've a calculate query as below but actually the result couldn't show the decimal numb…

  tanehome

  3 replies

  1 year, 2 months ago

  By: Jeff Moden

• Concatenate two field into one

  hi, I have  two fields USERID and AlternateUserid in a table A(users table) Alternateuserid is alw…

  komal145

  5 replies

  1 year, 2 months ago

  By: Phil Parkin

• Selecting distinct values from dupes based on latest date

  I have a table of patients that has often multiple occurrences of a patient number but with differi…

  DaveBriCam

  10 replies

  1 year, 4 months ago

  By: Ed B

• Put output of a dynamic query using OpenQuery into a temporary table

  Hello. I am tasked with converting some regular T-SQL queries to OpenQuery. I am very new to OpenQu…

  genova11

  1 replies

  1 year, 6 months ago

  By: pietlinden

• sql2012 equivalant

  How can I convert this statement for sql2012 ?  DATEDIFF_BIG  The t_stamp vale from table is defi…

  Bruin

  4 replies

  1 year, 9 months ago

  By: Bruin

• Anderson-Darling Calculation

  Hi   I am following an article posted on sql server central on the anderson-darling calculatio…

  jackdanny816

  1 replies

  1 year, 9 months ago

  By: jackdanny816

• query speed

  I'm trying to get record counts before doing some data archive, but query performance slow. any hel…

  Bruin

  2 replies

  1 year, 10 months ago

  By: Jeffrey Williams