Try using different character for the quote: the one to the left to 1(!) key on the keyboard , right above the TAB key: `

Vadim.

I would recommend to start by setting up an index on ClaimType on both tables.  Depending on the data you get it could be clustered index.  Having said that, if...

Here is what we do:

We created Excel file with all the formatting they want.  That workbook has hidden worksheets that have no formatting.  DTS overrides the hidden worksheets on every run...

I've read the article IT Unions and it shows luck of understanding economics.  Unfortunately, it cannot be "explained" in a nice soundbite, it has to be learned and comprehended.  I...

I have a laptop (Inspiron 8500) and a desktop (Dimension 4700).  First thing I did when received the laptop was to repartition HD and completely reinstall OS (XP Pro SP1). ...

hello daomings,

I'm using int column to store date part using following:

SET @event_date = DATEDIFF(dd, 0, getdate())

when I'm retrieving it (through stored proc) I convert it back:

CONVERT(varchar(20), cast(@event_date as...