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...

An example of what? It isn't even a valid query. We'd like to help you, but you have to...

Questions.

Is the database using the Full Recovery Model?

Do you have a current full backup from prior to this event?

If so, you can take a transaction log backup now, restore the...

I'd write it more like this:

DELETE FROM

dbo.tbItem

FROM

dbo.tbItem I

INNER JOIN dbo.tbProductionOrder PO

...

Sorry to say this, but this doesn't even appear to be a proprerly written query.

select * from test.samp_id,test.b_id,

case when (test.case_active='N' and sample.case_te_date is null)

then 'In Active' when (not tbl_test.case_te_date...

Matt,

Here is a link to Wikipedia that may help jog your memory on thier use:

http://en.wikipedia.org/wiki/Fast_Fourier_transform

Can I personally think of a database application that would use it, not off hand, but...

Big request with no information to work with. For better help fast, read the following article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

Just so you know; I have found an algorithm that works, and based on my testing, will work no matter the setting of DATEFIRST.

(That is a hint, and goes with...

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

set nocount on;

create table #fun(id int identity(1,1) primary key clustered,...

One query is returning a constant, the other a value from a table.

Where is the simularity between the queries?

Give it up. Neither of us is going to change the...

Not even similiar. Let me know when you decide to give up trying to convince me otherwise.

😎

Now, you should post what you did to complete your process so that others can see it also. You never know, someone else may have a similiar problem that...