No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than … |
|
Since there is no system function for calculating the median value in a data set I was going to make a function to do the trick. I would like this function to be available to me in all my databases without having to redefine it for each. Is there a … |
|
Re:
Hi, I was wondering if it is possible to update one table with another tables values depending on a where condition, such as a insert into or using a join as a subquery. I have successfully got a windows application to do what I want it to do but it … |