jeffem (12/14/2012)

---

Okay, it was foolish for me to have posted confusing code. 🙂

This is not any actual business logic that exists, but rather is a simplified example that causes the...

lmeinke (12/14/2012)

---

Steve,

I was actually replying to dwain c. but I do thank you as well. I was out of the office for a few days and didn't try yours...

And I wouldn't have either, except for having just yesterday copied some code out of a post that wasn't in case agreement and pasting into a query window in SSMS...

Looks like it sorta is in the registry, but if WMI is in place, the following WMI query will shake it loose:

wmic service where "name Like '%SQL%'" get Name ,...

Which account to use was decided when SQL Server was installed, and the information was used to supply the installation procedure with the account name and/or password. Your...

lmeinke (12/14/2012)

---

Thank you for the code and suggestion. I did run the code and it works for all but the very first entry in an industry/category group. I...

Sean,

I wonder if the OP has a case-sensitive collation in place and just miscapitalized something?

You haven't indicated why you chose to create a copy of a table just to join it to the original. Unless you're going to join in a way...

It's only ugly to the extent that it might not produce consistent results for the records affected by lack of date/time accuracy, and to the extent that performance goes bad...

Budget ? Seriously? Somebody must not be thinking. Whatever application is populating the database needs what is likely a 5 second change and then...

That's why I suggested you look at BOL, as I can't recall the exact syntax, but I do know that OPENQUERY has to have a LINKED SERVER NAME, while OPENROWSET...

It's possible that whatever process you are using to execute this BULK INSERT is running with a security context that doesn't have access to that particular share and/or folder. ...

Not sure if using OPENROWSET would help. Might depend on security settings. Look it up in Books Online (aka BOL) and see if that will...

I haven't looked at your attached file yet, but unless you're storing the datetime value for when the status was updated in something other than an actual datetime field, down...

With some thought going into how to add some dummy records to the scenario, you might be able to do something like this, and avoid the triangular join, as you...