For 50 rows, I'd use SSIS and copy the table each week and then do the upsert.

I would say that either will be the same. Depending on other queries you probably will want a non-clustered index on InvoiceNumber.

I also wonder about using the NOLOCK hint...

Have you tried repairing your client tools install?

I suggest you read up on Locking and Isolation Levels in SQL Server. Here is a link for the locking entry in BOL, http://msdn.microsoft.com/en-us/library/ms190615.aspx and here's one for Isolation...

Is the BILL_DATE column in the database a datetime/smalldatetime datatype or a char/varchar datatype?

You can also use Set DateFormat prior to the conversion. Like this:

Set DateFormat dmy;

DECLARE @d AS VARCHAR(50)

SET @d = '26/05/2009 15:15:15'

Select CONVERT(datetime, @d);

Go

The dateformat is part of the...

Well, in theory you should be able to find out because there are 4 vales for sent_status:

• unsent
• sent
• retrying
• failed

You should have an error for failed messages. It may take a bit...

What is the basis for the ranking? It doesn't look like it can be # of payments because the one you have with RANK 4 in your example has...

Yuri,

Database Mail uses Service Broker behind the scenes so basically sp_send_dbmail queues the messages and then Service Broker processes the messages. So as long as the mail item is...

It looks like Doug has provided you with a solution, I'd just change it to ANSI join syntax.

For future posts you should read the first article linked in my signature....

I haven't been as active on the forums, except this thread, lately because of vacation and catching up at work. I'm working in ASP.NET MVC and having to actually...

jcrawf02 (7/23/2009)

I was looking for a rotary dial phone a while ago as a nostalgia item, and couldn't find any. They have lots that *look* like rotary, but have push...

Don't have an ergonmoic mouse, but I have been using an ergonomic keyboard for 10 years. Love the keyboard and can't stand when I have to use someone else's...

Thanks for posting the answer you found.

Your permissions issues is due to the fact that the view is accessing a table outside the database. In 2000, cross-database ownership chaining was enabled by default, in 2005...