I absolutely agree... in fact, I agree so much, that I wrote an article about it.

Please see the link in my signature for how to properly pose a problem on...

I'd be much more interesting in knowing what it is that "Task.exe" does and why you think it can't be done in T-SQL, whatever it is. 🙂

CHAR(3)? Do you mean CHAR(13)? 🙂

You...

Really? Try this and see if ISNUMERIC is actually what you want...

SELECT ISNUMERIC('3D2'), ISNUMERIC('3E2')

rishgup (10/23/2008)

---

I have database which has 2 tables tblCount with counter_ins field and tblEmployee with emp_name, emp_last, emp_add adn emp_ph fields.

There is no indexing on tables. And I want to...

No it's not... it's the name of a database... and it's @DBName... 😉

JohnDBA (10/23/2008)

---

Please help me!

I have this values that I need to count based on condition.

- If the value is between 10 and 15 and the code is = a...

I'd really like to see that for this one. Got code? 😉

... sorry.... and to answer the other question, I never do a shrink on the database unless some runaway code happened to occur. Database growth should be planned and...

victor_bosc (10/23/2008)

---

As your previous posts you do not recommend recommend rebuilding indexes and shrinking. I agree with that periodically shrinking is not a good idea, but should I NEVER do...

Technically, yes. But it's against the license agreement.

Yeah... but do you need to use DTS or SSIS or is doing it all in T-SQL without the use of xp_CmdShell ok?

Heh... dang managers all need to take a course in how to effectively plan and schedule a software project for success. 😉

Anyway, glad it does what you want and...

Heh... cool! But, you don't really hate RBAR... or you wouldn't be using it. 😉