...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,
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, 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
...> 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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.