Can you take the PG_STATUS out of the database and just calculate it at runtime?

Join the three tables together, where the scout status is not equal to 5, and select...

You'll either need to predefine the value-column combinations, or use dynamic SQL, or use a name-value pair table.

If values will be turned into columns in a dynamic manner, you need...

Roy Ernest (4/15/2010)

---

What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to complete it....

You could assign a unique key to a checksum of all of the columns.

Forgot one part. Add "ORDER BY number" between the Where clause and the For XML clause. It'll usually work without that, but isn't guaranteed.

declare @a CHAR(10), @b-2 char(10);

SELECT @a = 'MIKE'

-- Encrypt

SELECT

(SELECT char( 255 - ascII(SUBSTRING(@a, number, 1)))

FROM Common.dbo.Numbers

WHERE number BETWEEN 1 AND LEN(@a)

FOR XML PATH(''), TYPE).value('.[1]','varchar(10)');

SELECT @b-2 = (SELECT char( 255...

What are you trying to do here? I can't read that code well enough to tell what it's doing.

If you can describe what the end result is supposed to...

That's correct. You're adding to the end of a full string.

You either need to set it to varchar, or turn off ANSI Padding.

I'm renaming it so that applications don't have to have any changes made to them. With the way things are set up here, that's moderately important.

It also keeps the...

Yes, it's mandatory at this point.

Looks to me like you just need to make sure the login you're using can connect, and your connection string is set up correctly.

If it's more complex than that, what...

I'd replicate from Oracle to Oracle.

You'll have to create a custom role for that.

Add the ability to view system data, deny the ability to create/modify/delete objects.

WayneS (4/15/2010)

---

Gus, FWIW, I think you have an excellent list of steps to do. Can we get you to update this when you actually do move the databases to include...

george sibbald (4/15/2010)

---

Sorry, reporting services encryption key, backed up via RS configuration manager (or it was in SQL 2005). You will need that if you are restoring the reporting databases...