DECLARE @CCSG bit

DECLARE @User ?? -- (??...

The error message is telling you exactly what you need to do. You need to declare the variable @User before you use it in your query.

Not sure, but this may just be a metadata change to the column. Looking at the numeric data type since your precision is not changing, the number of bytes used...

tony28 (10/17/2013)

---

Lynn Pettis (10/17/2013)

---

tony28 (10/17/2013)

---

Before than i will give the design and data,

I forgot for I think important issue, If this function is using for example inside 20procedures, it...

tony28 (10/17/2013)

---

I thinking about modify to ITVF, but i think it will be very hard and slowlier like one query...

1. I have to declare variable

2. alone queries are very...

First, you really should...

tony28 (10/17/2013)

---

Before than i will give the design and data,

I forgot for I think important issue, If this function is using for example inside 20procedures, it can causes this...

As both Gail and I suggested, look at installing...

I was looking at your function and I am sure it can be improved, unfortunately with all the conversions between datetime and character formats and the lack of perspective (we...

If the reports you are emailing are static, not requiring the ability to query back to SQL Server, then you do not need to additional licenses for the users receiving...

Since you are using enterprise features in production, you need to have enterprise features available in your test/development environments.

Installing Enterprise Edition in a test/development environment is expensive, however there is...

Glad you got it working. You should still look at rewriting your process without using the Web Assistant tasks as those procedures are deprecated and your current process will...

Well,...

Hopefully I will be able to attend PASS next year!

Actually, don't worry about it. If you had this problem there are probably more out there with the same problem. If they find this thread they will find...