Can't you configure the datasource to run with a fixed set of credentials instead of using Windows Authentication?

Very very nice question (not only because my name is in it :-D)

Never used WITH TIES before, so I definately learned something.

Good question to close the week.

GilaMonster (4/12/2012)

---

I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code segments together at random...

Try this:

=DateAdd("d",-1,Today())

Grant Fritchey (4/12/2012)

---

Oh lord, I think someone either has a homework panic (as seems to be standard around here) or is WAY over their heads at their job. They want...

These options are a...

Express doesn't support SSIS, only the Import/Export wizard.

Features Supported by the Editions of SQL Server 2008

(there's no page anymore for 2005, but there aren't that much differences between 2005 and...

Sure. It's called cascading parameters.

http://msdn.microsoft.com/en-us/library/aa337169(v=sql.100).aspx

Your query would look like this:

SELECT PLANTCODE

FROM MOM_GSCS_UNMET_IC_DAILY_SUMMARY

WHERE MODELCODE = @ModelCode

GROUP BY PLANTCODE

ORDER BY PLANTCODE

Apply. These job listings describe their ideal candidate. Which usually doesn't exists.

Most of the time it goes roughly like this:

* lots of experience in field A (actually needed for the...

Nice question, always good to learn something new.

Nice article, but why don't you use the system variable @ErrorDescription, instead of fetching it from the logging table?

amaramoosa (4/11/2012)

---

Another issues is that, once you have the SSAS Cubes in cognos Framework manager, you cannot make any changes to it. Basically, you have to do all the modeling...

G Bryant McClellan (4/11/2012)

---

One thing you noted was talking to a coworker about something not related to what you are working on. That has 2 additional benefits. First, it may...

Nice article. Good read, thanks.

If I didn't "distract" myself from time to time with SQLServerCentral, I surely would have less knowledge than I have now. It helps me improving the quality of my work....