stevewes (9/25/2013)

---

Hi Sean,

I have managed to get the query working and also have setup DB Mail and the Query now mails me if the rows are greater than 90 so...

C.K.Shaiju (9/24/2013)

---

No you can't simply ignore...

C.K.Shaiju (9/24/2013)

---

Hi,

How do we ignore an error in T-SQL?

For e.g.:- The following code throw an error once the @lCounter reach at 15 and will come out. Requirement is it...

PLEASE do yourself a favor and read this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

It has been suggested to you at least a couple of other times in the various threads you have started all...

pietlinden (9/23/2013)

---

Just say NO to dynamic SQL!!! That opens doors to all kinds of REALLY bad things! I should probably go find Kevin Kline's "SQL Server Low-Hanging Fruit"...

You can find a lot of discussions about that here.

https://www.google.com/#q=sql%20server%20hierarchy%20vs%20parent%20child

dwain.c (9/23/2013)

---

Steven Willis (9/20/2013)

---

The easiest method is to use Generate Scripts...

vani_r14 (9/23/2013)

---

Hi all

am trying to write a case statement an that currently returns one column. Is there any way that it could return multiple columns.

for e.g.

case when <condition> then...

Look at try/catch.

http://technet.microsoft.com/en-us/library/ms175976.aspx

You can do that with database triggers. Lowell shows a great example of it here. http://www.sqlservercentral.com/Forums/Topic1141863-338-1.aspx

Maybe you have an open transaction? What is the result of this query? select @@TRANCOUNT

enriquezreyjoseph (9/23/2013)

---

Sean Lange (9/23/2013)

---

Instead of this, read the article that Jeff...

Then the code you posted should work fine.

SET column_a= DATEADD(DAY, ABS(CHECKSUM(NEWID()) % 3650), '2015-01-01')

Remember there is not such thing as a format for date...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

What is the datatype...