Question, how do we determine what year, week, month we are running the query for or is this based on the data in the table?

Just how many different threads have you started asking this very same question???

Are wondering why you aren't...

sgmunson (6/18/2015)

---

Yes, it will get rid of the commas, but it seems odd that a...

Well, we can't see what you see so my guess in my previous post is all I got.

Make it easier for others to follow: http://www.sqlservercentral.com/articles/Administration/2582/

Big topic. I'd start by reading about encryption in Books Online, the SQL Server Help Files.

I guess what I am asking is that you are sure that that program exists in the WinZip directory.

Not seeing the code attempting to...

This?

with basedata as (

select

MEAS_VALUE,

PAT_ID,

RECORDED_TIME,

rn = row_number() over (partition by PAT_ID order by RECORDED_TIME asc)

from

...

gsdineshasm (6/17/2015)

---

Exec Prcoess task with source : \\ftp

destination :\\ftp\unzip

work directory \\ftp\unzip

executable : c:\Program Files\WinZip

i am using expressing.

It is doing the unzip but getting this error

package process on server server1 has...

Sounds like an...

Jeff Moden (6/17/2015)

---

Still, I continue to think it odd that possibly unqualified users can make changes through a GUI that might not have audit capabilities but DBAs aren't allow to...

Now, explain how it works. You will have to support this code.

The problem is the commas in the string. Try this select statement:

select CONVERT(NUMERIC(17,2),replace(@stg,',',''))

Reported as SPAM.

Still looks like the code works:

with TestData as (

select TestStr from (values ('_BF-TYPE:NICK_ _BF-SUBSYSTEM:SERVERS_'),('_BF-TYPE:CONFIG_...