I'll rephrase my question:

How do you define what is a special character and what not?

Do you store a list somewhere that defines all the special characters?

Can you explain a bit more what you are trying to do?

Where did you issue the getdate function?

Open up the script. Make sure there are no errors. Close it again and click OK.

What are these special characters?

Can you give some sample data and desired output?

Nice question, learned something. Thanks.

Nice article Dwain, thanks.

Dude, relax. I was just pointing out that there's not enough information in the original post to know what kind of query it is.

If it is an update/delete, the variable...

Luis Cazares (10/28/2013)

---

Ed Wagner (10/28/2013)

---

Sean Lange (10/28/2013)

---

Luis Cazares (10/28/2013)

---

Rating someone on an average for all SQL Server is not a great idea. I could rate myself high on developing T-SQL,...

Not sure, he doesn't mention the type of query 🙂

If it's an update statement, you see nothing in SSIS.

Great question, and well spotted Tom.

Bhuvnesh (10/28/2013)

---

I also...

pnr8uk (10/28/2013)

---

Write the results of your SQL query out to a variable, try single row first, if you have a full result set then it gets a little more tricky....

Here's a starting point:

Deploying SSRS artefacts using Powershell (Simply)

You cannot deploy SSRS with TSQL unfortunately.

Powershell might be possible though, if you can access the SSRS webservice with PowerShell.

Usually automated deployments are done using VBScript [/url]or by MSBUILD[/url].