If you always need to filter against CONTAINS(BL_TBL_TOC.TEXT, '"test*"') it might be an option to add an indexed computed persisted column that would set a flag depending on the condition...

There's one thing I wonder about: the "Test Pass guarantee" (https://partner.microsoft.com/40161629).

I usually question any source that'll guarantee someone will pass a test without knowing anything about that person at all....

Here's my first approach. The result is a list of dates per hotel in the given date range with already known values.

While coding this solution I came across a question...

SQL Kiwi (1/13/2012)

---

LutzM (1/13/2012)

---

The main reason some of us go beyond a "it works in the context" solution is because there are people out there who -unlike your great attitude-...

The way I read "reputation" on this site:

If there's an answer given a few minutes/hours ago where I think there's something wrong with it, I start to research. That sometimes...

I have more questions than answers:

Why aren't the data for Jan 14 declared as "missing" for both hotels?

Why does it start on a Sunday (Jan 1st) -assuming we're talking about...

brendan woulfe (1/13/2012)

---

Lutz - will doing that break the xml structure at all? I had a requirement to add the encoding header to an xml file and I did...

There are several solutions:

a) SSMS (SQL Server Management Studio) , option "Results to File"

b) bcp (either started from...

To include the encoding, you'll need to change it to a varchar() data type. Otherwise SQL Server will internally use the encoding information but won't display it as part of...

nick-1043370 (1/12/2012)

---

Wow, lots of discussion on the whys and wherefores here guys. Nice to have the big guns discussing the optimal solution to my question! 🙂

Got to say though, the...

I'm not sure if this would return the same result as your original query (or even run at all in the first place) since I have nothing to test against...

Just change the file extension to .xls and tab as value for @query_result_separator

I'm not sure if this question should also be on the list: What is the pay range for the DBAs and admins (in relation to the regoin the service is...

If questions...

@craig-2: Answer A has an ORDER BY but invalid syntax.

The problem in general from my point of view:

There's a company looking for someone with decent SQL skills since they obviously...