It's a virtual or theoretical UI. 😀

The application basically throws up a form that is scattered...

quagmired (11/6/2013)

---

Is there any reason not to avoid using dynamic SQL here? Performance? Elimination of subqueries/joins (no joins in your example)?

Running the select with conditional comparisons produces the...

dratnikova (11/6/2013)

---

Thanks for your article, I wish I read it before writing my first dySQL procedure 🙂

As for me now I prefer to do full testing of all possible combinations...

Ed Wagner (11/6/2013)

---

dwain.c (11/5/2013)

---

First of all, thanks to Steve for fixing the SQL formatting issues in my recently published article:

How to Design, Build and Test a Dynamic Search Stored Procedure...

davoscollective (11/6/2013)

---

Are you trying to return only records where ReferenceNo IS null?

Imagine this...

Ed Wagner (11/6/2013)

---

Nice article, Dwain. I like how you presented your methodical process to handle each step at a time. Hopefully people won't just want to skip to...

Yes please. DDL...

ChrisM@home (11/6/2013)

---

I'll second that - and give credit...

John Mitchell-245523 (11/6/2013)

---

Dwain

I think the danger with that is you end up with something like a catch-all query and you risk having a less than optimal execution plan cached. ...

a20213 (11/6/2013)

---

pretty neat function you did Dwain )), plenty of new sql strategy to learn and understand, thank you. By the way, you a small syntax error @ CREATE FUNCTION...

While I don't have time at the moment to craft a full-blown solution for you, I might have a couple of ideas to get you started.

I don't think you're going...

Looks like you're missing a couple of single quotes. Maybe this?

declare @name varchar(100)

declare @sql varchar(max)

SET @name = 'Sanjay Whitehouse'

set @sql=

n'SELECT * FROM OPENQUERY (

ADSI,

''SELECT givenname ,

sn,

displayname,

samaccountname,

telephonenumber,

mail,

department,

title

FROM ''LDAP://domainobfuscated

WHERE

objectClass =...

First of all, thanks to Steve for fixing the SQL formatting issues in my recently published article:

How to Design, Build and Test a Dynamic Search Stored Procedure [/url]

So I'm chatting...

I see you took my advice and reposted to the 2012 forum with the DDL. Good for you!

Now a few questions:

- Can a transaction qualify for the same event...

Excellent point Alan - a case that I clearly overlooked and a simple solution to it as well.