Does this help? http://www.developertutorials.com/single-sign-on/

Figured out that the missing quote had nothing to do with the question but missed the part where text data type is used.

Are people still using those horrible data types?...

Robert klimes (12/3/2014)

---

seems to me that an idle timeout could be handled better via the web app directly (example). Keeping the session state in the database would require your app...

You're missing the output clause in your SQL Task. I'm not sure that it solves the problem but it's part of it.

Thank you Sean, this wasn't the first time I did it. Fortunately, this has only been a request in the forums.

This is an alternate way of doing it, depending on...

That seems over complicated when you're just adding the database to sp_executesql which can be done directly instead of calling an additional procedure and you remove the functionality of using...

Duplicate post.

All answers in here: http://www.sqlservercentral.com/Forums/Topic1640806-3412-1.aspx

It's weird how this comes from time to time. A report with no relation between the columns in the same row.

Here's an example using basic sample data. It might get...

Sean Lange (12/2/2014)

---

David Burrows (12/2/2014)

---

Luis Cazares (12/2/2014)

---

I have this problem...

Sean Lange (12/2/2014)

---

Ed Wagner (12/2/2014)

---

And reading that makes...

I use the following formula to calculate the previous monday. Just change GETDATE() for any date you need to use.

DATEADD(WK, DATEDIFF(WK, 0, GETDATE() - 2), 0)

You're missing a WHERE clause in your correlated subquery to differentiate each vendor.

Thank you for the feedback.

The question is, do you understand how does it work?

Answers in here:

http://www.sqlservercentral.com/Forums/Topic1640410-392-1.aspx

Answers in here:

http://www.sqlservercentral.com/Forums/Topic1640410-392-1.aspx