While I can get the Power Query to work great for me, as soon as I send it to someone else, they are prompt to enter credentials to access the...

I couldn't determine a way to use my existing stored procedure in Power Query, so I converted it to a view. Works great that way.

No laptop at work and I don't really want one either. Without one, I am free to go home without carrying a laptop and free to go to meetings...

In all my years in this business I have never seen a lookup table remain static. New values are added, old values deleted, and current values changed to meet...

Like Tobar, I would hope that most people can do that multiplication.

It is nice to have tools to do such things for us, but we should have an understanding of...

The company that I work for provides services to monitor generators and we work closely with a company that provides maintenance on the generators. It is a recommended practice...

Right now, just plain go NHL Owners/NHLPA. I just want to see hockey.

I've never done that, at least not this week .... :hehe:

I didn't suggest to accept the job, just to let the interview to finish. You should try to speak with some of the employees or find some references from somewhere...

I just don't get the "shock" interview mentality. My boss did this to one of my co-workers. He brought him in for an interview and about half way through spun...

AARRGH! I hate DST.

There is just no easy way to manage schedules that fire in UTC so that they are aware of the switch. I ended up writing...

As stated, it depends. But here are options that I use:

1) I read the data into a table variable or cte and do processing, then insert it into the...

Jason, thanks for the suggestion, I'll keep it in mind for future use.

The problem was not in this expression, but in another similarly named column that still contained a null....

I like Dev's checklist. By setting a database offline, you are able to quickly get it back in place if you overlooked something and it is still needed.

The first...

Congratulations Jeff, you deserve it.

Regards,

Scott Arendt