well, I'll confess what the problem was. I hadn't specified the schema names, which in this case was important. ie.Tables belonged to different schemas.

Thank you for steering me in...

Lynn, how does 'where does the data come from' impact the join? The column names are different, the data types could be different, and the data is there. ...

Lynn, thanks for replying. I think you meant 'the code looks good'. Yes, and it seems very straight forward yet it's not working. Other than the composite PKs...

Thank you, Kingston.

I looked up the answer to my own question here: http://www.sommarskog.se/share_data.html#inlineUDF

Coolness. Thanks for sharing your script. One thing you'll need to do is make sure that the column...

Cool, I looked at the script. I like it and may use it.

Does that INSERT statement really work, without using the 'VALUES' clause, ie. INSERT INTO <tablename> <return set...

opc.three.

First, I want to thank you for understanding my specific problem and helping me specifically. This helps me exceedingly and I will apply it in more situations. I...

opc.three.

Yes, I see what that does, so I inserted a print @sqlXX in before every exec @sqlXX. The print command prints what gets executed for each iteration of the cursor's...

opc.three.

I haven't found the proper place to insert the BEGIN TRY...BEGIN TRAN/ COMMITT TRAN...END TRY clauses. I have taken my first chunk of consequetive dynamic sql code betweeen them,...

I have read BOL and can see how to place begin/try around regular select statements, but not around dynamic sql statements. Would you mind giving me a suggestion about placement,...

OK, I will be googling transaction erroring and begin/try and cracking the whip on myself tonight, to get a handle on this. Thank you for taking my question and helping...

I would say the subject is 'nearly' as broad as the topic of life. You have to dive in. There is no one book for example and the one...

Let's say a view is created using "select *" and with no where clause. Is this utterly useless as well as automatically 'updatable'?

I believe I know the answer is that renaming a column will not disrupt the view as long as the column is appropirately referenced from within the view, but just...

I have used this query (taken from Dave Pinal http://blog.sqlauthority.com/2009/01/13/sql-server-find-row-count-in-table-find-largest-table-in-database-t-sql/ ) to get a rowcount for every table in the database.

USE <databasename>

GO

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count

FROM sys.dm_db_partition_stats st

WHERE...