Give this a try: select dateadd(mm, datediff(mm, 0, getdate()), -1)

Now that you eliminated the cross join, and the fact that you want all the records from the source table, it should work. Have you run it in a...

Could you provide the DDL for the tables and some sample data? It can be abbreviated to those columns you need and required for joining the tables together. ...

select

*

from

TableA ta

inner join TableB tb

on (ta.Col1 = tb.Col1

...

nscott (6/30/2009)

---

Thanks for the info! We've started a regular tlog backup routine and the timeout issue seems to be resolved. However, now I have an issue with the...

Could be. Problem is, we haven't seen your code.

Take a look at the code attached. I tried posting it in this thread, but once again I seem to be having issues again.

jcrawf02 (6/30/2009)

---

Paul White (6/30/2009)

---

When I first read that, it sounded...

Good Night Paul! 😉

Well, thank you for the link, but it really isn't the same as showing us your actual code.

Paul White (6/30/2009)

---

Good post. Just...

Paul White (6/30/2009)

---

Lynn Pettis (6/29/2009)

---

Jeff Moden (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

And that will work until the SQL Server 2000 system table "views", like sys.syscolumns, go away in a future version od SQL...

Paul White (6/30/2009)

---

Lynn Pettis (6/30/2009)

---

I want to thank you all for looking. I personally haven't run into this kind of issue on any of the servers I have managed...

Slight problem with the code you provided. The table, tblGRINMaster, doesn't exist in the post. To really try and help, we need this table along with some...

GilaMonster (6/30/2009)

---

Lynn Pettis (6/30/2009)

---

GilaMonster (6/30/2009)

---

No offence intended to anyone, but I've butted heads with someone in that thread a couple of times. Most recently on a corruption question where he...