SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• dynamic moving date ranges

  Hi, Say I've got a table of events (dates).  I want to count the event only if there has been …

  metralgia

  4 replies

  8 years, 9 months ago

  By: metralgia

• DUPLICATING A ROW BY NUMBER OF OCCURENCE OF A PARTICULAR FIELD IN ANOTHER TABLE

  Hello, I have this challenge that has been an issue for weeks now. I have a table A with 7 rows wit…

  JALLY

  9 replies

  8 years, 9 months ago

  By: JALLY

• Single column into multiple columns with values based on delimiters

  Hi I am trying to figure out a way to parse a very long column and display it in a more user friend…

  aaronsmity

  5 replies

  8 years, 9 months ago

  By: aaronsmity

• Age as of January 1st

  Hello all,I'm really strugling on this age calcualtion. I need to find the age of a patient based o…

  thomashohner

  24 replies

  8 years, 9 months ago

  By: thomashohner

• Convert number to certain value from table

  Hi, I have table name [@tbl_value], columns are 'Code', 'Name'Records:Code Name1     &nbs…

  BTG

  13 replies

  8 years, 9 months ago

  By: BTG

• DATETIME Conversion Error (where none should exist)

  Hello, I have just taken a new DBA job so don't criticize the overall query. I'm just trying to get…

  Jim

  8 replies

  8 years, 10 months ago

  By: Jim

• Check for Table Existance/Data At Same Time

  I have a need to check various database(s) not only for existence of a table but also, if the table…

  DB_Newbie2007

  1 replies

  8 years, 10 months ago

  By: John Mitchell-245523

• Most efficient Running Total with COUNT(DISITNCT #)

  Hello All, I'm trying to fine the most efficient way of doing a running total of COUNT(DISTINCT ID'…

  thomashohner

  4 replies

  8 years, 10 months ago

  By: thomashohner

• Finding Within dates

  Hi      Im new to sql  and I have a date column created , I'm trying to fi…

  Suth

  13 replies

  8 years, 10 months ago

  By: Jeff Moden

• Getting morning, afternoon and evening matches from a set of dates by day of week

  Hi all; I can get the info an individual day like this; INSERT INTO #TEMPSELECT '01/01/2017 09:00:…

  kangarolf

  4 replies

  8 years, 10 months ago

  By: drew.allen

• Any ideas on bad query plan?

  I would appreciate review and opinions of below issue. I believe issue is data related, but confuse…

  sqladdict

  3 replies

  8 years, 10 months ago

  By: ScottPletcher

• How to find PRIOR line of service? Help plz!

  Hi guys!So I am stuck! I am trying to find prior line of service and I cannot come up with an appro…

  REYES_MONIKA

  8 replies

  8 years, 10 months ago

  By: REYES_MONIKA

• EXECUTE AS and REVERT

  I've been playing around with permissions on a stored procedure and noticed that when using REVERT …

  Dohsan

  2 replies

  8 years, 10 months ago

  By: Dohsan

• Restore database with move

  Hi everybody,I have a script to restore a database with move. I do not have a database yet for this…

  Manie Verster

  14 replies

  8 years, 10 months ago

  By: Manie Verster

• The Adjacency List Model & Nested Sets

  Hello, Could someone please explain me that the Adjacency List and Nested Sets structures are …

  seismicbeat

  2 replies

  8 years, 10 months ago

  By: seismicbeat