Nils Gustav Stråbø (5/20/2010)

---

shaytoder (5/20/2010)

---

Paul White NZ (5/20/2010)

---

shaytoder (5/20/2010)

---

another option to solve the issue with optional parameters, without using dynamic SQL, is to use CASE, it will NOT check fields...

Paul White NZ (5/20/2010)

---

shaytoder (5/20/2010)

---

another option to solve the issue with optional parameters, without using dynamic SQL, is to use CASE, it will NOT check fields that he doesn't need...

another option to solve the issue with optional parameters, without using dynamic SQL,

is to use CASE,

it will NOT check fields that he doesn't need !

for example -

select ...

from ...

where 1...