Interesting (and timely) topic for me! I relocated recently from Australia to Vancouver, Canada. I knew my market value in Australia, but when i started discussing salary with recruiters and...

i would quite happily give away databases to scuba dive full time, as long as i could earn the same money! i have enough other hobbies that i could escape...

we have a report spec document to complete for each report. The front cover has a change log which details the help desk ticket for the change, and a very...

Hi Navi's,

What version of Reporting services are you using? RS 2005 and earlier dont support this, but i believe 2008 offers rich formatting in text boxes...well, according to this it...

I was excited enough to get myself signed up for the Office CTP so i could try it out...and i am less than impressed. We were hoping that Excel 2010...

Bugger! Not the answer i was hoping for, but i guess it was the one that i expected! Am suprised MS doesnt offer a concatenate function in either SQL Server...

Cool! will be great to see what 2005 can do! Sounds like there is gonna be lots of new and useful commands...which will be good, but even more to learn!

Heya,

SQL server has the built in function StDev for calculating the sdtd deviation (in BOL there is also StDevp...it uses the biased population formula- not sure which is more appropriate!):

SELECT...

You might also want to consider turning on Cascade Updates and Deletes for the relationship between tables (if this is appropriate for your data that is!)

This would automatically delete the...

Thanks again Kenneth...the asset table does not have any child tables, and the reason for the update is to introduce a new asset type 'Home' for all home owners (as...

Thanks for the help guys...yu were right on the mark with the suggested code I didnt know i could do a join like that!!

I...