Eugene Elutin (8/10/2012)

---

SQL does exactly what should be done in mathematics:

5 - 2 + 3 = 5 + (-2) + 3

Now you can see that it's absolutely doesn't...

dwain.c (8/10/2012)

---

Ah... So you weren't trying to say that, which is what I suspected. 🙂

There's always been a controversy over that acronym: http://www.allvoices.com/contributed-news/6036567-bodmas-is-used-my-millions-at-school-is-it-correct

Quoting that article:

Now if one uses BODMAS on...

These are at the same level - and so are evaluated in the order in...

So the BOL article shows that SQL Server confirms...

Maybe I am missing something, as this seems too obvious, but ... right-click the 'Constraints' node and select 'New Constraint'.

sql server developer (8/8/2012)

---

Pdf's have both text and images. We need to capture text out of it. It can be copied but as you know doing it for 7000 pdf's...

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