you don't need the sub.productnamecode in your outer query
select max (sub.number) no_pro
select productnamecode, count(*) number...
is it always in pairs ? Will there be situation where there are more than 2 records within the time range that you specified ? And in such case how...
Since you are zipping the database backup file, just use the zip software to break into multiple files while zipping it. Check the documentation of...
Or you can make use of a random generation function by MVJ from...
CREATE TABLE #temp
INSERT INTO #temp (value)
Do you have any problem with your delete query, post it here, we will help to fix it.
Also please refer to the Books Online on the syntax for...
try adding this line
left outer JOIN SystemUsers su1 on s.ShiftClosedBy = su1.SystemUserID
or s.ShiftClosedBy is...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Rule 1 :
set grade = 'A'
where examscore is not null
and areacode is not null
Rule 2 :
set grade =...
You want the average time taken by hour ?
Can you post your table structure and some sample data ?
you can't aliased a column in the order by and group by. You can just use the column alias in the order by but you have to use the full expression in...
also your insert statement is wrong.
set [desc] = 'testing3'
from #c1 a inner join @b1 b
onb.cno = a.cno
set StatusDate = a.StatusDate
from tbl o inner join tbl a
on o.PaperID = a.PaperID
and o.StatusKey <> 'A'...
please do not cross post
Please do not cross post.
can you post the query that you used ? and also what is the result that sp_diskspace return ?
<br />May Nonut = McDonald<br />kalah ok = Karaoke<br />annie wear sari = anniversary<br /><br />Anybody guess correctly what that is ? [<img...
Separate names with a comma.