isn't that simple..??
Code:
select top 3 * from (select top (select COUNT(*) from tablename) * from tablename where person = @personid order by date desc) as RS
ssnaik84
Last Activity: Oct 12 '11, 08:28 AM
Joined: Aug 17 '09
Location: Bengaluru, India
-
Well nbiswas.. then use TOP... :)
isn't that simple..??
-
you can get idea from this thread..
now, your new resultset RS will have last 3 results..Code:select top 3 * from (select * from tablename where person = @personid order by date desc) as RS
you can join it with your original table.Leave a comment:
-
compiler first check semi-colon (;) that is terminator symbol of statement.
then takes value in between first two double quote (")
if you want to use extra double quotes, then use backward slash (\) before extra double quote (")
Code:string str = "\"\"";
Leave a comment:
-
try printing your SQL stmt variable. and run directly on Query BrowserLeave a comment:
-
check for following conditions -
1) if you are using "JOIN", you should use "ON" keyword to map tables
2) if networkinfo.cat egory is integer, then remove single quote (')
3) try using "AND" instead of "&&"Leave a comment:
-
this is probably the best solution for such a most commonly asked interview question ;)...Code:SELECT Top 1 Date,Other,Fields FROM ( SELECT Top 10 Date,Other,Fields FROM TheTable [B]ORDER BY Date DESC[/B] )aLeave a comment:
-
try..
Code:Environment.NewLine
Leave a comment:
-
low level keyboard hooking can be used in Winfoms not in Webfoms.. You have to use JavaScript..Leave a comment:
-
check this jquery text animation script
-- SwapnilLeave a comment:
-
No.. it does not help..
I have English (US) in browser settings.. but many times I write articles or feedback in Marathi / Hindi..
धन्यवाद... :)Leave a comment:
-
Yes. HTML is base of web technologies. try w3schools
- learn HTML and JavaScript before starting ASP.NETLeave a comment:
-
Security Exception while accessing XML file data
Hello,
I have hosted a website on GoDaddy.com. It's a share hosting. I am using XML file as a database. That means, I am reading and writing data into XML file instead of regular RDBMS (MySQL, MS SQL). I am reading XML data into DataSet and manipulate it and save the changes again to XML file.
It works fine on my local machine.. but not working on GoDaddy server.. I am getting security exception..
... -
difficult.. but you can track it with keycode.. check hereLeave a comment:
-
While googling I found one link, here it is.
Just google for ActiveX Articles.Leave a comment:
-
browsers do not have permissions to access client system.
you can achieve such tasks to some extend by using ActiveX, but again it's limited to IE browser.Leave a comment:
-
whats the column count of your datatable?Leave a comment:
-
I do not know much about MS Access, but, each database or programing language has Ceil and Floor functions..
Ceil - rounds value to upper value e.g. 302.5 => 303 and
Floor - rounds value to lower value e.g. 302.5 => 302
try to use it.. e.g
Code:Floor(12100/40) mands and (((12100/40) - Floor(12100/40)) * 40) kg
Leave a comment:
-
Thanks friends
I resolved the problem... I refered HTMLDivElement documentLeave a comment:
-
How to access an element inside innerHTML of a HTMLDivElement?
Hello,
I have a HTMLDivElement. I checked its innerHTML property.
It has a hidden element (in innerHTML).
How I can access the hidden element?
For example, fbPartnerName is the HTMLDivElement
it shows...Code:var fbPartnerName = document.getElementById("fbPartnerName"); alert(fbPartnerName.innerHTML);
...Code:<input value="Talon
-
..and thats done...!!! :)
just added Response.End();
thanks a million again Frinny.. :)Code:Response.ContentType = "application/json"; Response.Write(_jsonResult.ToString()); [B]Response.End();[/B]
- SwapnilLeave a comment:
No activity results to display
Leave a comment: