SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Use Dynamic Value in ADSI openQuery views

  Hello!There's a procedure declare @name nvarchar(100)declare @sql nvarchar(max)DECLARE @Test A…

  nkat

  14 replies

  7 years, 6 months ago

  By: sgmunson

• How to identify the row in which any of the column was updated?

  Hi, I am working on a scenario where I need to identify the rows in a table in which any of the col…

  Prasune Verma

  5 replies

  7 years, 6 months ago

  By: sgmunson

• Performing Join on SHA2_256 Hashed Column

  Hi All,  Having some issues with a hashing and matching based on a file.We have a hashed colum…

  waxb18

  3 replies

  7 years, 6 months ago

  By: sgmunson

• Issue with using STUFF

  HI,I am executing below query in query window then it works fine and get the result for Dept field …

  RCRock

  1 replies

  7 years, 6 months ago

  By: Thom A

• Recursive with multiple first lines

  I have a 4 level job explosion of shortage parts where the first level sometimes has multiple entri…

  ross.hughes

  14 replies

  7 years, 6 months ago

  By: Jeff Moden

• Header Row different than Output

  I'm lost here. Maybe I'm making this out to be more difficult than it really is, but here's the pro…

  SQL_Enthusiast

  5 replies

  7 years, 6 months ago

  By: Lynn Pettis

• Compare XML column to XML variable (The XML data type cannot be compared or sorted, except when using the IS NULL operator).‌‌‌‌‌‌‌

  Hello, I need to compare an XML column with an XML variable. If the values match, we will not proce…

  Lord Slaagh

  4 replies

  7 years, 6 months ago

  By: Lynn Pettis

• Find tables referenced as input/output in stored procedures

  Hello, I have a job that runs over 100 stored procedures daily. Each stored procedure has input tab…

  Coconut

  4 replies

  7 years, 6 months ago

  By: Coconut

• Find all stored procedures that use a particular db.

  Is there a way to list all of the stored procedures that use a particular database?

  NineIron

  6 replies

  7 years, 6 months ago

  By: Chris Harshman

• Without using group_by or xml_path how to concatenate multiple rows of a same id into a single row

  Input: ID             DESCRIPTION 1&nbs…

  manibad

  6 replies

  7 years, 6 months ago

  By: Jeff Moden

• Upper Case Lower Case

  Hello,I have a field that contains all capital letters.  For example, "SQL SERVER CENTRAL".&nb…

  rjjh78

  21 replies

  7 years, 6 months ago

  By: Jeff Moden

• Which log file is SQL Server ACTUALLY writing to?

  Is there any way to tell what log file sql server is actually writing to, not just what's in sys.ma…

  Onan Salad

  6 replies

  7 years, 6 months ago

  By: Sue_H

• Transpose Rows to column

  Can anyone help me to transpose below result SVR    dates   &nbs…

  sksingh123

  5 replies

  7 years, 6 months ago

  By: Jason A. Long

• Counting Active records for each month based on date range in 2 columns

  I am trying to get counts of active subscriptions for all products we have in a subscription table.…

  keithwms

  2 replies

  7 years, 6 months ago

  By: george_at_sql

• Check constraint where all records with the same effective date add up to one

  Hi Dev Masters, I had to call uncle on this one! I am trying to build a check constraint on a table…

  magical dev

  14 replies

  7 years, 6 months ago

  By: sgmunson