@meichner,

Don't you love it when a boss does not know anything about something but they insist in using the authoritative leadership style.

Look at the bright side, at least it appears...

This does not address your problem but just something to consider.

I would change ID to FruitID so that it is the same and easier for to recognize as being related.

I...

http://msdn.microsoft.com/en-us/library/ms187455(v=sql.90).aspx

http://www.geekinterview.com/question_details/68355

Please don't take offense but it would be easier on the eyes, shorten the length of your statement and make it easier to identify an issues by using Table Aliases.

SELECT...

For Server Performance I had an Audit Checklist which I used as a aid in identifying performance bottlenecks. I was very methodical.

Unfortunately I have not bee able to locate it...

If the Workbook already open?

Does the Account trying to Access it have Share and NTFS Permissions.

Could be a Firewall Issue.

Check out the article for it may have some items that...

It is rare that some ask what is your objective.

Why are you trying to do this this way?

What do you want your table structure to look like?

I have seen...

Is this a Select Statement manipulation or do we need a physical Store?

It depends on the requirement and what objective you are trying to accomplish.'

I tend to store information in...

mattech06 (9/10/2011)

---

The script will be run daily and the output 'table' is sent to a web server.

I'm actually using sqllite with php for the script but the client's database...

I can appreciate what you want to do in this situation but what is the long term plan.

If you could include your business requirements then you would probably get better...

I tend to do go with Physical Columns and I would script out the entire table so that you have the indexes, etc.

After Scripting the Tabe Out ALTER it to...

In addition to Native Backup for Databases, I have only used LightSpeed.

I would take a look a Redgate's Product because LigthSpeed is so expensive.

Is this going to b a one shot deal or will it be ongoing, i.e a user enters a record you get this behavior?

What are some of the more common techniques that you use when you performance tune?

mattech06 (9/10/2011)

---

Now within the statement I wish to create another column and check the phnTypeID. If it is 5 then put phnNum into the [phnNum] column and an...