Not sure how we can help. Deferred name resolution allows you to create an object, like a stored procedure, before other objects used in the procedure are actually created.

If...

The print statements are buffered. You won't see them until the buffer is full and the OS (or is it actually SQL Server, not sure) sends them to SSMS.

This is to prevent data loss between the principal and mirror databases. Asynchronous commits data to the principal without waiting for it to be committed on the mirror. ...

You are going to have to break the mirror and set it up again on the other server.

tmac25 (6/7/2013)

---

So, say I have a record where StartTime is '2013-06-07 13:00:00.000' and EndTime is '2013-06-07 13:02:00.000'

Is there a way to have T-SQL select this record if I'm querying for...

dbman (6/7/2013)

---

Customer Table Sample Data:

001|08|C3000|Company1|014|6020

001|08|C3001|Company2|014|6020

001|08|C3002|Company3|014|6030

001|08|C3003|Company|014|6030

001|08|C3004|Company5|014|6030

001|08|C3005|Company6|014|6030

001|08|C3006|Company7|014|6030

Sales Table Sample Data:

01|C3000|2013|1| 9191.16| 7335.65

01|C3001|2013|1| 0.00| 0.00

01|C3002|2013|1| ...

Unfortunately you haven't provided enough information for anyone to try and help you. We really need to see the entire procedure plus DDL for the tables involved, sample data...

Would help to see the code and the actual execution plan. Without at least the code all you are going to get are shots in the dark. The...

Sean Lange (6/6/2013)

---

What you had was VERY close. Both Lynn and I had a solution that returned the values instead of IDs. I have to say that returning the IDs...

Sean Lange (6/6/2013)

---

Dird (6/6/2013)

---

Sean Lange (6/6/2013)

---

This gives you the best of both worlds. You have the advantage of a tally table, it is persistent in that it can be queried...

SteveEClarke (6/6/2013)

---

Yes - I understand - but that is what the TrnYear and TrnMonth fields are.

so forget the TrnDate Fields -

I suppose something like ....

Max TrnYear, TrnMonth to give...

Dird (6/5/2013)

---

Seems more complex/messy. I think I'll remember my way in case I have a DBA interview (chance to see how little I know...

Dird (6/5/2013)

---

The problem with that is you'd have to create the table separately, when you...

Logic...

Try this:

declare @TestTab table ( -- Table variable to hold sample data

Id int, -- Not really sure what data type is being used but this works

...