Hi hunchback,

That did the trick, thank you!!

Thank you for your reply. I took a look at this article and, while useful for certain situations, I don't understand how it would apply to mine.

I need to...

Thank you all for helping. The simple and direct answers gave me options for the solution. Thanks again!

For this,

SELECT retailer_name, blood_type, blood_price,

COUNT(*) OVER (PARTITION BY retailer_name)

AS inventory_cnt

FROM Vampire_Retailers AS VR

WHERE blood_type = 'B';

Wouldn't you instead get nameA, 'B', 2.75, 1 and not nameA,...

Thank you so much!

Thank you. This explains it: 1.79E+308 is 1.79*10^(308)

I wasn't aware of that. Sorry, I'm not a math guy 🙂

Thank you again.

The calc is not the question. 1.79E+308 is. I don't know what 1.79E+308 is or how to interpret it.

Thanks, Cadavre, for your response.

I'm not sure what 1.79E+308 represents or means. Which one of the two exceeded this value (and how)?

To answer your question, there are large sums...

Thanks, all, for the responses. I am going to try the OnInformation event as suggested. I cannot try the exit code approach, since I believe that will be...

Hi,

Feedtype is a string. pNeedPorSessions is an INT32. Both are in the same (main) scope. I tried using this expression in pNeedPorSessions.

I take that back - it does work. I wasn't seeing it correctly in the locals window. It hits on the Post Execute Event.

Thank you both...

Thank you Jack and Koen for your responses. Sorry for my delay in getting back to you, but I am only able to work on this on weekends. ...

I was able to find it - when right clicking on an object within a container to add precedence constraint, it is not an option (only the container itself is)....

Thank you both Ron and SSC-Enthusiastic. I see it now.

I was able to filter down further by modifying to:

WHEN NOT MATCHED BY SOURCE AND T.AsOfDate = @Date...

Thank you for the articles. I've read them, and the one thing I am wondering is...are try/catch constructs best used for when only doing DML? I have been...