Comments by Member 10501509

Member 10501509 17-Oct-14 3:50am View

I have winrar software in my computer

Member 10501509 17-Oct-14 3:21am View

I am downloading pgbadger and epqa winrar file.what to do with winrar files.

Member 10501509 15-Oct-14 9:31am View

We dont have sqlprofiler

Member 10501509 15-Oct-14 9:31am View

i am using pgadmin

Member 10501509 15-Oct-14 9:15am View

sample input for store procedure
select * from sp_ecp_ledger_patient_statement_aging('0074690845',null,6070, '2014-10-01 09:30:00', '2014-11-01 09:29:59', '2014-09-01 09:30:00' ,'2014-10-01 09:29:59',
'2014-08-01 09:30:00', '2014-09-01 09:29:59', '2014-07-01 09:30:00', '2014-08-01 09:29:59')

Member 10501509 30-Apr-14 14:00pm View

I am getting skills column null

Member 10501509 30-Apr-14 13:56pm View

can use pivot and can you give solution

Member 10501509 30-Apr-14 13:35pm View

there relation between TM_Specialization and Reference
Specialization=Lookupvalue where Reference.lookupkey='Platform'

Member 10501509 30-Apr-14 13:32pm View

With relation we cant write query? ,please find alternate solution

Member 10501509 30-Apr-14 13:31pm View

There is no relation TM_Profile and Reference.

Member 10501509 30-Apr-14 13:27pm View

i should get sample out put by using above tables.
Profile platform skills 
DB Developer Database Derby aka Java DB 
Software engg Java Eclipse 
Software engg Java Jasper 
Software engg DOT NET ASP.NET 2010 
Software engg DOT NET c# 3.0

Member 10501509 30-Apr-14 13:04pm View

Please help me to get solution for problem

Member 10501509 30-Apr-14 13:03pm View

Relation is there b/w TM_Profile/TM_Specialization and Reference/Reference_Skills u can see in the above tables

Member 10501509 30-Apr-14 13:00pm View

sample out put
Profile platform skills
DB Developer Database Derby aka Java DB
Software engg Java Eclipse
Software engg Java Jasper
Software engg DOT NET ASP.NET 2010
Software engg DOT NET c# 3.0

Member 10501509 30-Apr-14 12:55pm View

use four table to produce the result.

Member 10501509 30-Apr-14 12:54pm View

Did u understand my problem now

Member 10501509 30-Apr-14 12:52pm View

TM_profile table linked with TM_Specialization ( TM_profile.profileid=TM_Specialization .profileid)
Reference table is linked with Reference_Skills(Reference.LookupID=Reference_Skills.SkillLookupKey)

Member 10501509 30-Apr-14 12:44pm View

please execute the above schema and data in ur local system so that u can understand very easly.

Member 10501509 30-Apr-14 12:39pm View

please take ur own time

Member 10501509 30-Apr-14 12:36pm View

I have given four table structure

Member 10501509 30-Apr-14 12:36pm View

execute above table structure and data in ur local system

Member 10501509 30-Apr-14 12:20pm View

i am not getting it please help me

Member 10501509 30-Apr-14 11:47am View

please me give solution its very urgent

Member 10501509 30-Apr-14 11:24am View

i have fetched data for one profile please u can see in above output. similarly i want to fetch for all profiles.

Member 10501509 30-Apr-14 11:23am View

i want to fetch data for each profile -->platfrom and skills

Member 10501509 30-Apr-14 7:08am View

how to send images which u send me

Member 10501509 30-Apr-14 6:48am View

Which details please be clear

Member 10501509 30-Apr-14 6:05am View

Please give solution as quickly as posible

Member 10501509 30-Apr-14 6:04am View

I have give four table structure

Member 10501509 30-Apr-14 5:16am View

Its very Urgent

Member 10501509 30-Apr-14 5:16am View

Execepted Output
Profile Specialization Reference_Skills.SkillLookupValue as skill
Database deve MSSQL Microsoft SQL Server 2005

Member 10501509 30-Apr-14 2:59am View

Excepted output
profile platfrom skills
DB Developer Database Microsoft SQL Server 2005
Software engg DOT NET ADO.NET Entity FrameWork

Member 10501509 30-Apr-14 2:53am View

like this i am getting out put

profile platfrom skills 
Admin Database Microsoft SQL Server 2005 
Admin DOT NET ADO.NET Entity FrameWork 
Admin DOT NET ASP.NET 2012 
Admin DOT NET ASP.NET AJAX 
Admin DOT NET c# 3.5

