nancy.lytle (4/7/2015)

---

I am using SS2008R2 on Windows Server 2003. I am trying to create a package that takes data from a database query and exports it to an Excel...

The final string can be obtained like this

TOKEN("\\\\RLDEVOLP04\\IncomingFiles\\TESTFILES\\FBDET_ZZ_150402054946.txt", "\\",4)

... You can use a combination of findstring and substring to do the rest.

Nothing? That is impossible. To view any results from the SQL Server engine, you need some sort of client.

So I assume that you mean SQL Server Management Studio. You cannot...

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...