Thank you for all the kind responses! I will take a look at all the code.

Chef

Thanks. Worked fine. Kudos!

I didn't nuke the (x86) folder as well! I didnt realize SQL installed there (64-bit version)

Well that is a great question. I am not sure I know how to perform that...

Thank you for the suggestion.

Why is this code better than mine? I will look at them and read up, can you...

george sibbald (1/10/2016)

---

I would expect deleting the current file via explorer so that the backup is creating a fresh file to work.

Copy or move the existing file elsewhere to be...

Lynn Pettis (4/21/2015)

---

Try this:

CREATE PROCEDURE YourProcName

(

--DECLARE

@dtstart_time DATETIME ,

@dtend_time DATETIME

)

AS

BEGIN

SET NOCOUNT ON;

DECLARE @parts TABLE

(

...

dwain.c

Can you assist?

Thank you very much,

Chris

Thanks...

Now my final issue is getting the Avg_Covers...

CoverAvg = SUM(Net / Total_Covers)

But I keep getting this:

Msg 207, Level 16, State 1, Line 30

Invalid column name 'Net'.

Msg 207, Level 16, State...

I've solved it anyway. Thanks for your time.

Funny when I posted SQL script with fragments I was getting plenty of help. Then I attempt to do it the proper way...

Ticket Table Test Data

SELECT '66517','0','Deu Bank','1386.00','203.74','0.00','1866.94','1866.94','277.20','NULL','NULL','205','2014-06-25 17:03:31.407','2014-06-25 22:21:12.120','1','NULL','NULL','NULL','205','0','0','205','NULL','154','1386.00','203.74','2679','1753-01-01 00:00:00.000','22','0','7','0','0','0.00','1','NULL','53292974-1149-4AEE-B8C9-1BE0990A989F','0x000000000177F502','2014-06-25 19:56:55.633','NULL','0','FullyPaid','0.00','0','NULL','NULL'

Late Night (10pm - 4am)

Although the POS software's 'day' is from 4am to 4am...our clock is 12am to 12am. So I have ascertained the issue is with the dayPart moving...

So I figured out the issues...well, whats wrong anyway.

i_period_definition = 4, the Late Night dayPart, from '1899-12-30 22:00:00.000' to '1899-12-30 04:00:00.000'

SO...22:00 hours, or 10pm to 4:00, or 4am is going...