Jeff Moden (2/5/2014)

---

I wonder when the terms "Internet" and "Cloud" would eventually come to mean the same thing to many people.

You're correct. I fascinated that if I can get...

When reading the following...

I really expected to see this...

Wabbit

Knowing Keith, it was...

Thanks. I learned something on this one.

Jeff Moden (2/5/2014)

---

Keith Tate (2/5/2014)

---

First please read the article in my signature about posting these types of questions to the forum. After you do that I could make sure that...

Jeff Moden (2/5/2014)

---

SQLRNNR (2/5/2014)

---

dwain.c (2/5/2014)

---

Jeff Moden (2/5/2014)

---

He should come to Michigan. It was snowing to beat the band a couple...

Well, it worked with...

Well done.

Assuming no new transaction have occurred between the backup and the time replication is recreated. You could also re-init the subscriber via a new snapshot (depending on what your...

This will usually resolve for me if I shut down SSMS and re-open it.

At any rate, the red squiggles are just for intellisense and the queries should continue to work...

ngreene (2/5/2014)

---

This article may be helpful for your problem.

http://sqlprosperity.com/post/SQL-Server-quasi-real-time-performance-monitoring

It has helped me a lot to identify what processes are causing blocks without having to be on the server querying it...

dwain.c (2/5/2014)

---

I agree that your expected results don't match your sample data. But I think you're looking for something like this:

SELECT id, cid, startdate=MIN(d)

, enddate=CASE

...

sharonsql2013 (2/5/2014)

---

Can I pass multiple values to a subreport.

I need to find the total value which is based on three values for the same parameter.

In text box Properties > Actions...

I have also found that running the report from ReportServer url instead of report manager also produces better information. It's worth a shot.