Viewing 15 posts - 1,096 through 1,110 (of 1,539 total)
Forgot to mention one imp point.
Keep the database recovery in bulk-logged mode before running that query. This will speed-up the query to a very large extent.
Once query is finished, put...
June 16, 2009 at 10:32 pm
interflex (6/16/2009)
delete from transactions
where matters in (select top 1000 matters from matters where matterid = '2098-75')
and stage = 'wip'
This will delete only 1000 records
Also to delete the records, i'd...
June 16, 2009 at 10:28 pm
john (6/16/2009)
Thank you, so has the first part which you did not use, was that valid in previous versions or?
No no, i just wrote the part with error in the...
June 16, 2009 at 10:12 pm
john (6/16/2009)
Query:
SELECT * FROM EMailAddresses WHERE EMailAddress IN (SELECT EMailAddress FROM EMailAddresses GROUP BY EMailAddress HAVING COUNT(*)...
June 16, 2009 at 9:59 pm
Thanks. will try this out today 🙂
June 16, 2009 at 9:36 pm
GilaMonster (6/16/2009)
GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking...
June 16, 2009 at 1:48 pm
GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking for...
June 16, 2009 at 1:27 pm
Luke L (6/16/2009)
ps (6/16/2009)
t or it's trying to hide itself as it prepares to take over the world...-Luke.
Looks like this is the most probable reason.:w00t:
June 16, 2009 at 1:25 pm
Ahh how can i miss that.. there is some syntax error out there....
select 'range <$10k'=
case
when salary = 10000 and salary = 20000 and salary = 30000 and salary < 40000...
June 16, 2009 at 1:23 pm
no i'm getting all updated posts if i click on posts added today.
except this thread.. also tried to refresh by ctrl+F5.. same results...
June 16, 2009 at 1:17 pm
Luke L (6/16/2009)
Alvin Ramard (6/16/2009)
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?
It's...
June 16, 2009 at 1:10 pm
Alvin Ramard (6/16/2009)
ps (6/16/2009)
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?
It's there. ...
June 16, 2009 at 1:08 pm
i cant find this thread in the main forum? only from my email notifications i can read it. Has this been removed from main forum?
June 16, 2009 at 12:53 pm
murthykalyani (6/16/2009)
June 16, 2009 at 12:42 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,539 total)