There is no problem. SQL Server is working as designed and as documented.

When you cast a zero length string to datatype of datetime, it casts it to the SQL...

OK, as long as we are doing useless SQL, I want to add numbers together without using any Arithmetic, Logical, Assignment, String, Bitwise, or Unary Operators or any Mathematical or...

select

Material,

sum(case Status when 1 then Qty else 0 end)-

sum(case Status when 0 then Qty else 0 end) as Qty

from

MyTable

group by

Material

order by

Material

Bob Abernethy (4/15/2009)

...I'm sure that the vast majority of the decision-makers in these thousands of companies are intelligent profesisonals who went through a valid decision-making process that took into account...

Maybe you should learn to use what is available in SQL Server, like REVERSE, instead of spending time duplicating what is already available.

pshvets (4/14/2009)

---

Hello all.

I am trying to write a function which reverses passed string WITHOUT using any built-in functions

So if 'abc' is passed, it returns 'cba'

I want to use recursion. Here...

RBarryYoung (4/10/2009)

---

Unfortunately Flo, the INFORMATION_SCHEMA views do not...

Theunis Viljoen (4/10/2009)...We are currently looking at encryption tools such as SQL Shield 4 as an effective encryption tool for SQL 2005. I would be interested to read any feedback...

The only time I have seen SQL Server procedure encryption used was for a vendor product.

I decrypted and looked at a few of the procedures. They appeared to have...

If you want to show a special status for a poster, you might consider some kind of SSC MVP status (Most Valuable Poster?) that you setup, instead of using Microsoft’s...

The quality of a response depends on what you say, not who you are.

This is a discussion board, not a place to receive pronouncements from on high. The value...

Lowell (4/8/2009)

---

i left them out on purpose; the format of 0 = format of 100,1=101 etc; just duplicates of the same formats; I thought it's easier to just stick with...

Didn't you leave out a few numbers?

declare @date datetime

set @date = getdate()

select

convert(varchar(35),@date,a.Code) AS FormattedDate,

Code = convert(varchar(3),a.Code),

convert(varchar(40),'select convert(varchar(35),@date,'+convert(varchar(20),a.Code)+')') as [SQL]

from

(

select Code = 0 union all

select Code = 1 union all

select Code...

This will do what you want:

declare @a nvarchar(max)

select

@a = isnull(@a+N' union all ',N'')+

'

select [Database] = convert(sysname,'''+a.name+

'''), [Table] = a.name collate SQL_Latin1_General_CP1_CI_AS from '+

quotename(a.name)+'.sys.tables...

Bob Hovious (4/7/2009)

---

I had a job interview once where I was asked if I had ever thrown large manuals at people. I thought it was a joke question...