SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  1 year, 4 months 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

  1 year, 4 months 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

  1 year, 5 months ago

  By: Labellep

• parse JSON formatted text into M3U Playlist

  sorry.. solved.. This topic was modified 1 year, 5 months ago by gentong.bocor. This …

  gentong.bocor

  1 replies

  1 year, 5 months 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

  1 year, 5 months ago

  By: ScottPletcher

• 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 r…

  jbalbo

  2 replies

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

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

  1 year, 7 months 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

  1 year, 8 months ago

  By: Ken McKelvey

• Type 2 SCD without merge

  I 'lost' the code that was used to do type 2 SCD without a merge statement. I'm still hoping to fi…

  JustMarie

  5 replies

  1 year, 8 months ago

  By: Blade69

• Adding dates between data ???

  HI, Sorry for being so obscure on this problem, just not sure where to start. I have some data,  St…

  jbalbo

  2 replies

  1 year, 8 months ago

  By: ScottPletcher

• query to find the date/s that each user missing to signed in his attendance

  Good Day Everybody, I've missing something in this query but I can't catch it, it keeps give me err…

  tanehome

  2 replies

  1 year, 8 months ago

  By: ScottPletcher

• calculate and decimal

  Hi everyone, I've a calculate query as below but actually the result couldn't show the decimal numb…

  tanehome

  3 replies

  1 year, 9 months ago

  By: Jeff Moden

• Concatenate two field into one

  hi, I have  two fields USERID and AlternateUserid in a table A(users table) Alternateuserid is alwa…

  komal145

  5 replies

  1 year, 9 months ago

  By: Phil Parkin

• Selecting distinct values from dupes based on latest date

  I have a table of patients that has often multiple occurrences of a patient number but with differi…

  DaveBriCam

  10 replies

  1 year, 11 months ago

  By: Ed B