Thanks, Greg, that was something I was looking for too!

Hello - I had the same need and found this great link that solved it for me

http://www.sqlnerd.com/ssis_dynamic_dates.htm

good luck -

Hello,

Thanks for your post. So - you have the file on the network share and a pointer in the database, but what mechanism in an application controls how the...

I have received the same message when trying to update a table with a trigger. You might check to see if there is an active trigger.

Thank you, J - that was very helpful and I really appreciate your time.

Kenena

Hello,

I am creating a stored procedure that will run 6 other stored procedures. Why do you say not to use the BEGIN/END. Also where does GO play a...

Thanks, David, for responding. I took a peek at that info and will review it further. What I was unable to figure out is how the application field...

Thanks very much, Todd, that gave me the insights I needed.

Kenena

Hi Todd,

Thanks for the reply, I appreciate your time. This is uncharted territory for me, is there any chance you could provide more details or direct me to good...

Hi - this thread is interesting to me, but it may not work as there is a typo with either

declare mycsr or the rest listed as myscr - so...

Thanks for your response, Rich -

My problem is that if a subquery is required to group the totals, I can't figure out where it goes or how to write it...

Thanks, Marcus - this is helpful to me, but I wasn't able to figure out how to limit the results to maybe tables with 0 rows or less than X....

Out of curiosity, could you tell me why you chose not to create a view?

Hello Matt -

It may be proprietary, but bottom line, it goes to the sequence table ID listed in the SP, gets the next value, adds one to the sequence table...

Thanks mrpolecat -

I had read that in BOL, but I had interpreted the -1 to mean there were no more rows left so as long as <> -1 it would...