Viewing 10 posts - 16 through 25 (of 25 total)
there is no gurantee of the order of the return result unless you exclusively use the 'order by' statement.
June 18, 2009 at 3:57 am
Is it what you are looking for??
select item, price1, price2, max(date)
from #temp
GROUP BY item, price1, price2
but i am not still clear about ur requirement.
June 18, 2009 at 3:29 am
Thanks for the good article, Jonathan. 🙂
June 18, 2009 at 2:57 am
slange (6/17/2009)
Something like the following should do it:
declare @SearchChar char(1)
set @SearchChar = ' '
declare @Name varchar(50)
set @Name = 'Jamie''s Car'
select left(@Name, charindex(@SearchChar, @Name) - 1)
There is a potential error...
June 18, 2009 at 2:07 am
Hi,
Half of the code is already in your question..change the and/or in the where clause according to ur requirement
SELECT[name]
FROMtableInfo
WHERE(@x 0 and @x is not null and x...
June 17, 2009 at 9:17 am
"Either char(1) or varchar(1) may be used. Both would allocate 1 byte of space which would be used. "
doesn't varchar take extra 2 bytes for variant length? I think...
June 5, 2009 at 3:00 am
Thanks for the good article! we are planning a server upgrade in the near future and it will become very handy 😀
May 8, 2009 at 3:12 am
just curious that who is the 1000000th member? 😀
January 29, 2009 at 6:48 am
Yes, I can't find automation file mentioned in the article either, pls someone tell me where I can find the zip file.
Thanks,
Pyay
October 30, 2007 at 3:16 am
Viewing 10 posts - 16 through 25 (of 25 total)