I want to set the record straight. I just read Mohit Gupta's piece on normalizing a not normalized table (Nov 10, '08). I accidently rated it with one...

Your hint worked. I won't go any further with this since I can now proceed. However, I did try select * from sys.database_principals yesterday. Query worked but...

Andrew:

Thanks for your comments.

Essentially John Rowan straightened me out a couple of days ago when he pointed out that there is a separate login for a server and once there,...

Gail and Steve:

Thanks for your responses. I do appreciate the advice.

The effort to become a dba is happening late to me. I’ve been busy designing and...

I'll reply to both John and Alvin here. Thanks both for the help/questions/suggestions. Once I read from John that a separate login is required for the sql...

Thank you John.

I understand what you just wrote. I also accept it and will proceed with the idea that there must be at least one login per user, to...

My advice to you is to find a job as an application programmer. Learn to write good code in whatever language is required. Learn to be exacting and...

Jack:

Thanks so much for the help. I won't make that nchar to int mistake again. (The learning process is sooo drawn out in the beginning.) I've printed...

Steve: Thank you so much for responding. I had hoped to avoid posting a lot of code but I can see I did not fully present the complete...

Jonathon: Very glad to finally get some help on this. I set the book aside and am in the MCTS Training Kit. The kit kind of sidesteps CLR...

Got it: G**2. Your suggestion works. Thanks.

Victor Victor

Oops. The Where clause I added to both select statements was one to guarantee that every record in the table would be processed. That is: WHERE...

I took GSquared's suggestion and added a WHERE clause to both select statements. Get exactly the same result as before -- All 93 records returned contain 'Honcho' and none...

BTW. Thanks for your reply. A bit more on my confusion about what you get from a select statement. I assumed that the select statement without a where clause...

Aha! I understand your answer. However, I do want the logic to apply to all the records in the table and that is why I did not put...