TravisDBA (5/20/2010)

---

Doing stuff outside of your job description all depends on whether Sarbanes-Oxley auditing standards are strictly enforced at your company or not. Sar-Box is very clear about doing jobs...

One of the best ones yet!!! Please keep them comming. I'm a huge fan, reading these is a highlight of my week.

Agreed, it's a nice change.

Roy, if this person is a sybase expert then this person most likely has more of a unix background. I came into sql server from a unix telecom/dba background....

I'm not 100% sure what you're looking for still especially not having sample data and ddl. Assuming I'm understanding you try this:

if exists (select 1

from earned_trans

where msisdn='1233')

)

BEGIN

END

...

I see. Are you looking for the stored proc to return just absent, bank claim or not exists or are you looking for the claim_date and claim_type aswell with...

pattamuthu (5/18/2010)

---

Thank you very much, i will give a try with this, before that i need to add a condition when it doesnt reeturn any result then i have to...

If I understand your logic correctly then this might be what you're looking for:

select claim_date, claim_type,

case when claim_date is null then 'absent'

when claim_date is not null and claim_type = 'bank'...

Thanks Steve for changing the original question. I use this all the time to figure out how far along a backup or restore is.

Steve Jones - Editor (5/17/2010)

---

Thanks, been trying to get those down. After editing 5 articles last week that can't figure out how...

Thanks, I totally agree with your editorial.

The one little thing that I miss from enterprise manager was being able to right-click on a table name -> all tasks -> import/emport...

Thanks for the QOD. I got it right but was 1/2 expecting there to be some type of trick to the question.

I'll also echo Gail's suggestion on better searching capabilities. Maybe a section that has top 100 articles recommended by people who's points are above 3000 or some other number.

Along...

Thanks for the question. Very creative, I would never have thought to write a question like this.

Curriculum Vitae. -- in what to update if you don't have backups and your database is toast (To all us Americans that is a Resume)