Hi,
I have created the function , but it is not executing
it gives the following error message
'------------------------------------------
Server: Msg 195, Level 15, State 10, Line 1
'EncryptPassword' is not a recognized function name.
'-----------------------
regards
John Philip...
Hi all,
Please find my table named 'login'
i have somewhere around 150 users active at any given point of time. presently i am using text datatype and storing the user login and password [lgpwd is password field].
4-5 more people access the database and they are filtering out the password.
I...
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
HI SQL sis,
I got ur point that is very a good idea
i worked around some sql query and it came out like this.
but i can see one hour is always less in the total
sample records are given below
--------------------------------------
Select currdatetime,fulliro,partiro,
cast(datediff(n...
Hi all,
Sorry all well i think i was not clear with my post.
Let me explain the situation.
there are employess full time & part time
Full time work for 8 hrs and part timers 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...
Hi,
following is my sql query '08:00:00 is static, 42 will vary means a filed will come there.
---------------------
Select convert(varchar,A.currdatetime,101) as CallDate, datename(dw,A.currdatetime) as weekday,
Fulliro as FullTime, PartIro as PartTime,(Fulliro+partiro) as...
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...
Hi,
I have the following query , it is consuming more than 6 mts to retieve the result, i want to make it faster retrieval.
Query is fetching results from views , which in turn consists fetches only distint records.
Due to the non-unique feature of the data, i cannot relate the table with the...
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
I am using a MSgraph to show soem data in graph.
it has two columsn and one row. max value in any 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...
HIi all,
Please find thee sql stmt:
'Select code,Name from class
order by code'
In resultset i get dupliacte records
only the code is duplicating the name field is different.
i want keep only one record of the two; if code '4' has two records then i need only one of them. so the code field is...
Hi all,
Please see my SQl stmt
-------------------------------------------------
Select contract,company,from_date,pin,feedback,
cast(feedback as datetime) as a2,
'Status' =
CASE
WHEN cast(feedback as datetime)> getdate() THEN 'Active'
WHEN cast(feedback as datetime)...
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.