Search results for query: *

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

...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...

...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

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

...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...

...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...

...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...

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

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

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

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

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...

...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

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

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

...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

...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

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

...> 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

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