I'd say it was this bit

SELECT DATEDIFF(YEAR, EecDateOfOriginalHire, getdate()) from empcomp EC WHERE EC.EecEEID = E.EECEEID) as 'Yrs of Serv'

which is returning more than one value for one or more...

And here it is again as a hyperlink:

http://www.simple-talk.com/sql/ssis/working-with-ssis-data-types/?utm_source=ssc&utm_medium=email-main&utm_content=ssisdatatypes-20120723&utm_campaign=SQL

sql server developer (8/6/2012)

---

Thanks for your reply Lowell. I have Adobe Acrobat X V 10.1.0 and don't see the TEXT option when I try to save it. Also, our pdf...

Daniel Bowlin (8/6/2012)

---

Unless you need the extended international character set, you should probably stay with varchar.

To change all the reports I would open the reports code (view code)...

Krtyknm (8/6/2012)

---

Hey,

Can you please provide some on idea on group the common word?

Example:

Code Desc

A1 ...

GSquared (8/6/2012)

---

Abu Dina (8/3/2012)

---

Thinking about this more, I wonder if the following will work.

Street names in the UK tend to end with words like Street, Avenue, Crescent etc, if I...

Gazareth (8/6/2012)

---

MS SQL implicitly casts a blank string into 1900-01-01 00:00:00 in datetime data type so you're a bit stuck there.

Not sure why the NULLs are a problem though in...

Download Redgate's free SQL Search product & use that - it's very intuitive.

The implicit conversion suggestion is strengthened by the following:

declare @MyVarChar varchar(12) = '';

declare @MyVarcharInt int

set @MyVarcharInt = @MyVarChar

select @MyVarChar MyVarchar, @MyVarcharInt MyVarcharInt

mhk0m3 (8/6/2012)

---

[font="Arial"]:-)Let us look at another example why ' or 1=1-- is important. Other than bypassing login, it is also possible to view extra information that is not normally available....

By 'simple', I presume you mean without going through the packages and editing the meta data manually? I'm afraid the answer is 'no'.

You are calling the function wrongly. Try this:

select dbo.t1('test')

You have to CREATE the function before you can ALTER it.

Duplicate post. Replies here.

Just as a riposte to your fish-frying...