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!

  • Congratulations Wanet Telecoms Ltd 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: jshanoo
  • Order by date
  1. jshanoo

    encrypting password

    Hi thanks it worked. Regards John *** Even the Best, did the Bad and Made the Best *** John Philip
  2. jshanoo

    encrypting password

    ...1)) ^ @XOR) SET @iPOS = @iPOS + 1 END END --If @Password parameter IS NULL THEN do nothing IF @Password IS NULL BEGIN SET @PasswordEncrypted = NULL END RETURN @PasswordEncrypted END *** Even the Best, did the Bad and Made the Best *** John...
  3. jshanoo

    encrypting password

    ...are filtering out the password. I want to know how to encrypt the password to avoid any misuse of login user and password. autoid LoginId lgpwd enable 1 admin admin No 2 john john No 3 sara sara No Best regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip
  4. jshanoo

    multiplying time value

    Hi Esqaure, Sorry for the late reply. Well the working hrs are fixed for employees. so it doesnt change. it is static value for us. *** Even the Best, did the Bad and Made the Best *** John Philip
  5. jshanoo

    multiplying time value

    ...cast(datediff(n, cast('0:00:01' as datetime),(convert(datetime,convert(datetime, (convert(float,convert(datetime,fulltime,108),108))*fulliro,108),108))) /60 as numeric(8)), datediff(n, cast('00:00:01' as datetime),(convert(datetime,convert(datetime...
  6. jshanoo

    multiplying time value

    ...work for 4:45 mts at any given point if i want to get the total man hours for the given day . i have calculate like teh following 08:00:00 * no. of employees 04:45:00 * no. of employees total of this will give man hours of the day. this is we do in excel. I want to put in sql and see...
  7. jshanoo

    multiplying time value

    ...datename(dw,A.currdatetime) as weekday, Fulliro as FullTime, PartIro as PartTime,(Fulliro+partiro) as TotalIro,(cast('08:00:00' as datetime) * 42) as a1, incnt as Landed,anscalls as Sucess,abancalls as Abandoned,failcalls as Failure from agents A,vwacdgrp B where A.currdatetime=B.acddt and...
  8. jshanoo

    multiplying time value

    Hi All, I need some output like lemme explain an employee min work hours are 8 hrs. like that 40 employee. i want the total work hours by multiplying both the fields. Can any one please help me. Regards John PHilip *** Even the Best, did the Bad and Made the Best *** John Philip
  9. jshanoo

    DISTINCT statement

    hi, distinct will reteive distinct fields u have specified. u have to do grouping thread183-848497 try this post. some one help me in this regard. If ur problem is solved post a star mark for him. Regards John philip *** Even the Best, did the Bad and Made the Best *** John Philip
  10. jshanoo

    SQL Query slowing down

    Hi, I have trie dur query its going more than 10-11 minutes regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip
  11. jshanoo

    SQL Query slowing down

    Hi, Distinct and max are needed to avoid duplicancy. The database is not at all normalized. I dont know much about indexex views can u please help me in that. mean time ia m working on the query sent by you. Regards John philip *** Even the Best, did the Bad and Made the Best *** John Philip
  12. jshanoo

    SQL Query slowing down

    HI, the data size i s huge, somwwhere around 5-6 lacs of records in both tables '------------------------- vwfeedback SELECT DISTINCT * FROM dbo.feedback vwuniqueclass SELECT code, MAX(name) AS name FROM dbo.class GROUP BY code Regards John *** Even the Best, did the Bad...
  13. jshanoo

    SQL Query slowing down

    ...B where A.code=b.class and A.name >= 'CAR-MARUTI BALENO' and A.name <= 'COMPUTER-UNIQUE' and (B.date between '03/03/2004' and '06/03/2004') order by b.date,b.time '---------------------------------------------------- *** Even the Best, did the Bad and Made the Best *** John Philip
  14. jshanoo

    eliminate duplicate records

    hi swamp boogie, Eureka. i made it. Regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip
  15. jshanoo

    eliminate duplicate records

    hi, Sorry for the late reply. This will not give me teh required result, it will be same as that of rceords. duplication i shappening only with code not with name. so distinct will not work Regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip
  16. jshanoo

    MSgraph

    ...of the row is 800, but myu graph is showing 1200 and more. Is there any problem with the graph control. i have printed the data value, it is passed correctly, i dont know where the change is happeniing. Best Regards John philip *** Even the Best, did the Bad and Made the Best *** John Philip
  17. jshanoo

    eliminate duplicate records

    ...258759 BASF-COMPUTER CDR W 258760 COMPUTER FLOPPY BOX-SONY 258760 SONY-COMPUTER FLOPPY BOX *** Even the Best, did the Bad and Made the Best *** John Philip
  18. jshanoo

    Filter Records

    hi, But this statement will not work in sql server. Regards john philip *** Even the Best, did the Bad and Made the Best *** John Philip
  19. jshanoo

    Filter Records

    ...> 0 order by contract----------------------------------------------- i want to filter according to 'status' field only records with status='Active' has to be displayed can any one please help me in this Regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip
  20. jshanoo

    MS Chart - Data Value Display

    Hi , I have made the Graph for the report . Graph is Displaying fine. Now i want one more addition to the same, i want the values be displayed also Can anyone have some input to this. Regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip

Part and Inventory Search

Back
Top