The question now is. Do you understand it? Would you be able to explain it to someone else...

Tom & Jerry

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news and I'm getting grumpy and sarcastic...

Your first problem is to use SQL code as VB code.

The second problem is that you have an ELSE which you shouldn't have.

Here's an alternative, which is simpler than Eirikur's...

Because one needs a group to show a row and the other doesn't.

Your comments are completely right. I just don't want to assume something with someone new to SQL.

It's not a problem if we change variables' values in a stored procedure, the...

patrickmcginnis59 10839 (6/23/2016)

---

Luis Cazares (6/23/2016)

---

You're welcome.

Do you understand that this is not the best use of a stored procedure? Stored procedures (as any database code) is...

trboyden (6/23/2016)

---

dhaveedh (6/23/2016)

---

None of your links present any information to support your assertion that 2002-02-28 00.00.00.000 is not a valid date. The ISDATE function even confirms it is a...

trboyden (6/23/2016)

---

http://www.w3schools.com/sql/sql_dates.asp

http://www.w3schools.com/sql/func_convert.asp

https://msdn.microsoft.com/en-us/library/ms187347.aspx ( ISDATE() Function)

https://technet.microsoft.com/en-us/library/ms179465(v=sql.105).aspx ( Handling Database Engine Errors )

http://sqlmag.com/t-sql/t-sql-best-practices-part-2 (See datetime best practices...

Conch

trboyden (6/23/2016)

---

dhaveedh (6/23/2016)

---

In your last post you said SELECT CONVERT(Datetime, '29-Feb-2') returns an error because SQL Server does not accept single digit years?

Why does SELECT CONVERT(Datetime, '28-Feb-2') return 2002-02-28 00.00.00.000...

Lisa Slater Nicholls (6/23/2016)

---

Wow, good to know. Do you have a doc reference for this being supported...

Your function doesn't do all the validations that you mention. Are you aware of that?

Lisa Slater Nicholls (6/22/2016)

---

Hi,

I used to do this all the time --

My understanding has always been that UTF8 was not supported by BCP. Therefore, if the incoming file...

You're welcome.

Do you understand that this is not the best use of a stored procedure? Stored procedures (as any database code) is meant to work with...