There are some procs for working with XML. likely to want to load the XML into a variable, then have 3 queries for your specific variables that parse out the...

There might be better ways, but I think Phil's solution looks good. Easy to enhance as well.

I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that...

Some hotels might have both, as descriptions sometimes change, but for purposes of infrastructure (electrical, plumbing, etc.)  they often serialize or ID things. However, if there's only one, often it's...

I think a big part of the problem is management and not holding people accountable. However, there is also personal responsibility and professionalism, which can be lacking.

Lol, I love Sean's response, and sorry that things have gotten you upset, Sean.

Too many developers are like this, but lots aren't. As I move about between customers and clients,...

You do get points for replying to your post, meaning that you are still engaging in the discussion with others. If we were talking 100 vs 120 points, this does...

This isn't tracked, nor is it something I think you should care about. If the index is not performing, and you need to update, most of the time this is...

Nice to hear. I think taking care of people locally is important. I'll have two chances today, as two different events out later with friends. We're buying froyo for the...

Having been to Las Vegas in the last few years, not sure a Tinyint...

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know...

I have to say, in this case I would use a char/varchar column for room numbers, not an int.  Even if the hotel guest rooms are all numeric, sometimes...

Cheers. Make sure you understand how this works. If you have questions, please feel free to ask.

Also, using these built-in roles isn't a problem, if the users need to see data in all tables. If they should be limited to some tables, then create a database...

Apologies, I didn't realize where your problem was. That's why showing results and desired results is helpful.

If you want the dbname in the table, you need to insert it. What...