I agree, Mark - I answered the same, we should get credit for a correct answer...

You're welcome

I'm finding synonyms to be very useful, as well as many of the new features in 2005....

Good luck

One possible solution would be to create a Synonym in your 2005 db pointing to the 2000 db - that way you'd only have to maintain the definition of the...

Infinite click throughs are a feature in Reporting Services Report Builder, which allow a user to click on fields in a report, and drill down to details. E.g. if you...

Further to David's response:

1. On the Report Menu (in Layout veiw) choose Report Properties

2. Select the Code Tab and create a function, e.g.:

Function DivideMe (ByVal quotient As Double, ByVal...

I never installed a hotfix, but did install the web download "SQL Server DTS Designer Components" and it worked perfectly.

This may have been before the hotfix you mentioned. Did you...

I've never seen any licensing process in any of the installations I've done. You just buy the licensing model you need - then install the product.....

I disagree with the statement "SQL 2005 is somewhat stable, but extremely bug infested ", I've found it to be very stable, and much more robust than 2000.....

Thanks very much for your kind assistance.

In the interim, I wrote it like this:

UPDATE @tblvarClose

  SET Close0PctCnt = v.qCnt,

  Close0PctGP = v.GP, Close0PctGPpct = v.margin 

 >>Do yourself a favor... format your SQL code so that it's easier to read.  You wouldn't write VB or C in such a hap-hazard fashion.<<

How would you write it?

Thanks very much for your reply. I had to reboot that system for some updates, and after that, it worked fine.

One of life's mysteries, I guess....

Very helpful article. I may have missed this in the thread, but I'm wondering if there's a way to get the workstation id from within an MS Access app?

Thanks

Thanks very much, this approach does the trick. As far as I can see, that aspect of returning output to a variable from sp_executesql is not documented in BOL...

I found...

Thanks very much for your reply.

What I'm trying to do is pass a sql string from an app to a stored procedure, and get a return value. I'm doing this...