Search results for query: *

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

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

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

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, But this statement will not work in sql server. Regards john philip *** Even the Best, did the Bad and Made the Best *** John Philip

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