Thank you for your assistance.

Sorry about the bad data.  I took out the timestamp thinking it would simplify my example, obviously forgot to take it out of the...

Apologies, the template is created via another action. I need to update the data.

The two separate function are used in conjunction with our holidays table.  They are also...

Luis, you read my mind!

<a title="Go to ChrisM@Works profile" id="ctl00_ctlContentPlaceHolder_ctl00_ctl00_ctlTopic_ctl00_ctlPanelBar_ctlTopicsRepeater_ctl07_hypUsername" class="i-type-bold" href="https://www.sqlservercentral.com/Forums/Users/ChrisMWork">ChrisM@Work,
Thanks for the rewrite.  That's going to help a lot!

This is me getting greedy, but it gets used...

@ Jason A. Long and 

Nevermind, I found my answer.

I needed to re-configure the security of the mirror

I'm having the a similar problem. Administrators have full control, I am in the admin group, but when i try to open a file I get access is denied?!?

David92595

@jeff

If im going to hard code it wouldn't it just be easier (i.e. not having to create a view) to go with the IF @State = 'AZ'...

Its...

@jeff

Because I inherited this database and the person that made it thought in spreadsheets not relational tables.

@scott

Thank you! Are their any other good ways to stop...

That is Originally what I wanted to do, but after searching online, everyone seems paranoid of SQL injection. So I thought I'd do it this way...

How would I write...

Sorry for the delayed response.

I'm not sure I completely understand your question, cross apply is new to me, but I'll do my best.

Before "at" was being applied to view I...

Thanks guys

As a work around I was comparing one field at a time. This knocked 200 lines of code out of my report and cut execution time in half!

Wow, way over thought that one...

Thank you!

Hope someone checks this thread again,

I've expanded my query from a simple test to the real use of the query and I'm running into trouble with the following error: incorrect...

never mind, I figured fixed it.

I removed the sub query, as it was no longer needed, and used actual column Names instead of aliases. It's now worked. Not sure...