Toolman,

Have you posted this script in the script library? I think this would be helpful to many people.

jay holovacs (11/19/2008)

---

That's part of the problem. With ATM and with online banking, the user is uniquely attached to the transaction, and the whole relationship can be backtracked and audited....

I actually think it is amazing that we cannot vote on-line. I pay all my bills on-line, I submit my tax return on-line, and can even do my taxes...

Unfortunately hiding objects in SSRS does not remove them when you are printing so you get the blank page.

If the lists are so similar couldn't you use conditional logic within...

Garadin (11/18/2008)

---

Glad we could help. One other word of caution. You are selecting the Top 1 in that update clause, but you aren't ordering by anything. This...

Your problem is in the bolded section.

UPDATE @EntityDateTimes

SET EventID=(SELECT TOP 1 EventID ...

Odds are with all my posts I'm not going to remember all the requirements based on the OP. Now that you mention it I do recall, but I still...

What is your source? Most products have a conversion like SQL Server's NULLIF or you can use CASE of IIF depending on the source to do at as part...

Check out CASE in BOL (Books On Line).

THe basic idea is you do something like this (Uses AdventureWorks2000 as it is what I have available at the moment):

[font="Courier New"]DECLARE @a...

I agree. Many times my posts include a quote from BOL that answers the question word for word. It does seem that people will post here without using...

I don't know if they are getting worse, just more basic. I think a lot of it is because so many third party apps use SQL Server Express or...

You would be looking for MERGE replication. Check it out in BOL. If you do go with merge replication you may be able to save some $'s by...

Can an Album belong to more than one Gallery? Can an image be in multiple albums?

For each YES you need a "glue" table, for each NO you can do...

Are you getting any errors when you are trying to connect remotely using a SQL Server login?

I don't know of any way to limit SQL Server logins basd on remote...

Can you check the security on the ReportServer virtual directory in IIS? I think I had this happen, but it was years ago, 2001-2002, and I don't recall what...