you can loop it.

or you could do the agent job on a local instance of sql server(if u have one) and then run the select across a linked server).

simple example

DECLARE...

easy enough to put it into a sql agent job and then have the select insert into a table. then you can just query that table whenever you would...

45

Ok, did he use a cherry bomb on that fish instead of a filet knife?

This is a good new feature and am happy to see a question on the topic.

Thanks Steve

Greg Edwards-268690 (4/20/2014)

---

SQLRNNR (4/20/2014)

---

Greg Edwards-268690 (4/20/2014)

---

SQLRNNR (4/20/2014)

---

Greg Edwards-268690 (4/20/2014)

---

Dwain -

Hope my car is faster, as I can't even stretch a fish lie to make one that big. 😀

Not the...

no gain

Greg Edwards-268690 (4/20/2014)

---

SQLRNNR (4/20/2014)

---

Greg Edwards-268690 (4/20/2014)

---

Dwain -

Hope my car is faster, as I can't even stretch a fish lie to make one that big. 😀

Not the '66, but still...

with no name

Greg Edwards-268690 (4/20/2014)

---

Dwain -

Hope my car is faster, as I can't even stretch a fish lie to make one that big. 😀

Not the '66, but still have a Goat...

Lynn Pettis (4/19/2014)

---

Greg Edwards-268690 (4/19/2014)

---

I particularly like the...

Lynn Pettis (4/19/2014)

---

Jagadeesh Chowdary (4/19/2014)

---

If the Database is in Suspect mode then follow the below steps to recover ur DB

>Stop the SQL Service

>>Copy the MDF and LDF file and place...

+ a few T bills

pretense

Quick call the Ghostbusters