Excellent. Thank you!

Can i use this with INSERT INTO?

Well, the issue was my declaration of @i_col_lst nvarchar(100) was too small. Dummy!

Okay, my initial query was incorrect. Here is the actual query and the incorrect CAST results:

select distinct

CONVERT(VARCHAR(100), h.HRCHY_ID, 1) fConvert,

CAST(h.HRCHY_ID AS VARCHAR(100))...

This is correct and I have modified my code to adhere to the new join syntax. Thank you!

David

Okay, the sp is not working. Here is the entire sp:

The code in bold is not working. The @v_pkStr variable is always NULL.

ALTER PROCEDURE [esell].[SP_VERIFY_DFT_COLUMNS]

...

Does anyone know of any issues if tempdb and your user db's collations don't match?

This is helpful. Thank you for the input.

Okay, that sounds like a good option. would you have any .cmd/SQL script examples that would demonstrate how this could be accomplished. Thank you.

I have used some code from your referenced articles. Below is the code I have so far.

DECLARE

@Parameter VARCHAR(8000),

@tabName VARCHAR(100),

...

Yes, that works! Thank you for your input!

I now have this working :-). What I did was use the BCP command to create the correct BCP format file. Here is the command that I used:

bcp...

Gail, thank you for the query. I am viewing performance monitor right now and it is very helpful!

Gail, I know I can use performance monitor but can't you determine this with a query in SS? I am more of an Oracle DBA and you sure can...

The queries and indexes are optimized. They are only returning in some cases 3 rows. Would you have any scripts to cache the buffer cache hit ratio? ...