rounding inside the sum can lead to some varying results;

look at this based on your sample data...the rounding to money is quite a bit different.

/*4470487.674470487.76384470487.66999997*/

select SUM(convert(decimal(10,2),number,2)),

SUM(convert(money,number,2)),

sum(round(number,2))

from #temp

I had a requirement like that, and I generated the reports separately,and then used pdfmergerSB545.jar to join multiple PDF's together; in that way, i was able to get some reports...

nathan 7372 (3/23/2012)

---

Hello All,

I'm experiencing some unexpected behavior using rounds and sums on a floating point column. This is my query.

SELECT

sum(round([Refund],2))

FROM [MyDatabase].[TotalRefunds]

The...

the spaces in the file names makes it hard to do also;

i tried splitting the data on the slahses, and i'm not getting all teh possible results so far.

with mySampleData(id,val)

AS

(

SELECT...

if that inner function...

i found some interesting stuff about service queues not having a unique GUID over here:

http://stackoverflow.com/questions/1127404/service-broker-with-sql-server-2005-messages-stuck-in-queue

I know i've had a situation a couple of times where the service just doesn't seem...

I believe you are incorrect; the default state would be INACTIVE unless you query the queue at teh exact moment you are actually sending an email.

all four of my servers...

there's a very complete, once again free Canadian postal database here:

http://www.populardata.com/downloads.html

here's a free copy of mine; it's the CREATE TABLE and INSERT INTO statements i've psoted here on SSC a few times.

it is based on a formatted version of this...

well, you can sue CTE's instead of temp tables, but i'm not sure how much simpler that is..it is the same query, different format.

DECLARE @KeyDoc int;

WITH freesiteaccess

AS

(

SELECT DISTINCT x0_0.keydoc,...

awesome linky Patrick, thank you! 😀

Fear Naught (3/23/2012)

---

This is an interesting point. I, as a relative beginner of SQL Server and self taught, was under the illusion that a trigger fired for each row...

rpnew (3/22/2012)

---

I have a requirement to store the address for an object in two separate tables -- one for State and one for City. There should also be a parent,...

take a look at this example;

what you are asking is possible by getting the data using XML;

Select Row_Number() Over(Order By is_linked, name) % 2 As [TRRow],

...

i would agree; an error in the trigger could prevent data from being inserted;

cross-database data migration does not belong in a trigger.

an outside process could error out, but the next...