SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• sql server job has been modified by some DBA/user, I want to know which user modified/change job.

  Is there any way to findout who made last changes in a particular job using SQL Server default trac…

  shamshad.ali

  5 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• Help with query related to timesheets and overtime rules

  I've  been spending about a week in trying to figure out the best approach to accomplish this …

  troe_atl

  3 replies

  7 years, 10 months ago

  By: John Mitchell-245523

• Pivot distinct values only

  i need to report on the last six - last day of the month counts by department.  The query belo…

  jonathan.matt

  7 replies

  7 years, 10 months ago

  By: Chris Harshman

• Compare two tables and fill the validfrom and c

  hi, I would like to fill the fromdate and Todate dates of the UniqueConsumption2 tablefro…

  chozhanvijay 23273

  4 replies

  7 years, 10 months ago

  By: Sue_H

• Need to convert lowercase characters to 'a' and uppercase to 'A'

  Hi,I have a requirement to anonymise the data in table by replacing all the lowercase characters to…

  srikanthrv

  11 replies

  7 years, 10 months ago

  By: jonathan.crawford

• Tying MAX() value to <= value from another table

  This one is giving me fits. I'm querying mainframe data that has been imported to SQL. An "Inv…

  Brandie Tarvin

  10 replies

  7 years, 10 months ago

  By: Brandie Tarvin

• Question regarding Save Transaction and duplicates

  Hi, I am getting a duplicate  primary key failure message when two SPs called the same SP at t…

  Sridhar-137443

  6 replies

  7 years, 10 months ago

  By: Gail Shaw

• TSQL Help

  Hello, I was tasked with deploying a solution to monitor "Daily Activity Frequency" in Sales Person…

  seismicbeat

  1 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• Coding for Date Range for Specific Weekday- Time (Week To Date) Query

  Hello 1. Trying to modify below query to pull data for Week To Date using date from Sunday 3 AM to …

  rsiem

  4 replies

  7 years, 10 months ago

  By: drew.allen

• Compare previous and next rows to derive output

  Hello,Below is the SQL code for sample data. If Object_ID('tempdb..#Case','U') IS NOT NULL &n…

  akash_singh

  7 replies

  7 years, 10 months ago

  By: drew.allen

• Get min and max of columns of Table with the recursion checking

  Below is my requirement. I have given the one material number YHE30B21S as example. Table A ID Plan…

  chozhanvijay 23273

  13 replies

  7 years, 10 months ago

  By: Lynn Pettis

• OPEN QUERY Syntax issues.

  I'm a OPEN QUERY Newbie.I have my link server set up and simple queries work for example:select * F…

  osgcurt

  3 replies

  7 years, 10 months ago

  By: ScottPletcher

• parentheses effecting the scale

  In the code below, the placement of the parentheses is effecting the result of mktVal1.  Can s…

  rs80

  12 replies

  7 years, 10 months ago

  By: rs80

• Multi table join using derived table

  I am struggling to create a query that will return a report containing EO_AppUsers, EO_Policies and…

  hhale21

  4 replies

  7 years, 10 months ago

  By: hhale21

• How to get this result?

  SELECT               &nb…

  Charmer

  2 replies

  7 years, 10 months ago

  By: Charmer