You really shouldn't cross post. This looks like it has been posted in three separate forums.

Edit:

I suggest using the following forum: http://www.sqlservercentral.com/Forums/Topic516075-145-1.aspx

😎

Jeff Moden (6/12/2008)

---

Not sure the use of a correlated subquery (a form of hidden RBAR) will speed anything up here... Maybe...

The real fact of the matter is the OP...

I'm not making any judgements on the design. I was trying to point out that somethings that don't seem right could be based on other factors.

You could desgin a...

Not knowing the full details of the example it is difficult to make a judgement. One thing to remember is that while designing a database for a production application...

The answer to this is Yes and No. there are a few that I can talk to about almost anything, just as a friend. I actually consider these...

Here is my solution:

declare @TheDate datetime;

set @TheDate = '2008-08-15';

select

@TheDate,

dateadd(mm, datediff(mm,0,@TheDate) + 1, 0) -

...

Jeff, I will post my solution as soon as I get to work. My code is sitting there, but I'm still at home getting ready to leave. See...

At this point, since you figured it out, is when you'd post what you did to answer your own question. One reason, others may have a similiar question, but...

Matt,

I want to thank you for taking the time to format the test data pino_daddy provided. I just didn't have the time even though using UltraEdit would have made...

pino_daddy (6/11/2008)

---

Thank you very much.

I appreciate the response. I wish I had a copy of Quest Software, it seesm to help out sometimes by rewriting the query and trying it...

VALEK (6/11/2008)

---

Lynn Pettis (6/11/2008)

---

To paraphrase what someone else once said on this site, "The proof is in the code." Here is the code:

...

while @LoopCnt < 100

...

Based on the results,...

No. It means we have been doing our own work, or helping others whose problems/issues/questions were easily answered. I need additional time to look at your issue which...

Matt Miller (6/11/2008)

---

John Rowan (6/11/2008)

---

Also, your WHERE clause of PO.PODescription LIKE '%00000%' will normally produce a table scan. It's a bit hard to say for sure though as you...

Once a SQL 2000 databse has been restored or attached to SQL Server 2005, you can't go back to SQL Server 2000 with that database, unless you use DTS/SSIS to...

You are going to need a third party product to recover the data from the transaction log.

Then, you will need to setup a backup plan for regularly scheduled full, possibly...