Heh... I don't know much about JSON but that's pretty counter intuitive of the language.

Also, I don't know why people are giving this question a low rating.  It seems straight...

OK... Let's start off by asking a couple of questions...

Do you agree that a course can have more than one instructor and that a popular course can be taught many...

You're the one doing the design.  The reason why it seems like hazing is because we're commenting on several aspects...

I believe you missed...

Is it the only thing you found there which deserve unconditional love?

You know, at some stage I stopped...

I am in a project where information is being pulled from a database then put into a web page in a manner similar to a report. In this database...

A couple of weeks ago, we had yet another O365 outage and it looked like it affected a lot of people across the globe.  This is getting a wee bit...

I remember reading the thread you spoke of and the great job you did in helping the OP figure things out.  Nicely done.  And nice followup article.

Go to youtube and search for "database design course normalization" for starters.

>>But you display only vague dates not associated with any year. I'm going to make a suggestion that you use the MySQL convention four months. It is based on...

I want to know what are the customers having missing month data based on the following data pattern. My data is present in table in below format. Please help...

Why do you think you need the locking hints at all?

Like Paul White said in the thread referenced by Brian...

As documented in Books Online, UPDLOCK takes update locks and holds...

People don't understand that a CTE is NOT executed first and then the rest of the query works against that as if it were a table with the possible exception...

@jeff - Server is optional - if not supplied it run on the local machine where bcp is executed and connects to its default instance.

But doing this is...

Heh... some would say that you got "Lucky", Lynn.  I would say that it's where years of preparation and hard work have finally met a good  opportunity (my definition of...