Too much talk about steak: I had to have one for dinner!

This was my steak last saturday. Still alive.

SSSolice, your suggestion is good, it works, but I suggest that you take a look at the article I linked. You will see that "catch-all queries" or dynamic search conditions...

What's a "Prime Rib", Jason?

:hehe:That's the idea behind!:hehe::hehe:

Thanks Gus, I would never have thought of milk! I'll try and let you know the results.

My steak recipe is the shortest ever:

* volcano hot grill

* raw steak

* max...

GilaMonster (11/20/2009)

---

Interested in a 3-hour pork goulash recipe? Or maybe a 6 hour...

GSquared (11/20/2009)

---

In exchange, I taught him a few tricks with steak that he'd never heard of. (There are reasons that I'm 30 pounds overweight, none of which have to...

Alter Proc sp_Test (@a varchar(10), @b varchar(10), @c varchar(10) = NULL)

as

Select a, b, c

From TestTable

Where a=@a

and b=@b

and c=ISNULL(@c,c)

This works, but it's not efficient.

Take a look at this article:

http://www.sommarskog.se/dyn-search-2005.html

Regards

Gianluca

GSquared (11/20/2009)

---

I don't drink coffee. If it tasted as good as it smells, I'd drink it. As it is, I can't stand the stuff. (And, yes, I've...

Steve Jones - Editor (11/19/2009)

---

It's a good debate, but...

Oh, that's ok...

Gary Istvan Varga (11/18/2009)

---

Charles Kincaid (11/18/2009)

---

I would prefer...

dlongnecker-802303 (11/18/2009)

---

Hrm... I using this in a sproc to gather data from other servers, but it doesn't like using a variable as the server name:

SELECT @version=version FROM OPENQUERY(@SERVER_NAME,'SELECT @@MicrosoftVersion /...

This select @@MicrosoftVersion from the LOCAL server, not the remote one.

Try with OPENQUERY:

SELECT *

FROM OPENQUERY(server,'SELECT @@version')

Hope this helps

Gianluca