Nice job creating ddl and sample data.

Unfortunately your data and your description appear to be out of synch with each other. In your desired output table you have loans that...

Not sure I understand the question here. Are you wanting to logically or how the actual internals work?

pwalter83 (1/28/2013)

---

Sean Lange (1/28/2013)

---

OK easy enough. As I said previously you will need to use an event of the button. Since you want this to happen when the user clicks...

OK easy enough. As I said previously you will need to use an event of the button. Since you want this to happen when the user clicks the button, you...

Life is too short (1/28/2013)

---

I’m currently working on a migration project and need some feedback on whether or not this is the best way in which to do things.

We...

pwalter83 (1/28/2013)

---

Hello,

I am new to web application designing and using .net (MS Visual Studio 2010) to design an application.

The issue I have is to display information on a table based...

Do you still need help with this or did you figure it out?

Please don't cross post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1412099-392-1.aspx

Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1412195-391-1.aspx

a648 (1/25/2013)

---

Just wondering, if I construct a SQL query in a Stored Proc, and pass record selection criteria into the "EXECUTE sp_executesql ..." as parameters of specified type and value,...

Lynn Pettis (1/25/2013)

---

Sean Lange (1/25/2013)

---

Lynn Pettis (1/25/2013)

---

Sean,

@BatchID should have been @BranchID in the sp_executesql statement. That was a type.

Regarding @params = @Params, quite legal. From MSDN (emphasis is...

maxalama-861292 (1/25/2013)

---

Hi All,

The project I am currently working for is going to have multiple apps each pointing to a separate database. Some examples: Case Mgmt, Data Mining, Chat etc. Of...

Please don't cross post or create multiple threads for the same issue. It just fragments your responses.

Please direct further replies here. http://www.sqlservercentral.com/Forums/Topic1411851-145-1.aspx

Lynn Pettis (1/25/2013)

---

Sean,

@BatchID should have been @BranchID in the sp_executesql statement. That was a type.

Regarding @params = @Params, quite legal. From MSDN (emphasis is mine, and yes the...

momba (1/25/2013)

---

Lynn Pettis (1/25/2013)

---

Sean Lange (1/25/2013)

---

Depending on how often you will be running this query you might consider using sp_executesql instead of the more generic exec. It will cache your...