FYI, the third one errors out:

Select 'XXX' + 'YYY'

Select 'XXX' + + 'YYY'

Select 'XXX' + - 'YYY'

So with the first two, the + sign is doing concatenation, not math. ...

Vik -

In my experience the success of a data warehouse project for reporting purposes is greatly improved if the client can provide access to what I think of as a "super...

Try dividing your billed amount by the number of procedure records...

Select   t1.AccountNumber

                , t1.originalBilledAmount / t3.ProcRecords As AdjBilledAmt

                , tbl_PerformedProcedure.PatientPrimaryKey

                , PhysicianID

                , t2.cptcode

From  tbl_BillingMaster t1

Inner Join tbl_PerformedProcedure t2

  On  t1.PatientPrimaryKey = t2.PatientPrimaryKey

Inner...

I tried the following using two tables each of which have a non-clustered index on the date field.  I was suprised to see that the estimated cost for the first query (using Antares686's...

Thanks for clearing this up for me - a good learning experience.

regards

k2

Interesting discussion. I’ve got a little different perspective…

My wife has a two year nursing degree, and had two executive level positions with large health care institutions. In each...

Try here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_21rn.asp

Or you can search around here:

http://www.sqldts.com/

regards

k2

If you need to you can create DTS packages with VBA and run them from your app. Saving your package as a visual basic file will give you all...

I remember having this problem too - particularly when using dates. My guess at that time was that "knowing" the date value allowed the query optimizer to do something...

Can someone point me to a good reference describing (dumbed down) bitwise operators such as ^ and giving examples of their use?

thanks

k2

Thanks, noeld, I'll talk to my DBA about linking to the Access database - and thanks for pointing out "sp_MSforeachTable" - very cool!

regards

k2

Thanks for your reply, JR. I've tried using the default "Admin" login with a blank password, as well as leaving both blank. No luck.

Unfortunately the Access...

Science fiction readers will remember TANSTAAFL - "There ain't no such thing as a free lunch".

k2

As an aside, I just discovered a cool function yesterday that could be useful in queries that look at day of week: the DateName function. Rather than use...

One approach may be to find out what the other vendor (for your bosses app) says about having to share a server with SQL Server?

k2