If you want to be able to impersonate it, you're going to need to create Logins (and now you have a new problem). If you just want different schemas to...

SQL is probably the wrong tool for this. Not only do you need to unzip the data, but you then need to navigate the internal file structure, extract the relevant...

Rather than a trigger, you could add a calculated column to handle the replace and convert the result to an actual date at the same time, e.g.

Drop...

Sometimes I find it helps to add something like:

[ClvInc].[Tx].query('.')

to the selected column list. It will output the XML your nodes() function has taken you to and can help diagnose if...

• This reply was modified 5 years, 6 months ago by  andycadley.

If you want a quick "on disk" variant, you can take advantage of the fact your date stamps are sortable, i.e.

Select SubDirectory from #DirTree

Except

Select SubDirectory From

(Select Top (4) SubDirectory From...

You can also do an upsert using merge:

merge #data as target
using (select @username) as source(username)
on target.username = source.username
when matched then update set visits = visits + 1
when...

Percentile_Cont or Percentile_Disc (depending upon which type you want) would probably be the way to go.

@Job_Numbers is a single string of text, using NOT IN on it will not break it apart at commas - it's equivalent to writing:

WHERE ModelName0 <> @Job_numbers

I suspect you really...

We have SA so licensing costs aren't the biggest issue - though the constantly shifting charging model, particularly on virtual hardware, makes doing thing like upgrading cores unnecessarily painful (you...

We had this conversation just after 2017 was released, to replace our aged 2005 servers, and I pushed hard (and won) the decision to go with that over 2016. With...

Lots of things that aren't valid XML are allowed within CDATA sections, that's kind of the point of CDATA. So by wrapping it in that, you're basically not really converting...

The usual methods for getting around escaped quoting are things like:
1) Second-order SQL injection. When the passed in string gets passed through multiple layers and the inner code isn't...

Yes, converting either of them to an iTVF will almost certainly be vastly better than using a scalar function. As to which is better, I'd suspect the second but testing...

I'm not sure ChrisM's solution works in the general case - the various MAX's operate independently and so unless you can guarantee the values all ascend in time (which seems...