Wonderful! Thank you, the most direct way without the openrowset seems to work. I didn't even try that because I thought you could only have 3 identifiers (db,...

Sean Lange (9/27/2012)

---

dwain.c (9/26/2012)

---

Nice set up data Sean!

Using it, I'd like to offer a slightly less verbose solution:

SELECT *, WaitTime=DATEDIFF(minute

,CAST(check_in AS TIME)

,CAST(STUFF(appt_time,...

BEGIN

DECLARE @return_dt DATETIME;

SET @return_dt = CAST(CONVERT(varchar(11), CAST(@appt_date AS DATETIME), 120)

+ ' ' + SUBSTRING(@appt_time, 1, 2)

+ ':' + SUBSTRING(@appt_time, 3, 2)

+ ':00' AS DATETIME)

RETURN...

I AM new, and I am grateful for your help. I am actually quite new at query writing as well and I often find exactly what I am looking...

This might make more sense. Formatting is never my thing.

check_in

1911-03-02 14:00:00.000

1911-03-02 14:00:00.000

appt_time

1300

0950

This is a medical records things sp the amount of info I can give out is very limited. We use too many different third party apps that create their...