Chad.Taylor (11/13/2014)

---

I'm confident that I'm using a 'table valued parameter' as my @MemberIds parameter 'gets values from a query" which is another dataset I've created. The second dataset gives me...

I would recommend doing yourself a huge favor. You have two major issues with your insert statements. The first is you don't specify the columns. That means you are expecting...

There are a couple of ways that come to mind for how to deal with this. The first is to pass a table valued parameter instead of a scalar value....

WayneS (11/13/2014)

---

Sean Lange (11/12/2014)

---

Ed Wagner (11/12/2014)

---

Sean Lange (11/12/2014)

---

Holy spam running crazy!!! The spam filter seems to have been turned off again. Whatever is being done to prevent spam is not...

itmasterw 60042 (11/13/2014)

---

I have someone telling me that I should have put my AND statement in the join instead of the where part, but canot tell me why.

so is there...

Your ddl does not work at all. You have a lot of errors in there. You are setting identity insert but none of the tables have an identity column and...

I immediately thought of your chapter in that book Kevin.

I agree 1000% that you should try to avoid scalar UDFs but when you are talking about 400M row result sets...

John Dempsey (11/12/2014)

---

Some opinions are the stored procedure code for an application should reside with the application database even if the stored procedure doesn't refer to any objects in the...

Your question is not totally clear but I would do everything I could to minimize cross database requirements. What I mean is that I would not even consider creating a...

Ed Wagner (11/12/2014)

---

Yeah, did you...

Holy spam running crazy!!! The spam filter seems to have been turned off again. Whatever is being done to prevent spam is not working.

Let's start with some formatting so we can read this. You can use the IFCode shortcuts over on the left side when posting to include your code in a code...

Your question is entirely too vague for anybody to offer much help. What do you mean by debug...

manie (11/12/2014)

---

Then...

Well the error message you are getting is a login failure. Since this is across a linked server the failure is almost certainly on the other end.