Do you mean in table edit/view mode? You can open the table in design view and set the format to mm/dd/yyyy. Or in a form or report (in which case...

I assume your description was of a physical server rather than a VM? 4-socket/2-core: Old Xeons or Opterons?

I believe you'll only get to use 2 cores -- SQL Server Express...

Just execute the second query after the first within your try block.

If the first statement succeeds, the second statement will execute.

If the first statement fails, it will jump to the...

If you are using the GUI, in the advanced tab, see the "On failure action" dropdown. In addition to the more common "Quit the job reporting failure" or "Quit the job...

StatusId is in dbo.Revision, so I think you'd need to adjust slightly to something like the following

DECLARE DocsToExport CURSOR LOCAL FAST_FORWARD FORWARD_ONLY FOR
SELECT RevisionAttachmentItem.DisplayFileName
   ...

Do the clients fully understand the risk of lost data and uptime in testing on the live system? Would a test on duplicate environments suffice. Variables (IP addresses, server names,...

Any time you do a comparison such as =, <>, or LIKE in a where clause (or inner join), you are implicitly excluding rows where that column is null, since...

You indicated BillingRateB was blank, but in the picture it is BillingTypeB that is blank -- Rate (which is either BillingRateA or BillingRateB) is always populated. But there are...

So the count returned is right.

Can you provide one or more sample source rows and corresponding output rows (obfuscated as appropriate) where the problem lies?

Since you are aliasing BillingRateA as 'Rate' and BillingRateB as 'Rate', are you saying that you are seeing a populated Rate column when you run just the bottom half, but...

A primary key is really just a unique index (clustered or not, depending on how it was created). Microsoft has wrapped it w/ some logic that syntactically implements it as...

Short of writing your own dtsx processor, there is no way to run dtsx packages without SSIS. dtexec is the executable that parses & implements the logic in dtsx...

No. If you really need/want to convert the unique index to a primary key, you will have to drop the index and create the primary key - I don't believe...

You have a very good vendor.

How to post code problems

• People trying to help you are donating their time. Providing scripts to create tables, views, procedures, etc. and populate data saves them time in...