SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Faster way to populate number table variation with inline tally?

  Hi, I have to create a table like this across a bunch of servers. Does anyone see a faster way to d…

  sqldriver

  29 replies

  11 years ago

  By: aaron.reese

• Need assistance/guidance with a query

  I have a table where each unique entry can have up to 12 'modes', each mode with a start and stop d…

  podmate

  4 replies

  11 years ago

  By: Phil Parkin

• Get previous years holiday date

  Given this table; DECLARE @table TABLE (HolidayDate DATE, HolidayName NVARCHAR(50)) INSERT INTO @t…

  Geoff A

  4 replies

  11 years ago

  By: Geoff A

• xp_cmdshell to nmap

  I am trying to execute this and get an error that 'C:\Program' is not recognized as an internal or …

  wannabe1

  1 replies

  11 years ago

  By: wannabe1

• Date Table

  Good Morning, I need to create a table which holds date information for our financial year. I have…

  TSQL Tryer

  28 replies

  11 years ago

  By: Ed Wagner

• STUFF function issue with HTML tag

  Hey, I have the following query that supposes to merge multiple result in a single one and put it i…

  Yan Kleber

  2 replies

  11 years ago

  By: Yan Kleber

• Question about instant file initialization and non-service accounts

  Hello, My 3rd party backup product uses a non-service account login to perform tasks. If the accoun…

  sqldriver

  2 replies

  11 years ago

  By: sqldriver

• How to Create a DML trigger

  Hi Friends, I need a help from you. THe Scenario is We have Tables like parent and Child Table. Lik…

  arunnrj87

  5 replies

  11 years ago

  By: Grant Fritchey

• 'modify' stored procedure opens does not open for modifications as earlier

  when i click on the modify option on a stored procedure it is not opening for editing as earlier. i…

  ramnath555

  4 replies

  11 years ago

  By: ramnath555

• T-SQL : Change to Capture

  Hi All, Need a urgent help here. Thanks in advance fr your time and effort. I need to capture chang…

  syedathariqbal

  4 replies

  11 years ago

  By: Dwain Camps

• How to return user-defined row when a record doesn't exists

  Hello all, I was wondering if someone can help me with a query that I'm working on. What I want to …

  copling

  4 replies

  11 years ago

  By: Dwain Camps

• Concatenating Binary Rows

  Hi guys, I read this link and I have exactly the same problem: http://www.sqlservercentral.com/Foru…

  salardx

  6 replies

  11 years ago

  By: Eirikur Eiriksson

• Using DateDiff to work as Excel Networkdays

  Hi there, Happy New Year to all. So I am trying to work out the difference between today's date (G…

  TSQL Tryer

  2 replies

  11 years ago

  By: TSQL Tryer

• How to Pivot column to rows within a Group

  Hi Team, I need to convert the column to rows but within group. example Group Name …

  prateek.one4u

  3 replies

  11 years ago

  By: Jeff Moden

• Tally-OH! Help

  I need some help if someone is willing. I'm not a professional DBA however with Google as your frie…

  o324712

  5 replies

  11 years ago

  By: o324712