Sapen (1/27/2014)

---

Thanks a lot for the inputs. My initial thought was to use the option MediaPassword while backing up a database and script out the database backup instead of using...

Sean Lange (1/28/2014)

---

mike.conti (1/28/2014)

---

sorry for the confusion: there is no syntax issue

This works: SELECT top 10 * FROM ACTI**_**

it does not appear in when i run this SELECT * FROM...

Greg Edwards-268690 (1/28/2014)

---

GilaMonster (1/28/2014)

---

Anyone got time and enthusiasm? (running low on the latter and it's almost time to go home)

A trigger that doesn't work: http://www.sqlservercentral.com/Forums/Topic1532595-1292-1.aspx

An IF statement that, well, ......

Sean Lange (1/28/2014)

---

GilaMonster (1/28/2014)

---

When there are multiple triggers for the same action (multiple insert for example), you can defined which one runs first and which one runs last, but that's...

Max number is more than you could ever need.

When there are multiple triggers for the same action (multiple insert for example), you can defined which one runs first and which...

I'm not saying that recursive CTEs are bad, wrong, terrible, never use. Just saying be aware of how they behave.

Anyone got time and enthusiasm? (running low on the latter and it's almost time to go home)

A trigger that doesn't work: http://www.sqlservercentral.com/Forums/Topic1532595-1292-1.aspx

An IF statement that, well, ... http://www.sqlservercentral.com/Forums/Topic1535345-1291-1.aspx

Yup.

Would you...

No.

How does a recursive CTE work?

chillw1nston (1/28/2014)

---

--Now scalable, set based and added a fizzbuzz!

DECLARE @threshold int = 100

;WITH numbers ( seqnum )

AS...

I can't tell from that what's going on. That 'May have Data Corruption' is an application error, could be anything triggering that. Without knowing the technical details, no way to...

Then the where clause you have matches no rows.

Probably because of this:

IF @ADR3 IS NULL

SELECT ADR1, ADR2, POSTAL_CODE

FROM PAT_NAMES_ADDRESS

WHERE CURRENT_ONE = RTRIM(@CURRENT_ONE)

AND ADR1 = RTRIM(@ADR1)

AND ADR2 = RTRIM(@ADR2)

AND ADR3 =...

When you say 'data corruption', what exactly do you mean? What errors, what symptoms, etc

SET @ADR3 = 'null'

That's setting the variable to the string value n-u-l-l. If you want to check whether a variable has the string value "null", then you'd need IF...

Other way around.

http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/