That last post makes me think of indexes. Since you changed the code to make things simpler and the database isn't maintained, check to see if the procedure is...

If nothing changed, then it wouldn't be taking 6 times as long to run. Therefore, something must have changed. It might not be the data in the tables,...

I compared the tools from Idera, Red Gate and SQL Sentry. I found that SQL Sentry gave me:

- An executable client, eliminating the need for a web server

- A...

INSERT INTO MasterList(ComputerName, AuditID, IAV, [Date])

SELECT ComputerName, AuditID, IAV, [Date]

FROM Temp t

WHERE NOT EXISTS (SELECT 1

...

I know what you mean. I don't know what your requirements are, but if you know the users can search by the first two (and only two) characters of...

Just as a word of caution here, if you put your DECRYPTBYKEY and CONVERT functions to the left of the operator, they'll both have to run on every row in...

I was asking if you wanted to create a master customer list. Without one, if John Smith takes a trip to Italy and then takes a trip to Spain,...

I'm not sure what your requirements are, but here's a suggestion. If it isn't applicable to what you're trying to do, simply ignore it.

If you can have one trip...

Thank you, Gail. I just learned something good that I will use often.

The subtle but significant differences make all the difference in the world.

If your field is a datetime data type, then you're comparing the datetime result of GetDate() against the datetime value of the field. So, nothing's going to match. ...

Wow! That's quite a set of REPLACEs. If I'm reading what you want correctly, I see two different approaches you can take here.

The first is using the STUFF...

I'm glad to see you're not going to copy and paste from Excel. I've found that when doing this, data isn't pasted it as it should be, so I...

I don't know if you care, but database mail sends outgoing mail only. The recipients need to understand that if they try to reply, it won't be deliverable unless...

If you're thinking of a Word Mail Merge, I don't know of a way you can do that exactly. SQL does have outgoing mail functionality by way if the...

Agreed. Not everyone is obsessed with ISO standards.