SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Overlapping Date Ranges

  Hi there,I have looked in many forums and have been unable to find what I am looking for to get the…

  shel 29143

  4 replies

  6 years, 7 months ago

  By: jonathan.crawford

• Union with co-related subquery

  I am trying to take MAX(date) from the result set of three different tables using a UNION operator.…

  binumon.vijayan

  4 replies

  6 years, 7 months ago

  By: drew.allen

• Issue updating columns for existing rows

  Hi there,so I have this table I've added additional columns to. For existing rows I want to update …

  DinoRS

  5 replies

  6 years, 7 months ago

  By: DinoRS

• I‌ wanted to run a stored proc over 500 databases in production.

  Hello Room,I'm not hundred percent sure on how to program in T-SQL. I wanted to run a stored proc o…

  Ed7

  3 replies

  6 years, 7 months ago

  By: Grant Fritchey

• Job Schedule KO / SQL Server 2012R2

  Hello everyone.Let me first explain what the job does. Basically it executes a T-SQL query (custome…

  yucef.naimi

  1 replies

  6 years, 7 months ago

  By: fahey.jonathan

• How to round a value in a varchar column ?

  Dear Forum, I have a strange requirement to round a value in a varchar column in MS SQL*Server 2012…

  allan.ford17

  4 replies

  6 years, 7 months ago

  By: koti.raavi

• Subset rows with opening and closing balance

  Hello All, I trying to get result as mentioned below (excel format for illustration purpose only).&…

  kiran 4243

  6 replies

  6 years, 7 months ago

  By: kiran 4243

• query regarding compare-object output

  Hello ,Can anybody help me with below : compare-object (get-content file1.txt) (get-content file.tx…

  Namrish

  4 replies

  6 years, 7 months ago

  By: Jeff Moden

• Table Join with Grouping problem

  Morning,I'm looking for some help on my query, it really a grouping problem.I've joined 2 unsimilar…

  gjoelson 29755

  1 replies

  6 years, 7 months ago

  By: sgmunson

• SQL QUERY: Request For Part Overflow

  I have events on my database.Every event has datetime to be started and datetime to be ended.In eve…

  dderesdd

  4 replies

  6 years, 7 months ago

  By: dderesdd

• Save the actual execution plan of a SQL statement in a script

  I have a script that runs in SSIS from an "Execute SQL Task". One statement that is taking about 1 …

  Jonathan AC Roberts

  13 replies

  6 years, 7 months ago

  By: Grant Fritchey

• VARBINARY not storing the original value

  Hi,To identify the changes in the columns, I am using the Hashbytes function and storing the return…

  Rocky's

  2 replies

  6 years, 7 months ago

  By: Rocky's

• Select Column Value based on date

  HI , I'm looking for some help figuring out how to go about Selecting Column Value based on  t…

  gjoelson 29755

  2 replies

  6 years, 7 months ago

  By: gjoelson 29755

• Various ODBC File Data Type Images must be written in the proper format on to disk. SQL Server 2012 Enterprise

  Hello Folks.In a table are stored over 1 million ODBC documents (doc, pdf, excel ). I want to write…

  alphanew

  2 replies

  6 years, 7 months ago

  By: alphanew

• Combine multiple stored procedures to create one report using cursor.

  What I'm trying to achieve should look like this and my stored procedure should accept a singl…

  andrew.polemeni

  5 replies

  6 years, 7 months ago

  By: pietlinden