SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  3 hours, 36 minutes 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

  1 month 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

  1 month, 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

  1 month, 2 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

  2 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

  2 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

  2 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

  3 months, 1 week ago

  By: Labellep

• parse JSON formatted text into M3U Playlist

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

  gentong.bocor

  1 replies

  3 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

  3 months, 2 weeks ago

  By: ScottPletcher

• How can I see a DEPENDENCY TREE for objects used inside SP1 Stored Proc, and for each object referenced further inside each object, etc.?

  --------------------------------------------------------------------------- NESTED DEPENDENCIES:&nb…

  VoldemarG

  9 replies

  4 months, 1 week ago

  By: YSLGuru

• Sample between two dates for two date ranges ???

  Hi Having an issue  trying to figure out how to get my sample population where there are two date …

  jbalbo

  2 replies

  5 months ago

  By: drew.allen

• AttachDbFileName in Connection String in Vb.Net code gives errors.

  While using AttachDbFileName in the connection string to attach database to localdb,The following e…

  IT researcher

  3 replies

  5 months ago

  By: Johan Bijnens

• Invalid column name Error

  hi all, I'm trying to run this query to select from table (as html) to be used for sending an email…

  tanehome

  7 replies

  5 months, 2 weeks ago

  By: tanehome

• Adding records between records

  Hi, Trying to figure out how to approach this... I will have data where these is an ID and a date. …

  jbalbo

  6 replies

  6 months ago

  By: Ken McKelvey