Viewing 4 posts - 1 through 4 (of 4 total)
It is very interesting. However, am still not clear on [flag ='y' ]. Can someone tell me what is this flag. I didnt get any content in...
May 13, 2010 at 11:42 pm
I have a query again around this issue.
The below query gives me the required results.
SELECT sj.name AS JobName,Count(*) AS COUNT,
AVG(( run_duration % 100 )+ ...
May 19, 2008 at 11:46 pm
Create table #temp(inculde the columns which are in Source table)
Insert into #temp values Select distinct * from
delete from source table
Insert into source table select *...
September 3, 2003 at 6:40 am
Once u set the IDENTITY_INSERT ON , and inserted the records into it, the next value would be the max+1. It would not take old value, though EM...
August 1, 2003 at 3:22 am