Hey Jeffrey thanks for chiming in.

Let me clarify what’s happening. There is a delete query and an insert query wrapped in a Begin Commit/Rollback Tran. Some of the data is...

Jeffrey,

RCIS is set to 0. There are no additional query hints or anything being used within the two queries.

Steve,

No there are no query hints being used.

Hi Jeff,

Thanks for the reply.

It only deletes some of the data. Also, the query that isn't returning data only pulls from that subset that gets deleted.

Mike I hadn't seen your reply prior to my previous response but thank you, it was helpful.

I was able to join the sub-queries and that matched everything up perfectly. Everything...

ZZartin,

Thanks for the response! Yes that would apply to the query I posted but in reality I need to have about 5 sub elements for each PrintOrderNo (Compensation, Withholding, Attendance...

Mike,

Ahh yes I see what you're saying about all the rows being returned. When I included multiple print orders it's including detail for all of print orders and not its...

Okay I thought I tried that and it didn't work but apparently not!  Much appreciate!

Jeff I appreciate the suggestion! I was hoping it was that simple but it didn't work.

I'll have to ask other SQL and Snowflake users and see if they are experiencing...

Not sure if you got this figured out yet but it looks like the issue is your XML Task has a hardcoded SOURCE file. That needs to be a variable...

Damian it sounds like you are looking at tuning your TSQL which in turn affects the performance of your package but if you have other tasks in your package you'd...

You'll want to use the DATEPART function which is hugely valuable in sql.    Syntax would be "select datepart(wk,ColumnName)...".  Below is a link to the Microsoft reference for that function...

sqlsniffer it depends on what you want you to convert (datatype conversions or the data), how it's being converted, if you want to process records further (data cleansing/conditional logic/error handling)...

You're welcome and good luck!