Member 10501509 9-Apr-14 4:19am View

yes ur correct please give me solution quickly.

Member 10501509 9-Apr-14 4:14am View

for one profile i am having many Specialization those Specialization should be separated by comma .

execpted output

profile Specialization
Softwarengg .net,java,php

Member 10501509 9-Apr-14 3:59am View

Deleted

instead of profile in condition we any other option to fetch all profile and their Specialization

Member 10501509 9-Apr-14 3:58am View

Deleted

while selecting the data i should no do hard codeing for profiles

Member 10501509 9-Apr-14 3:47am View

Deleted

I should not do hard codeing for profiles

Member 10501509 9-Apr-14 3:28am View

Deleted

for above code i am getting output like this ,how to fetch for all profiles without hard coadeing profile
Profile Specialization
Software Engineer .NET, Java, VC++, SharePoint, SAP, Android , Scala, ROR, iPhone,

Member 10501509 9-Apr-14 3:25am View

Deleted

i have many profiles ,i want to fetch data for all profiles.

Member 10501509 9-Apr-14 2:55am View

Deleted

output i am getting

Profile Specialization
Software Engineer <specialization>.NET,<specialization>Java,<specialization>Admin,<specialization>Java,<specialization>PM,<specialization>C++,<specialization>C Language,<specialization>SQL,<specialization>Apps,<specialization>Accounts,<specialization>HR,<specialization>Systems Engineer,<specialization>.Net,<specialization>VC++,<specialization>SharePoint,<specialization>JAVA,<specialization>QA,<specialization>.NET,<specialization>VC++,<specialization>LAMP,<specialization>Sharepoint,<specialization>.NET,<specialization>JAVA,<specialization>LAMP,<specialization>WAMP,<specialization>iOS,<specialization>Android,<specialization>Sharepoint,<specialization>DB,<specialization>BOXI,<specialization>QA,<specialization>VC++,<specialization>Network Operations,<specialization>IT,<specialization>HR,<specialization>VC++,<specialization>SharePoint,<specialization>Sr. Systems Engineer,<specialization>Technical Lead,<specialization>Admin,<specialization>SAP,<specialization>ROR,<specialization>Inside Sales,<specialization>Marketing,<specialization>Inside Sales,<specialization>Pre Sales,<specialization>Research,<specialization>JAVA,<specialization>.Net,<specialization>Sr. Network Engineer,<specialization>Network Engineer,<specialization>Oracle,<specialization>Android ,<specialization>Android,<specialization>Process Management,<specialization>SCALA,<specialization>.NET,<specialization>JAVA,<specialization>Sharepoint,<specialization>Administrator,<specialization>Sr. Administrator,<specialization>Scala,<specialization>Trainee Engineer,<specialization>ROR,<specialization>Dot Net,<specialization>Sharepoint,<specialization>iPhone,<specialization>MSSQL,<specialization>Operations,<specialization>Network,<specialization>DB,<specialization>DBA,<specialization>IT Administration,<specialization>PHP,<specialization>PHP,<specialization>Content Writer,<specialization>Front Office,<specialization>Manager
Software Engineer <specialization>.NET,<specialization>Java,<specialization>Admin,<specialization>Java,<specialization>PM,<specialization>C++,<specialization>C Language,<specialization>SQL,<specialization>Apps,<specialization>Accounts,<specialization>HR,<specialization>Systems Engineer,<specialization>.Net,<specialization>VC++,<specialization>SharePoint,<specialization>JAVA,<specialization>QA,<specialization>.NET

Member 10501509 7-Apr-14 7:35am View

Deleted

nobody can solve this problem?

Member 10501509 7-Apr-14 6:44am View

Deleted

excepted output
TM_UserID FullName 2014-04-04 00:00:00.000
142 Lakshmidevi Banyala 12

Member 10501509 7-Apr-14 6:43am View

Deleted

I am getting out like this
TM_UserID FullName worked_dte worked_hrs
142 Lakshmidevi Banyala 2014-04-04 00:00:00.000 12

Member 10501509 24-Mar-14 5:04am View

Deleted

output i am getting
FullName task_name
Chandu Devathi new task 2222
Chandu Devathi TESST ePROM copy
Chandu Devathi Testing plz ignore.
Harish Kumar Ramakrishnappa TESST ePROM copy

Member 10501509 24-Mar-14 4:27am View

