You'd be better off posting your procedure so someone can take a look at it...

Here're several suggestions to debug:

1) You can use t-sql debugger - if you've never used one,...

Homebrew01 - you're not reading carefully enough - there's NO backup...

I store the scripts of all my database objects (as well as their versions)...

That's strange - I've changed mine at least once and have edited other parts of my profile from time to time with no problems - are you doing your editing...

Sharul - you need a left outer join for this since you want all IDs present in your Student table....

select a.ID, a.Name, count(b.BookName) as NumOfBooks
from student a
left outer join
BorrowBook...

Yelena - In India I grew up seeing people go through this ritual called "Surya Namaskar" which literally means "Sun Salutation" - people would wake up at the crack of...

Being a staunch aficionado of this site, I understand exactly what Annette means! You hold something in high esteem - your expectations of the standards are raised proportionately! "Content" and...

"I am trying to figure out why another poster thinks that 20+ years of basic netiquette, 30+ years of RDBMS practices, and 40+ years of ANSI and ISO Standards somehow...

You may also want to read Erland Sommarskog's (really comprehensive) article on lists & arrays that specifically addresses this!!!

PJones - just to let you know that I asked you a question and got it answered on Yahoo just now...here're snippets...

About 19,000...

"Do I detect a (trivial and inapplicable) version of Wittgenstein's so-called private language argument in Joe Celko's post?"...

Not to do Mr.JC a disservice or anything by implying that he didn't...

thoughts and musings...

There's summer and then there's summer...Anchorage is reputed to have almost 24 hours

of daylight today...whereas if you go far south enough...you'd get equal hours of darkness..and then...

Gosh - it makes me queasy just reading about such impossible designs and tasks..

how are new faculty ids added or deleted from the TR_TRGCAL...

suggestions - try using space(1) or char(32) and see if that works!

sounds like this is heading the way of the discussed-to-death version control..

Here's a link to a series of articles by Steve on this...

"oh yeah...Life goes on..."...

Rudy - not that I want to shake that restored faith or anything....but are you saying that it'll be a "seamless"...