Thank you for your responses everyone.

this is what i cam e up with. i passed the database name into a variable , now i am trying...

Thanks everyone,

I figured it out and used a while loop in a cursor.

Thanks

Hello Guys,

Following the code that drew modified, I found another way around it:

SELECT

StationName

, AiredDateTime

, AiredISCI

, OrderNumber

, Line

, ...

drew.allen (12/2/2016)

---

JALLY (12/2/2016)

---

Your solution above will create a conflict between columns that rely on the the sub queries for their source of data and the multi part identifier 'inv.active' will...

Inventory

'Inventory' table

drew.allen (12/2/2016)

---

You can't have a WHERE clause in the middle of your JOIN clause. Just move your WHERE clause after ALL of the JOIN clauses.

...

if i use the where clause to filter return columns associated with inventory inv table to return inv.active = 1, it throws an error if i use it this way...

thank you Phill for formatting.

i want to apply a where condition to a column in the inventory table -dbo.Inventory inv like this:

where inv.active=1

without causing conflicts for the columns in sub...

Alexander Suprun (10/14/2016)

---

JALLY (10/14/2016)

---

I have a dynamic SQL in the form of A SP.

I used Option recompile and option for local variables to work around the Parameter sniffing issues arising...