dwain.c (8/7/2012)

---

Personally I wouldn't use Dynamic SQL for this.

My suggestion is to pass the two lists of values (@CriteriaA and @CriteriaB) as delimited strings and use a string splitter like...

asm1212 (8/7/2012)

---

Thanks guys, I tried using this (CTE) and it seems to come back with expected results!

I have go back and check the business rules regarding this to confirm...

GSquared (8/7/2012)

---

Non-recursive CTEs, and CTEs that don't reference prior CTEs, are functionally identical to classic derived tables in the From clause. There's no difference between the two in those...

erics44 (8/7/2012)

---

Jeffrey Williams 3188 (7/15/2012)

---

I use CTE's to organize my queries and move derived tables up to the top of the query. In other cases, I will use a...

Are you talking about an IIS session or...

Using the incredibly simplified ddl I posted a few posts back here is an example of the view...

You're welcome. Hope that helped.

asm1212 (8/7/2012)

---

Guys,

This has gotten overblown...

When I first posted that sample code stuff and realized it wasnt formatted once I finished posting, I remembered that there was a specific way yall...

This is indeed the second question on this topic in a few days that is quite ridiculous. Why would I care how comments are handled inside dynamic sql? Has anybody...

asm1212 (8/6/2012)

---

Yeah no offense but my view is much larger than that, and i was trying to dumb it down...

I have tried using the MAX function, but it does not...

asm1212 (8/6/2012)

---

Unfortunately, I am on a time constraint and dont have time to go through all that so I apologize and will just try to keep working with what i...

sivag (8/6/2012)

---

for example here i got one dynamic search query how to use or condition in dynamic sql server

DECLARE @WordsToSearch VARCHAR(1000)

...

Lowell didn't touch on this so I will. There is no way that SQL can know the IP address of...

Lynn Pettis (8/6/2012)

---

Sean Lange (8/6/2012)

---

Lynn Pettis (8/6/2012)

---

Sean Lange (8/6/2012)

---

Ajdba (8/6/2012)

---

INSERT dbo.xdata (RcNBR ,

...

Lynn Pettis (8/6/2012)

---

Sean Lange (8/6/2012)

---

Ajdba (8/6/2012)

---

INSERT dbo.xdata (RcNBR ,

...