My MSI will not work for your situation. All you need to do is grab the report view redist cab from your report server and compile one using Visual...

just think about this thread how some days it may get 1-2 posts and some days it might be a fifty to one-hundred. It all depends on the topic...

Roy Ernest (9/22/2009)

---

Grant Fritchey (9/22/2009)

---

Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more....

Rob Fisk (9/22/2009)

---

I agree. Definitely an interesting article but I would have liked to see tests against an already created and indexed tally table and the reasons for going dynamic...

OR... you could take a look at your security setup, fix it and get on with life without paying for something else or having to learn a new reporting system.

-Luke.

Nope not really....

Jason Miller-476791 (9/17/2009)

As far as Steve's idea of "deprecate that" function, I would love to see that.

A backward approach could be made. All of the procedures we have here...

funny, the waybackmachine has SSC listed back in Feb of 2001... bit of a preview perhaps...

http://web.archive.org/web/*/http://sqlservercentral.com

desktops, servers it's really all the same at this point. I buy what I can afford... the most Cores and speed for the money. I do take a...

Glad to help, but like I said just be mindful of things happening in other various TZs like DST etc if that is an issue for your org.

-Luke.

like I said the solution has some limitations but it does meet the criterion for a inline command. 3 lines were put in to provide some sample data (which...

Seems as though you have not been granted the appropriate rights to the reportserver. I believe you need publisher rights to publish new reports.

-Luke.

Just off the top of my head you could look at doing something like....

DECLARE @datetoChange AS DATETIME

SELECT @datetoChange = '2009-01-01 12:00:00.000'

SELECT @datetoChange,

DATEDIFF(hh,GETUTCDATE(), GETDATE()) AS DIFFfromUTC,

DATEADD(hh,DATEDIFF(hh,GETUTCDATE(), GETDATE()),@datetoChange) AS modifiedDate

There...

Grant Fritchey (9/9/2009)

---

No, I was under the impression that one was right on the money 😉

According to Wikipedia... http://en.wikipedia.org/wiki/Swallow

"Species breeding in more tropical areas are often more sedentary, although several tropical species are partial migrants or make shorter migrations."

The pic on the left has this...