Thanks all for the replies and I will look into C2 logging...sa is used for our Financial ERP so I cannot disable this. I doubt the person knows what...

Andy,

I am curious as to what you would say to this:

Our ERP vendor doesn't have any primary keys on trans_tables (journal load transaction transfer tables) thus eliminating the possibility of...

Oh how I agree, the error is indicating you do not have a connection to the package. In your package in Visual Studio do you have an instance for...

Thanks I will look at both.....

Hi Jason,

Again thanks for the help...

The script I copied does work, I read up on the OVER clause and not sure how to incorporate it.

Project Component CE ...

Hi Jason,

This is what I want to accomplish if you can streamline it as I always over complicate my T-SQL...

/* Retrieve all data for component 8933 */

SELECT

a.project_id AS...

Ian,

Read and answer Michael's response need to confirm what you are trying to accomplish on the SET =

Fun huh?

Just trying to troubleshoot how about UNION

Split the query into two seperate queries from the two tables then UNION them to merge the results...

If you take your original query and replace CROSS JOIN with INNER JOIN and ON ....

What is the output?

Max,

Not use the CROSS JOIN ...by definition CROSS JOIN will do the following:

Cross joins return all rows from the left table. Each row from the left table is combined with...

I would be careful with switching recovery modes. It is not really as simple (no pun intended) to go from Full to Simple.

A database is set to...

I have gotten this before. This has happened when my SQL Server 2005 was on SP2 but the SQL Management Studio and its related tools was not.

Once I applied...

Ian,

Doing a quick scan not sure if this will help but your date parameters for your BETWEEN are not in quotes

Jeff

More info..the more I look at this..the more I just don't want to do it! 😉

Let me try this again

One table has this:

01001 9696 76011 $50.00

Table two has this:

76011 01001...

Thanks for the quick response. Attached is the report that is stemmed off the query. Hopefully this will give a clearer picture.

With the example shown. 01023 8933...