Deleted

see in above sample output two person having same task i want that two person seperated by comma.

Member 10501509 24-Mar-14 4:27am View

Deleted

sample out put
TM_UserID FullName Report_To project_name task_name
106 Chandu Devathi 13 222 new task 2222
106 Chandu Devathi 13 ePROM TESST ePROM copy
106 Chandu Devathi 13 ePROM Testing plz ignore.
409 Harish Kumar Ramakrishnappa 13 ePROM TESST ePROM copy

Member 10501509 18-Mar-14 9:41am View

after this if(@action='u') then what should i write can you give sample code.

Member 10501509 5-Mar-14 7:25am View

help any one how do

Member 10501509 5-Mar-14 7:07am View

Not help full plz can give me code

Member 10501509 5-Mar-14 6:45am View

no
311 Aditya Mahapatro 05 Mar 2014 is Absentee for this date
560 Aishwarya Shekar 05 Mar 2014,06 Mar 2014 is Absentee for this for two date
i want to combine Absentee dates with comma if user have more than one Absentee date.

Member 10501509 5-Mar-14 6:43am View

no
311 Aditya Mahapatro 05 Mar 2014 is Absentee for this date
560 Aishwarya Shekar 05 Mar 2014,06 Mar 2014 is Absentee for this for two date

Member 10501509 5-Mar-14 6:07am View

where should i implement above code

Member 10501509 5-Mar-14 5:37am View

Excepted output
311 Aditya Mahapatro 05 Mar 2014,06 Mar 2014
560 Aishwarya Shekar 05 Mar 2014,06 Mar 2014

Member 10501509 5-Mar-14 5:36am View

Deleted

output i am getting
311 Aditya Mahapatro 06 Mar 2014
311 Aditya Mahapatro 05 Mar 2014
560 Aishwarya Shekar 05 Mar 2014
560 Aishwarya Shekar 06 Mar 2014

Member 10501509 4-Mar-14 0:04am View

you can see the problem for every employee i am getting 2 hrs 09 min

Member 10501509 27-Feb-14 4:57am View

Please any one give solution for the above problem

Member 10501509 27-Feb-14 4:18am View

getting output like this
employeeid fullname WorkedHours
81 Kishore Alla 2 Hrs:09 Min
88 Karthik Ayinala 2 Hrs:09 Min
97 Nagajayanth Bussa 2 Hrs:09 Min
128 Anil Keethepalli 2 Hrs:09 Min
190 Alekhya Chunchu 2 Hrs:09 Min
311 Aditya Mahapatro 2 Hrs:09 Min
401 Alekhya Katuri 2 Hrs:09 Min
407 Saratchandra Rajkiran 2 Hrs:09 Min
409 Harish Kumar Ramakrishnappa 2 Hrs:09 Min
447 Abhilash Nair 2 Hrs:09 Min
560 Aishwarya Shekar 2 Hrs:09 Min

Member 10501509 26-Feb-14 23:11pm View

Thank you

Member 10501509 26-Feb-14 3:19am View

i am getting these errors
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '('.
Msg 1087, Level 15, State 2, Line 12
Must declare the table variable "@TempTable".
Msg 1087, Level 15, State 2, Line 22
Must declare the table variable "@TempTable".

Member 10501509 25-Feb-14 23:14pm View

I am unable to do please provide a query to me.

Member 10501509 25-Feb-14 23:09pm View

Please can you provide a query .

Member 10501509 25-Feb-14 9:26am View

i am using different tables one is Employee_Attendance and TM_User that checktime is in Employee_Attendance

Member 10501509 25-Feb-14 9:22am View

see in excepted output each user is absent for particular date that i want to display if i give between date range ,i mean to say date should be loop until the end date .

Member 10501509 25-Feb-14 9:20am View

excepted output
16 Erappa Amanda 2014-02-20 00:00:00.000
25 Madhusudhan Rollapati 2014-02-21 00:00:00.000
27 Maruthi Krishnappagari 2014-02-22 00:00:00.000

Member 10501509 25-Feb-14 9:15am View

even want to display particular absentees date for user also

Member 10501509 25-Feb-14 8:58am View

if i use between it will display absentees between the date range

Member 10501509 25-Feb-14 8:14am View

set @attendance_date in between range

Member 10501509 25-Feb-14 7:23am View

from this i will get absentees list for then i need absentees date also

Member 10501509 20-Feb-14 7:13am View

