Hi Phil - I am using 2014. Which other methods do you recommend for this?

Thanks for your reply.

I am trying to create a Report for my Manager which shows a chart of Users who ran most number of queries in the last 24 hours....

I figured that the tools will not convert everything. I am hoping to get some assistance since I haven't used PL/SQL since Oracle 8i.

Thank you all so much for your...

Phil,

We are going to recreate the ControlM jobs manually due to the complexity of the processes, so this make my life easier somewhat, tedious, but easier.

Thanks for you help as...

Hi Phil,

If there is a way that I can separate the tags, maybe I can wrap this in dynamic SQL. I am thinking something like...

@var = 'Create Job'+<NAME TAG>, etc,...

Thanks Luis.

SQLTougherGuy (9/28/2015)

---

Hello,

I inherited an SSIS package that is rather simple. It grabs data from a SQL Query and then loads it into a SQL table. The first step of this...

This is not what I had planned but it worked!

Thanks Luis 😀

Ignore this post please.

Yup!!! Was missing the COLLATE.

Update TABLE

set DS = Replace(DS, nchar(65533) COLLATE Latin1_General_BIN2, '!')

Thank you all very much! I love this site :-):-)

Ok, so here is what I am trying to do but it is not working. Any ideas?

UPDATE TABLE

SET DS = REPLACE(DS,NCHAR(65533),'');

Awesome! Thank you very much for making my Friday :-D:-D

What I mean by cash-cow is that they rarely make significant changes to the product and push to release new versions. SSIS is not free as it is included in...

I found it! There was this weird character (?) in the data, so you are right about SSIS.

Thanks!

Good point about the Alter Table script. I was able to dump the data into a table with all NVARCHAR datatypes and then was easily able to push the data...