I think you meant 'tome' rather than 'tomb'!

MotivateMan1394 (4/7/2015)

---

Hi

I Have a field in my Query Result with this Value : For example "Http://www.sssss.com"

I want To change it to Which User click on it, Directly Open a web...

Technically, I see...

I should have read the question more closely. My idea would not work because the search strings include spaces.

The way I would do it is to split the string into its component words using this[/url].

From there, you can do a direct match.

Rather than hijacking this thread, I suggest you start another.

hadas.hadas (4/2/2015)

---

I wonder if the migration issue is only among a small group of users. In an otherwise extremely positive review, the only drawback was the cost for going...

Regarding modifications to the new proc, can I suggest that you create a new proc which fixes column ABS and then simply add a row at the end of your...

Something like this?

select kqt.OrderNum

,QCStatus = (case when count(kqt.OrderNum) - count(kqt.QCPass) > 0 then 'QC Incomplete'

...

2Tall (3/31/2015)

---

Hi Phil. Indeed I can have multiple variables!

I found I had to perform an additional step within the SSIS project. On the FTP Connection Manager I chose Parameterize then...

2Tall (3/31/2015)

---

Phil one last question. If individual environment variables are created for Server Name / User / Password the subsequent SQL Agent Job appears to be only able to reference...

You've been here long enough to know that you need to post DDL, consumable data and desired results to get a working solution.

See the first link in my signature for...

2Tall (3/31/2015)

---

Hi Phil. I was not prompted for the password. After importing the package into SSIDB I selected configure. I then selected 'Connection Managers'. I selected the connection manager of...

2Tall (3/30/2015)

---

Hi Phil.

Are you using the project deployment model, or the package deployment model?

You need to use the former if you want to use environments. If you are not, I...

wendy elizabeth (3/30/2015)

---

In a t-sql 2012 stored procedure, I would like to know if my solution to solve the problem is correct and/or if you have any other suggestion(s)...