Also as u are brand new to this forum, i would recommend you going through this following article 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

so please post:

1. Table...

Nitesh, apart from _x002F_ and x_0020_ , are there any other pattern that might come in the string??

Malavika, without seeing you data we cant actually write a positively superior code, buy judging what u want from the code u put up, this might help you

select 0 as...

Gaurav, this might help you!

Update tablename

SET

PPT = CASE WHEN ISNULL( NULLIF(PPT,0), 1) = 1 THEN 1 ELSE PPT...

Peter, i can somewhat visualize your existing system and i guess i have a code that might get u there, but as Henrico said, we need to see "physically" how...

Nice to hear your issue is fixed! You're welcome, faheem! 🙂

C'est Pras! 😎

If you want to avoid negative condition, go the postive way... I quite dint understand what your requirement is! The question is too vague, friend! Please be more specific!

😎

I will give u this, buy some back-up restore software! I guess Redgate has got a good one; i officially use Quest Software's LietSpeed! Back-up all the databases, put them...

Suresh, your issue s exactly similar to the one posted under this:

http://www.sqlservercentral.com/Forums/Topic920770-392-1.aspx

I have given a code that will work for the requirement! Please go through that , Suresh!

Its an INT column where u are going to stuff your final output!

INT takes 4 bytes of space regardless of the "number" present in the row!

So assuming, after your...

Sure , Jones!

If it's a dev box, I'd be wary of load testing under VMs. You want to load test...

Gianluca Sartori (5/13/2010)

---

I read in MVP Deep Dives that Hyper-V seems to be good at performance, but I don't have hands-on experience.

My latest fight with a database engine on a...

😛

Dig into the VM and look for pressure in memory or IO and...

Wow Jones himself replying a thread is such a gift, thanks first of all for the reply, Mr.Editor!

Now for your questions:

Steve Jones - Editor (5/13/2010)

---

How is the VM setup? On...

Try this then (assuming your from_date is 8 digits long and 5 and 6th digits represent months):

;WITH DATE_CTE AS

(

...