So our major hurdle to move our data to the cloud is security concerns and backups.  We are a government entity, and thus we have all kinds of data where...

I attempted to work from home for a few days.  But technical issues with my VPN/Internet and the fact that I really did not have a good place to work...

Working in a government organization, I have seen many times that either staff has spent hundreds of hours developing a piece of software or they have bought software and somewhere...

I have owned and driven in more cars and trucks that I can remember.

I owned a Mitsubishi Montero some years ago.  It was a good 4-wheel drive vehicle.  Pretty comfortable...

We have dozens of small Access databases in our organization (most of them supported by staff outside of IT).  A number of them use an MS-SQL back end which provides...

Our job title recently changed from Business Intelligence Analyst to Business Intelligence Developer.  It was an end-around move to get out of HR's decision in putting everyone who has 'Analyst'...

Got the back up info.  So a little explanation.  EventAttribute contains a value (can be a comma delimited value) that is a FK into the Lookup table.  The AttributeDef table...

Other staff in our office has rights to created functions, stored procedures, etc.  I just don't.  I may be able to find the original query or re-create it, which did...

Thanks, I am still looking for the solution that did not require a function.  I believe it used a cross apply.  It turns out there a backup of my C:...

I will have to see if I can post the DelimitedSplit8K function to our DB.

Thanks

Let me restate my original issue.  There is a comma deleted value (sometimes there is only one value) that are indexes (i.e, IDs) into another table that has a value. ...

We got into a situation where we had to create an MS-Access application for a business need in a hurry. The application was created and supported by one person...

Our organization health care premiums are per person. So if you have four family members to cover then it would be the rate X 4. We have several...

Sounds like a maintenance nighmare. But if each department has solid IT staff to keep up on licensing and updates, then it might work. I work for a...

I do not know much about Try, Catch and Throw. But I got rid of all of the semicolons and the code ran without an error on MS-SMS 2008.