jwbart06 (7/26/2011)

---

I would have to agree that it is very slick.

I was trying to think of doing it with out having to rely on sys.columns, but I can not think...

That is a totally wide open question. There is no way anybody is going to know what questions your interviewer will ask. Best bet is to use google and find...

So you got it figured out now??

I can help you get started if you can post some ddl, sample data and desired output.

Anybody know policy based management better than I do (shouldn't be too hard). This guys has a question about using ExecuteSql with parameters.

http://www.sqlservercentral.com/Forums/Topic1290088-391-1.aspx

I am not too knowledgeable about PBM but I will ping the others. Somebody will know this.

I agree with the previous two...this is a recipe for disaster. I have worked on a system that was like this and it was pure and absolute hell. The code...

Nowhere near enough information to even being helping you. Please take a look at the first link in my signature.

Well he just using that as an example that it does not validate the state of origin of the SSN. I have no idea what you mean about politics. 😉

Well you description is rather confusing but the only way you are going to pull something like this off is with dynamic sql.

bpowers (4/25/2012)

---

Below is an example of a script I have, which works fine. However, I would now like to multiply the "AVERAGE_QTY" by the "USED". Any idea how I can...

Lynn Pettis (4/25/2012)

---

Sean Lange (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

Also, take a close look at the line highlighted, looks like there is a hanging comma (,) at the end

EXEC [pPortfolioDashboard1]

---------- Required parameter------------

@SessionGuid...

Lynn Pettis (4/25/2012)

---

Also, take a close look at the line highlighted, looks like there is a hanging comma (,) at the end

EXEC [pPortfolioDashboard1]

---------- Required parameter------------

@SessionGuid = @SessionGuid,

@FromDate = @FromDate,

@ToDate...

I guess my previous answer was not enough?

Try looking at the error message.

@Portfolios or @PortfolioObjectID cannot both be null, one must be populated

@Portfolios or @PortfolioObjectID cannot both be null, one...

I gave you an answer in that thread.