Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MadhanaGopal
  • Order by date
  1. MadhanaGopal

    Varchar vs Varchar2

    Hi, I am new to oracle and i am having the following basic doubt. 1.Differnce between Varchar and Varchar2 data types. ( As of my knowledge varchar is deprecated in oracle 9i and memory management is different btw varchar and varchar2.i am not sure about it) 2.Locking Mechanism in Oracle...
  2. MadhanaGopal

    Select Max count(*) problem

    Sorry Guys, I made one mistake.This is the correct query. select fld1 as col1 ,fld2 as col2,max(fld3) as col3 , count(fld4) as col4 from table1 group by fld1,fld2,fld4 It gives the result as col1 col2 col3 col4 ------------------------------------------ A B...
  3. MadhanaGopal

    better security?????

    Yes.It is looking a safe method.Make it as a MTS Component.Dont use it as a VB Exe. If u use this method,u must create a password decryption component in session_onstart. <SCRIPT LANGUAGE=VBScript RUNAT=Server> Sub Session_OnStart Set objpassdecrypt =...
  4. MadhanaGopal

    Select Max count(*) problem

    Hi, I have one requirement. select fld1 as col1 ,fld2 as col2,max(fld3) as col3 , count(*) as col4 from table1 group by fld1,fld2 It gives the result as col1 col2 col3 col4 ------------------------------------------ A B 25 5 A B...
  5. MadhanaGopal

    TIP: How to do a FileExists in SQLServer2000

    Thanx for this nice tip.I read one article from swynk.com we check the file existing thru sp_MSexists_file which is in master db. Instead of using Extended SP this one is better ,I think. ------------------------------------------------------------ This stored procedure can be used to...
  6. MadhanaGopal

    display weeks between 2 dates

    Hi, try this code snippit.it will satisfy ur requirement. set nocount on declare @startdate datetime, @enddate datetime set @startdate = convert(datetime,'03/12/2002') set @enddate = convert(datetime,'06/14/2002') create table #temp( weekdate datetime) while @startdate<=@enddate begin...
  7. MadhanaGopal

    better security?????

    If a hacker broke ur NT server, he can view any thing in ur system.After broken the NT Server,u cant do anything to protect viewing Global.asa. But u can encrypt asp and global.asa files using ASPEncrypt Component. Refer : http://www.aspencrypt.com P.Madhana Gopal, Principal Software Engineer...
  8. MadhanaGopal

    Hi, I hope someone here can help

    Add QTY_ORD-QTY_REC field in Group By Clause. Hope now it will run.Try the following query. SELECT PO_HEADER.ORDERNO, PO_HEADER.SUPPREF, PO_DETAIL.NON_STK_RF, PO_DETAIL.PART, Sum(PO_DETAIL.QTY_ORD), Sum(PO_DETAIL.QTY_REC), QTY_ORD-QTY_REC, PO_HEADER.SUPPLIER, SUPPLIER.SUP_NAME, PART.DESCR...
  9. MadhanaGopal

    hello, if my computer name is x

    It is from http://vyaskn.tripod.com/administration_faq.htm#top I think it may be useful to u. If you are running SQL Server 7.0, after renaming the SQL Server machine, the SQL Server service will fail to start, with an error message &quot;Your installation was corrupted or had been tampered...
  10. MadhanaGopal

    To find n th Maximum

    Hi Terry, your solution is used to acheived my Goal.But is there any possibility to write it in ANSI Standard?B'use Top is SQL Server Specific. P.Madhana Gopal, Principal Software Engineer, LCube Innovative Solns. Pvt. Ltd., India.
  11. MadhanaGopal

    To find n th Maximum

    In a following Table , Table : order Fields: order Id value i want to find the 'n' th maximum value of order using a single query. Thanx in Advance. P.Madhana Gopal, Principal Software Engineer, LCube Innovative Solns. Pvt. Ltd., India.
  12. MadhanaGopal

    Selecting first of a series

    Yes.u r correct.
  13. MadhanaGopal

    Selecting first of a series

    Hi Terry L. Broadbent I think there is no way to choose first entry of each image path.There is a function called Firstof and Lastof in Access.It fullfills the above requirement.There is no equallent function in SQL Server. Select ImagePath, ImageDescription=Min(ImageDescription) From...

Part and Inventory Search

Back
Top