Lynn Pettis (8/7/2012)

---

On a lighter note; with the help of my oldest daughter, my middle daughter is going to be attending Embry Riddle Aeronautical University in Prescott, AZ starting this...

morepainot (8/7/2012)

---

Ok, so I am pretty much through my script. I am getting 2 errors througout the script and of course I dont know why. I think its because I...

Sounds like an interview or a homework question to me. 😀

Something like this is what Dwain is talking about.

create table #Something

(

ChildID int,

ChildName varchar(20),

ParentID int,

PID int

)

insert #Something

select 100, 'Bingo', 200, 1 union all

select 101, 'Pingo', 201, 1 union all

select 102, 'Zingo',...

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...