First of all, I really can't make much sense out of what you are doing. I can tell you you syntax is wrong.

Second, what are you trying to accomplish...

CELKO (5/13/2012)

---

>> I have a VIEW something like:

CREATE VIEW SomeView

AS

SELECT *

FROM Retail.dbo.Employees; <<

We never use SELECT * in production code. The correct name for the base table would be...

polkadot (5/12/2012)

---

So, it's SSRS + weekend (and believe me it's a really uncharacteristically beautifully sunny one).

Still the key question is....can parameters be passed to SSRS (from Word or...

I am going to start by asking you to explain to me what you think are the uses of left or right outer joins. Can you explain to me...

For my current position, all three interviews were actually technical, and all on the phone.

The last interview was the longest and the manager had done research on me. He...

Jeff Moden (5/12/2012)

---

Elliott Whitlow (5/12/2012)

---

As a further point, I dislike most aspects of technical interviews purely because in MANY cases they are very subjective and if you don't give them...

And don't forget that Reporting Services can also be integrated with your SharePoint site.

Seems to me that Reporting Services just doesn't like you for some reason. Wish I could help but not familiar with it enough to provide much assistance. I...

Can you get us at least the physical layout of the base table before you unpivot it? I'd like to look at another possibility. It would help if...

This is starting to sound like a performance issue. Read the second article I reference below in my signature block. Follow the instructions regarding what needs to be...

You said if you ran it in pieces it worked. Starting with the first piece, keep expanding until you have selected the whole script.

Not the first time I heard "experts" say drop and insert is the best way to update records.

Nope.

TravisDBA (5/11/2012)

---

Revenant (5/11/2012)

---

TravisDBA (5/11/2012)

---

That reminds me of why the annual; (allegedly) 'friendly' rugby match between IT and the business at my current company was canned a few years ago....

Full backups and differential backups do nothing to clear the transaction logs. To do that you need to run scheduled transaction log backups.

Please read the last article I reference...