" Like a giant, centrally located, application cookie. "

LOL Yep

ZZartin (9/16/2015)

---

Is there a particular reason why your developers want to do this, some weird security reasons that make creating multiple procedures an issue? Or do they think it's...

That's not a bad idea at all. Will need to set up some test benches to make sure the QA is acting the way I think it should be.

Sean Lange (9/16/2015)

---

Manic Star (9/16/2015)

---

Our developers have gotten this idea lately that instead of having many small stored procedures that do one thing and have small parameter lists that SQL...

PS 3.0+ automatically converts a json stream to a powershell object. It actually works quite nicely.

Reminds me I need to finish the article I started writing on this.

My first encounter with it was someone sending me...

JSON is evil incarnate. XML's bastard sibling at best.

😀

Have you tried the Derived Column transformation? It will let you cast to an explicit string type.

Can be useful if done correctly.

Test it to a staging environment first and make sure you're aware of all the gotchas and caveats the system introduces.

Thanks everyone! They ended up using CONVERT instead.

Since its Crystal Reports, try waving a crystal of your choice over the query 😀

Have you tried restoring it first?

As mentioned prior, use the import-export wizard, or run the results to grid and if its not a lot and copy & paste them into the spreadsheet.

brain

I have half of a how-to article written on how to do this with Powershell, which works great with Powershell 3.0+ and SQL 2k8 +.

If anyone is interested, I...