SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• MAX Degree of Parallelism Option Not working in Resource Governer

  I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max…

  adhiman

  2 replies

  11 years, 7 months ago

  By: adhiman

• Slow performance with ALTER COLUMN

  I am working for a company that has a 3rd party vendor application. The Table that having an ALTE…

  Jason-299789

  4 replies

  11 years, 7 months ago

  By: Jason-299789

• DATEADD

  Good Morning. I have the following script that pulls me back a number of "jobs". SELECTDISTINCT…

  TSQL Tryer

  3 replies

  11 years, 7 months ago

  By: Phil Parkin

• stored procedure not running to completion and not returning results set

  Hi guys, This one has me a bit stumped... I have NEVER seen this before... I have stored procedure …

  aaron.reese

  3 replies

  11 years, 7 months ago

  By: aaron.reese

• Ranking using 2 columns in T-SQL 2012

  I have a table where basically I want to identify the first Invoice placed by an account. In the fi…

  chrismic999

  6 replies

  11 years, 7 months ago

  By: David Burrows

• Subtact or Exclude value items from a column and add it to another column in the same table

  I got a sales cost and cost amount table for my budget. the sales cost table is getting updated wit…

  jason.kleinhans

  1 replies

  11 years, 7 months ago

  By: Lynn Pettis

• Building a self-referencing hierarchical table.

  Greetings all 😀 So I have been doing some coding, and mostly scouring the internet for this today t…

  shannonjk

  10 replies

  11 years, 7 months ago

  By: Jeff Moden

• Quering from XML Type

  Hi there I have a plain XML variable <BS> <B Id="5" /> <B Id="3" /> <B Id=…

  Jako de Wet

  8 replies

  11 years, 7 months ago

  By: Hunchback

• XML - Multiple nodes with same name but different attributes

  How do I SELECT multiple nodes with same name but different attributes. For example, I would need …

  SQLSeTTeR

  9 replies

  11 years, 7 months ago

  By: SQLSeTTeR

• Min,Max,aG between two dates

  Hi, Need to calculate Open Ist Action and Close 1st Action from attached worksheet. Open Ist Action…

  PSB

  7 replies

  11 years, 7 months ago

  By: PSB

• SQL Server Databases Synchronization

  I have a control room with the following configuration: - 2 PCs running the control software, each …

  pgmoschetti

  19 replies

  11 years, 7 months ago

  By: TheSQLGuru

• Second Last work day of month

  Hi, I would like to get the second last work day of the month. Can anyone help me with that.

  praveen.arokiam

  8 replies

  11 years, 7 months ago

  By: Sachin Nandanwar

• Moving a couple of SQL Jobs from one machine to another

  I've had to write a couple of fairly complex SQL jobs, which I developed and tested on our test ser…

  Rod at work

  9 replies

  11 years, 7 months ago

  By: srikantmeister

• TSQL to detect update statistics

  Hello, I am working on an existing infrastructure and i do not have liberty to change much right no…

  ekant_alone

  8 replies

  11 years, 7 months ago

  By: sql-lover

• weird arithmetic overflow error

  We're running a piece of code to get spids of processes with locks on a table named "arss", then pr…

  jmoorhead14

  7 replies

  11 years, 7 months ago

  By: jmoorhead14