actually i am finding absentees for particular date

Member 10501509 20-Feb-14 7:12am View

actually i am finding absentees for particular date

Member 10501509 20-Feb-14 7:12am View

i am not getting any records for that date

Member 10501509 12-Feb-14 6:48am View

give me any solution

Member 10501509 12-Feb-14 6:43am View

see the question now

Member 10501509 12-Feb-14 6:26am View

its very urgent

Member 10501509 10-Feb-14 6:10am View

the exepeted output should be
FullName (No column name) ActionType
ALEKYA 2014-05-10 00:00:00.000 i
deepthi 2014-01-22 16:43:33.937 O

Member 10501509 10-Feb-14 6:09am View

the output getting for me
FullNam (No column name) ActionType
ALEKYA 2014-05-10 00:00:00.000 i
ALEKYA 2014-05-06 00:00:00.000 o
deepthi 2014-01-22 16:25:52.600 I
deepthi 2014-01-22 16:43:33.937 O

Member 10501509 16-Jan-14 3:41am View

i am getting this error when i execute the above query :-A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Member 10501509 16-Jan-14 3:41am View

Deleted

i am getting this error when i execute the above query :-A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Member 10501509 16-Jan-14 2:27am View

can any one modify the query to get the result

Member 10501509 13-Jan-14 3:00am View

parent

Member 10501509 13-Jan-14 2:55am View

you correct for single profileID every time will pass different profileIDs for that i need query by using if or case

Member 10501509 13-Jan-14 2:52am View

profileID

Member 10501509 13-Jan-14 2:52am View

ProfileID

Member 10501509 13-Jan-14 2:51am View

if ProfileID=2379 then display remaining ProfileID

Member 10501509 13-Jan-14 2:50am View

if ProfileID=2379 then display remaining ProfileID

Member 10501509 13-Jan-14 2:48am View

By using profileID s

Member 10501509 13-Jan-14 2:43am View

By using profileID s

Member 10501509 13-Jan-14 2:27am View

if profile='software engg' then display higher profile than software engg

Member 10501509 9-Jan-14 0:16am View

Deleted

i have tried that also ,can u rewrite query to fetch all users records.

Member 10501509 9-Jan-14 0:05am View

for single user i will get correct records but all for users only i am getting problem.

Member 10501509 9-Jan-14 0:02am View

yes can you filter for all users

Member 10501509 9-Jan-14 0:01am View

Deleted

i have checked by removing even though i will get correct records

Member 10501509 8-Jan-14 23:59pm View

if i remove TM_user.TM_UserID =13 i will not get correct records

Member 10501509 8-Jan-14 7:30am View

if remove TM_User.TM_UserID=13 also above i have used same TM_User.TM_UserID=13 so i am getting that user records only

Member 10501509 8-Jan-14 7:27am View

Deleted

can any one modify the above query to fetch all users data.

Member 10501509 5-Jan-14 23:47pm View

out put
FullName Profile Report_To platform skills project_name task_name
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql Common Pool DB Dev Training
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql ePROM ePROM Database changes
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql ePROM ePROM DB changes for 1.6.4
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql ePROM ePROM DBA
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql Recreational Activities Effone Premier League
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql Recreational Activities Pygmalian Club
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql Training Holding Hands
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql Training Linux Training Session Batch I
Harish Kumar Ramakrishnappa Trainee 13 Database Microsoft SQL Server 2005, Mysql Training Operating System
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C Common Pool DB Dev Training
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C ePROM ePROM Database changes
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C ePROM ePROM DB changes for 1.6.4
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C ePROM ePROM DBA
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C Recreational Activities Effone Premier League
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C Recreational Activities Pygmalian Club
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C Training Holding Hands
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C Training Linux Training Session Batch I
Harish Kumar Ramakrishnappa Trainee 13 Programming Languages C Training Operating System
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing Common Pool DB Dev Training
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing ePROM ePROM Database changes
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing ePROM ePROM DB changes for 1.6.4
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing ePROM ePROM DBA
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing Recreational Activities Effone Premier League
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing Recreational Activities Pygmalian Club
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing Training Holding Hands
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing Training Linux Training Session Batch I
Harish Kumar Ramakrishnappa Trainee 13 Software Testing Manual Testing Training Operating System

Member 10501509 3-Jan-14 9:38am View

The multi-part identifier "project.project_id" could not be bound.

Comments by Member 10501509 (Top 98 by date)