the way the sqlsource works in Visual Studio is you can either write your own sql, or hook in a stored proc. I wrote it, fixed it, and voila,...

Jeff,

thanks, that was it.

M@

Tried executing this, but the result set comes back with 0.

ALTER PROCEDURE udsp_CPOChooseFacility

-- Add the parameters for the stored procedure here

@roles varchar(2000)

AS

BEGIN

-- Insert statements for...

J-F Bergeron (12/1/2009)

---

You have 2 solutions for this.

1. Can you try using the statement I've provided you directly in your XML, in the Select statement parameter? Sometimes, you can use...

This is the format I need to fit it in:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:AppDevConnectionString %>"

SelectCommand="select e.entID, e.entShortName, p.enterpriseID from permissions p...

yeah, sorry about that. I should probably post this on asp.net instead.

I'm actually looking for some advice as well. I designed this really quickly to put out a fire a year or so ago, but what the point of the...

I get what you mean in the first two articles. To tell the truth, I was looking more for a shove in the right direction as to what to...

Phil Parkin (5/7/2009)

---

Maybe you could write to a single variable within the loop - just keep on appending messages to it as you iterate round - and then use the...

Phil Parkin (5/7/2009)

---

Sure. Make sure that the variables you are using are scoped at the package level and then add your tasks to create the file and send the e-mail...

GSquared (5/1/2009)

---

So if I understand you correctly, I have two tables:

Table 1 - the holding table for the full file.

Table 2 - the final table that the production data is...

I had the first in mind, but I had a feeling you were about 5 steps beyond me.

Thanks for the offer, I'd like to try to figure it out, but...

GSquared (4/30/2009)

---

Why not update all at once, and then do an insert of the rows that aren't in the target table. Two transactions. Should be pretty efficient, much...

think I just answered my own question. Is this the cleanest way of doing it?

select ltr.littrackingid,ltr.versus, lty.litTypeDesc, loc.attnyName, ltr.entryDate, ltr.status, ln.note

from litigationtracking ltr left outer join

litigationType lty on...

I would love to. Expenses and budgets are close to nada right now. I'll keep the link.