That looks like a nice work around Phil, thanks for the tip.

So, my interpretation is that there is no way to actually "Fail" the data flow, so the control flow...

Happy it helped,

and don't worry, we all have to start somewhere, just ask questions if you are not sure. But playing with the supplied code is always a good way...

Well, if that is the case, I will explain to you how you could implement it.

You said you wanted to count the number of occurences that had more than 2...

Have you even read the solutions we posted to your problem, before posting that data?

Both solutions will solve the problem you have actually with the float values. If you have...

gboyer (8/31/2009)

I am trying to find a count on all records in a table that have more the 2 numbers after the decimal point in an Amount Column. The field...

Look Up BOL.

You can't mark it as the answer here, but just saying it is enough.

Thanks for the feedback, and as Flo noted, I also propose you use table aliases, they are...

SparTodd (8/27/2009)

Even with my limited experience, I should be able to figure this out, but I'm stumped.

In SQL Server 2005 I have a DB2 Database on a linked server. ...

Well actually, since you are on SQL server 2000, the solution will not work, it would have implied you can use for xml path(''), and it appeared in sql 2005...

Really...

Look up "FOR XML" in BOL, it will help you concatenate those strings together, based on the TranID.

Hope that helps,

Oh wow! Thanks Lynn, all of a sudden, I thought they put new operators in sql server, again. Good to know they are only ol'aliases!

Happy to be quicker for the first time Bob, 😉

Good thing it's not a tally solution, because you would've beaten the...

Try this, it's what I always use, what it does is find the number of days since the start of datetime, (somewhere around 1900ish), and add that number of days...

I think the error says your SERVER is in single user mode, not the database.

Is it possible you started the service with the -M switch?

Happy it helps, and thanks a lot for the feedback.

Have a nice day,