Here is one way.

declare @dt varchar(12) = 'Jul 11 2014';

with dt

as (

...

Try

SUM(Cast [bitcolumn] as int)

Instead.

Luis Cazares (2/23/2015)

---

This is simple and any Oracle forum should give you the answer, but I'll include it here.

You need to use the TO_CHAR() function to format dates and TO_DATE()...

SQL_Kills (2/23/2015)

---

So am I right in saying if the field KeyRef is not one of the followings:

NULL

*CORRECT*

***FAILED***

'' (Empty)

Then it does not meet the condition so It will not get passed...

A quick reformat may help

ISNULL(KeyRef) ? FALSE :

(KeyRef == "*CORRECT*" ? FALSE :

(KeyRef == "***FAILED***" ? FALSE :

(KeyRef == "" ?...

That would be fine, if all dialects of SQL were...

You're in the wrong forum, I'm afraid: this one is for SQL Server 🙂

Here's one way. Not sure if there's anything more elegant.

declare @d date = '20081221'

select @d

,replace(convert(char(11), @d, 13), ' ', '/')

And presumably you...

Sridhar-137443 (2/19/2015)

---

Hi, I am trying to find out an efficient way to determine if employee meets a criteria. We have employee table that has following information

Company, Empno, Level1, Level2, Level3,...

If the database file has been corrupted and you have no backups, and no one has scripted out the procs you are talking about (check with the developers), I am...

A side point. Char(50) is probably not the optimal datatype to use here, as your names have varying lengths. I would recommend that you switch to Varchar(50) to save space.

NO NEED TO SHOUT.

Once again, if your database is under source control, you can retrieve the definitions there...

From source control?

In my experience, developers do not have the same big-picture view of server health and performance that DBAs have (and need to have to do their work). Seasoned DBAs know...

Bizarre. Haven't used Ignore_dup_key for a while, but this looks wrong to me.