nithinmohant : and you can use ASC or DESC accordingly
nithinmohant : SELECT * FROM dbo.RawOrdersData ORDER BY DAY(Import_Date) ,MONTH(Import_Date),Year(Import_Date)
kalikoi : order by month(strdate)
kumar : but it is taking according to the day but i need to have according to date and month
kumar : i want to write a query order by date
kumar : hi
Ramachandra : Thanks Friends
kalikoi : sstr=str.split('/')[1]
kalikoi : str="12/03/2010"
srinivasg : also u can use substring in .net
singam : in sql u can use this select datepart(mm,getdate())
kumar : how can i get that
kumar : if i have 12/03/2010 as varchar then i need 03
kumar : can any one tell me how can i get only two from varchar
kumar : hi frds
chinni1205 : When to use:
Response.Redirect is perfect when your page is temporarily changed and will be changed to original within a short span of time.
Response.RedirectParmanent() when you are thinking of deleting the Page1 totally after the search engines changes its cache.
Server.Transfer() when you are thinking of keeping the page for ever, and to let search engine unaware of this redirection.
chinni1205 : Response.Redirect permanent and server.Transfer
chinni1205 : Heay frnds i have the answwer i.e
chinni1205 : thanks in Advacne
chinni1205 : Hi Frnd do u have any idea the difference b/w Response.Redirect permanent and server.Transfer
srinivasg : Thanks..
srinivasg : HI all.. GA
kaustavm : Thanks guys ..
SaradhiGolla : Congratulations Kaustav, Ram and Srinivas...
satishkamuju : Good Morning Everybody
Lalitha : Congrtas kaustav,ramachandra and srinivas
yoursbangaru : Applaud to Kaustav,RamaChandra Reddy & Srinivas
kiran3010p : Good Morning
kiran3010p : Hi Friends,
Geethika : Answer today's quiz and become Tech star for tomorow.. All the best.. Check this link «link»
Ramachandra : GM to all
Ramachandra : Congrats Kaustav Kumar Mishra
dayasagar : hi good Morning to all techies
harshitha : Congrats Kaustav !!!!!!!!!!!
venkatp : congrats Kaustav Kumar Mishra
Geethika : Congrats to Kaustav Kumar Mishra..Tech Star of the day :):)
venkatp : hi good morning to all techies
kannaiahgari : hi friends any one working on infopath and sharepoint
Rani : gud eveng guys....
SaradhiGolla : any one who r working in BTS/
Geethika : Take up today's quiz for Tech Star ..«link» ... Answer Now .. Only 4 days to go.. You got a chance to win many points spending just few minuites
kiran3010p : Hi Friends
starwish83 : hi good aftrnn
shashwatrish : hii all good afternoon
srinivasg : Hi all,Good afternoon
meetdine : Hi nag chakri, I have uploaded the document
chandu : congrats to TechStar for day 1
yoursbangaru : Good Morning All
dayasagar : Good Morning to all
nag_chakri : Windows server 2003
meetdine : what's the OS u have on ur systen?
meetdine : Just planning to upload it
meetdine : I will
meetdine : yeah sure
nag_chakri : Hi Dinesh,Could you please send me the document
Geethika : Check out this link and reply «link» tech star
harshitha : Congrats Bala Prasad Peddigari
meetdine : Ok, I will post the document regarding permissons on excel
meetdine : Hi, u need to give the permission for excel obj for asp_net use
nag_chakri : any help on this?
nag_chakri : i am getting "System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005" error
nag_chakri : I am using Excelobject in my application
nag_chakri : Good Morning
nag_chakri : Hi Friends
venkatp : congrats BALA PRASAD PEDDIGARI
venkatp : hi good morning to all techies
Geethika : Check out this link to find Day2 Questions and Day 1 Answers.. Answer quickly.. «link»
Geethika : Check out this «link» to find TECH STAR of the Day,WInner and runner.. Tech Star of the day BALA PRASAD PEDDIGARI
harshitha : if u need any info reg site feel free to ask
srinivasg : Hi Harshitha.. thanks
harshitha : hi srinivas welcome to our site
srinivasg : Hi friends.. .i am a new joinee..
srinivasg : Happy women's day..
kiran3010p : Hi frndz
Geethika : Post your answers in comments section itself and get recognised.. «link»
Geethika : Answer the questions here «link» and be a Tech Star.. Answers should be short and simple..
dayasagar : A Mans got to do what a mans got to do. A woman must do what he cant. Wishing you a Happy womans Day
Geethika : Let’ take pride in being a woman, and lets rock..Happy Women's day and Thanks to all the Gentlemen for making us feel empowered and feel proud of being a woman.
shashwatrish : happy women's day to all techies where techies = girl
yoursbangaru : Happy Women's Day
nithinmohant : Hey forgot Happy Womens day to all Women Techies here...
yoursbangaru : W-wisdom,O-origin,M-Motherhood,E-Education,N-Nector all these Constitutes WOMEN-God Should Not Be Every Where That is Y He Created Women
chinni1205 : any ways says thnks to harshita(all women)
chinni1205 : after my message only ur wishing to Our frnds..its too much
chinni1205 : Oay harshitha
harshitha : HAPPY WOMEN'S DAY
harshitha : hi check this link for tech five stars «link»
kannaiahgari : hi all where to get the questions for the 5 star tech
anilmca11 : Good Morning Techie Friends
yoursbangaru : hi Gud Morning All
venkatp : hi good morning to all
Geethika : Post Your answers as comment in the article.. «link» be active and become Tech Star of the day...
dayasagar : hi gm to all
nithinmohant : how to post the answer
nithinmohant : Good morning guyz..
Geethika : Take up the Quiz now..Check Tech FIVE STARS article...
Geethika : Tech 5-Stars @ Hyderabadtechies...Starts from tomorrow..Keep in touch to checkout details ..
nithinmohant : hello chandu jai tech hyderabad?
nithinmohant : good after noon guyz. jst powercut over...
chandu : Jai Tech Hyderabad
dumpalpr : hello all, good evening. i am looking for some help on entityframework
chandu : good evening friends
Geethika : Hi techies... Good Evening
kiran3010p : Hello Friends
surender : GOOD AFTERNOON FRIENDS
rai1manish : Hi All, Very goog afternoon......
suriya : no activities on site apart from job forum activeness
chandu : good morning friends.
satyaanandan : Hi Good Morning All Techies
susi : hi techies good morning
starwish83 : good morning u all
nithinmohant : good morning all..
poorna : Hi Friends, Good Morning
kumar_pbv : Wish you a happy weekend all....
chandu : Happy Week end
naani666 : hi techies happy weekend
kiran3010p : Hi frndz,
Good Afternoon
starwish83 : gud aftnn
rai1manish : Hello all, good morning
chandu : Good Afternoon
satishkamuju : very good morning harshitha
harshitha : gm satish
shashwatrish : good morning techies ...
satishkamuju : Good Morning Evereybody
harshitha : hi gm all
sureshprasu : Hi Good Morning To All Tech Members
venkatp : hi good morning to all
yoursbangaru : hi Good Morning All
kiran.koyela : good morning
susi : hi Good mrng to All techies
bhasker2421 : any body can provide me samples if u have
bhasker2421 : can any body tell me : how do i use silverlight class library into my asp.net webapplication
bhasker2421 : here i have one query
bhasker2421 : Hi my dear friends
nobleseba : bye..
chinni1205 : Pls respond from private window
chinni1205 : Hello Harishita are u there?
nobleseba : what is sp_reset_connection..?How could we reduce the execution time...?
brijeshmaniy : ok
harshitha : hi brijesh we are in the process of selecting we will declare as soon as we finish
brijeshmaniy : harshitha r u there
brijeshmaniy : who won the best article award last month?
kiran3010p : HI Friendz
harshitha : hi anjibabu u have submit article option under techies check in
Anjibabu : how to write article ?
Anjibabu : hi
sureshprasu : Hi Bangaru
yoursbangaru : Hi Suresh
sureshprasu : Good Morning To all
Ramachandra : Hi to All
anilmca11 : Good Morning Techie Friends
dayasagar : hi Good mrng to All techies
venkatp : hi good morning friends
yoursbangaru : Hi Goog Morning All
Anjibabu : hi all
rai1manish : Hi guys
suriya : this link I posted in forum, but harshita says its not visible hence pasted here
suriya : Hyd air plane crash video taken by me Live -«link»