Instead of waiting for confirmation, here is the code I was working with:

create table #TestTab (

id int,

totvisits int,

score...

garypete (9/22/2008)

---

Thanks for the post, I had two objectives here from the large data collection.

One was multiple visits (gt 2) and the other was to have a score above 4.

I...

Your logic eludes me. I can't figure out what you are asking for, let alone figure out how your logic provides you with the result set you get from...

Two possibilities. One, no one else has run into this particular problem. Two, no one is using Excel 2007 yet.

Give it some time, someone may actually have a...

While running in debug mode, have you put a data viewer on the data flow into the lookup to see what data is there? If not, this would be...

How often are you running the Transaction Log backups in your maintenance plan? Based on the size of the database and t-log, it doesn't look like your are running...

No, the file connection will not create the directory if it does not exist. You do that in a File System Task using the create directory operation. This...

Unfortunately, we can't really help you with just the info provided. Please take the time to read this article http://www.sqlservercentral.com/articles/Best+Practices/61537/.

If you follow its advice, and post additional information regarding...

Can't answer your question without seeing the query.

😎

John N (9/19/2008)

---

trying to add and "IF at the end of a select query, can you help with the syntax

example

SELECT id1, id2, id3 FROM table

IF x =...

You'd get better assistance if you follow the advice in the following article:

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

😎

Sometimes, I think people think too hard with some of the questions.

😎

I will throw out my 2 cents. I'd be wary, very wary. Best thing you can do is get your vendor and Microsoft on the phone together and...

Unfortunately, the build numbers do not distinguish the different editions of SQL Server.

😎

What recovery model are you using on the database, and do you have a current backup (and if approriate, transaction log backups) from prior to the accidental delete?

😎