Don't Mess with the Zohan is wretched.

I just watched the Star Wars prequels again over the last three nights. Strange to realize while watching Clones that Jar Jar is...

This one:

http://www.sqlservercentral.com/Forums/Topic645585-146-1.aspx

Deserves some sort of "Hall of Fame" entry.

I have to admit to a strong desire to tell the guy to step away from the database and keep his hands...

I can recommend Iron Man, The Hulk and Dark Knight, for just plain special-effects, comic-book fun. Hancock is quite good. Gran Torino is in theatres, but when you...

clperez271172 (1/29/2009)

---

quisiera saber como poder hacer que se guarde el log de mis dts en una tabla especifica , o como hago para que mis dts guarden el log de...

And that statement right there is why I wonder about the people who are so hooked on the idea of code portability. In most cases, the gain from switching...

It'll depend on what he's looking for. If he needs the start month, it needs a -1 on the row_number function, so that it starts with 0 instead of...

"SSC Carpal Tunnel" is just a title for writing far too many posts on these boards. The actual screen name is in bold right above that, "GSquared". You've...

GilaMonster (1/29/2009)

---

We...

Still don't understand. Can you ask in Spanish, so I can look up the words for it? Would that help?

I'd build a "Schedules" table, comparable to a Calendar table, for this kind of thing.

It would contain something like ten years of dates, broken down by minutes.

Then, you could join...

The Numbers version can work across years, just have to have enough rows in the Numbers CTE (you can get quite a few with just sys.all_objects; if that's not enough,...

Check out Exists in Books Online. You should be able to build an update with "Where Not Exists" in the Where clause.

If you need help with writing it, post...

Bruce W Cassidy (1/29/2009)

---

[font="Verdana"]I guess we are verging from the original topic.

I've always found security is a better mechanism for enforcing access to database objects. Oh, there's a feature...

That is not the log table. There...

Bruce, on another thread with this same guy, we decided that the probem is that he's apparently using Babel Fish to translate from Spanish. It gets incomprehensible really fast.