SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Fill in missing hours for each VisitID during the day

  create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID, ER_Date, HR) …

  NineIron

  11 replies

  2 days ago

  By: Jeff Moden

• Script to list replicated views and function

  I use the following code to list replicated tables: SELECT Name FROM sys.views WHERE is_replicated…

  Welsh Corgi

  9 replies

  2 weeks, 2 days ago

  By: jjradha

• TSQL query - adapt Part2 to include Part1

  CREATE TABLE [dbo].[zA]( [InvoiceNo] [nvarchar](255) NULL, [Code] [nvarchar](255) NULL, [Date] [dat…

  kevinyl

  4 replies

  2 months ago

  By: kevinyl

• UPDATE using table alias

  Hi Gang- I have some stored procedures that do updates using table aliases, like this: UPDATE Table…

  autoexcrement

  6 replies

  4 months, 3 weeks ago

  By: Pete Softown

• Adapt the query to 2012

  Hello I have a query that works as a loop but it is slow. How can I do this with a standard query? …

  meryemkurs072

  15 replies

  5 months, 2 weeks ago

  By: dale_berta

• Insert using table unput

  I have a table that I need to run off a different server\db and looking for the most efficient way …

  Bruin

  14 replies

  7 months ago

  By: Bruin

• Pivot 1 row to multiple columns using T SQL

  Hello. I have data in a table that I want to pivot from 1 row to multiple columns. I only want the …

  genova11

  5 replies

  8 months ago

  By: Jonathan AC Roberts

• row changes per hour by TagID

  I have a large table being written too every second with equipment (PLC) information. I need to fig…

  Bruin

  12 replies

  8 months, 2 weeks ago

  By: Bruin

• row changes per hour by TagID

  I have a large table being written too every second with equipment (PLC) information. I need to fig…

  Bruin

  2 replies

  8 months, 3 weeks ago

  By: Bruin

• Row_Number issue....

  Hi   I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…

  jbalbo

  5 replies

  9 months, 1 week ago

  By: ratbak

• Row_Number issue....

  Hi   I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…

  jbalbo

  1 replies

  9 months, 1 week ago

  By: ratbak

• Row_Number issue....

  Hi   I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…

  jbalbo

  1 replies

  9 months, 1 week ago

  By: ratbak

• The data types xml and varchar are incompatible in the equal to operator.

  Hi I'm trying to return all rows where the field DocumentXML equals 'Document' The data in the fiel…

  Labellep

  2 replies

  10 months, 2 weeks ago

  By: Labellep

• parse JSON formatted text into M3U Playlist

  sorry.. solved.. This topic was modified 10 months, 2 weeks ago by  gentong.bocor. …

  gentong.bocor

  1 replies

  10 months, 2 weeks ago

  By: Phil Parkin

• Parse out filed as date time ???

  Hi   I have a field with a start and end date (sometimes no end date) . How can I parse this o…

  jbalbo

  9 replies

  10 months, 2 weeks ago

  By: ScottPletcher