Comments by Member 10256268

Member 10256268 4-Sep-17 18:06pm View

Deleted

Is there any other way to solve above issue.

Member 10256268 4-Sep-17 16:40pm View

Deleted

All host name is correct only. i need to use only host.

Member 10256268 2-Aug-17 6:45am View

Deleted

Yes, datatype is varchar.

Member 10256268 2-Aug-17 6:32am View

Deleted

I have loaded csv file , and data entered like this 21-02-2016
02-21-2016, so i want to change it.

Member 10256268 1-Jun-17 23:10pm View

Thanks.

Member 10256268 13-Oct-15 3:22am View

I think nobody knows the answer for above question ,can i close the question ?

Member 10256268 6-Aug-15 3:58am View

what input data you need

Member 10256268 6-Aug-15 3:22am View

i have posted sample output.

Member 10256268 12-May-15 8:02am View

I have braked the query and i have checked main query will give eCPClaim_total_claim_charge=60.06 and sub query result is 60.06 so now 60.06 > 60.06 is false so i shouldn't get the record if i execute the above query.

Member 10256268 13-Jan-15 3:58am View

can you modify query please.

Member 10256268 13-Jan-15 3:51am View

Can give example , i am not getting what you said

Member 10256268 26-Dec-14 4:26am View

I have read above document but i am not understanding bec all the words are too technical.

Member 10256268 24-Dec-14 1:09am View

I think no body knows above question and then what is the use of this site.

Member 10256268 22-Dec-14 2:21am View

what is the use of pg_basebackup ?

Member 10256268 15-Dec-14 22:52pm View

I dont know how to code for above question. even i dont have sample code also for above question.

Member 10256268 10-Dec-14 3:17am View

if i execute your query i am getting this erro function isnull(double precision, integer) does not exist

Member 10256268 4-Dec-14 8:35am View

convert sub query in to any join by using sub query columns.

Member 10256268 4-Dec-14 8:31am View

sub query is taking time i want to reduce the time.

Member 10256268 4-Dec-14 8:25am View

Are you working on the above question.

Member 10256268 4-Dec-14 8:17am View

yes

Member 10256268 4-Dec-14 8:17am View

sub query taking time i want to replace sub query with any joins by using same columns which is present in above query.

Member 10256268 4-Dec-14 8:15am View

i want to reduce sub querys with any joins.

Member 10256268 4-Dec-14 8:07am View

Deleted

i need same query with different logic

Member 10256268 4-Dec-14 8:06am View

No i have created new question.

Member 10256268 4-Dec-14 8:05am View

Deleted

its not repost i have created new question.

Member 10256268 4-Dec-14 7:51am View

I want to re write sub query in above query.Please help me in that.

Member 10256268 1-Dec-14 23:22pm View

Can you give me query by removing sub query and apply left join or inner join for above query.

Member 10256268 24-Nov-14 6:01am View

Deleted

Thanks for your advice

Member 10256268 24-Nov-14 5:59am View

Deleted

Thanks

Member 10256268 24-Nov-14 5:51am View

i dont know sql so asked.

Member 10256268 16-Dec-13 2:42am View

used data type decmail(5,2) for worked_dte column

Member 10256268 16-Dec-13 2:38am View

i have sumed this 1.30
3.30
1.00
2.00 hours finally i am getting 7.60 hours it shoulds come 8.00 na

Member 10256268 16-Dec-13 2:35am View

Deleted

out put
user_id worked_hrs worked_dte
106 7.60 2013-11-11 00:00:00.000
execpted output
user_id worked_hrs worked_dte
106 8.oo 2013-11-11 00:00:00.000

Member 10256268 29-Nov-13 1:16am View

final output should be like this
user_id worked_hrs worked_dte leave_hour
106 8.00 2011-06-13 NULL

Member 10256268 12-Nov-13 4:27am View

its very urgent.

Member 10256268 12-Nov-13 4:27am View

any one can solve this query .

Member 10256268 12-Nov-13 2:21am View

any help me

Member 10256268 12-Nov-13 2:12am View

the execpted out is like this

13 Deepti Injeti DOT NET ,Database ASP.NET2005,MicrosoftSQL Server 2008

Member 10256268 12-Nov-13 1:57am View

outpu is

13 Deepti Injeti DOT NET ASP.NET 2003, ASP.NET 2005
13 Deepti Injeti Databases Microsoft SQL Server 2008
the execpted out is like this

13 Deepti Injeti DOT NET ,Database ASP.NET2005,MicrosoftSQL Server 2008

Member 10256268 7-Nov-13 23:49pm View

The execepted output
url path
www "file:///C:/Documents%20and%20Settings/harish.kumar/Desktop/images.jpeg"

like above i have to display

Member 10256268 29-Oct-13 6:13am View

i am getting error near case

Member 10256268 29-Oct-13 6:02am View

Deleted

convert this query to ms access query.

Member 10256268 22-Oct-13 5:17am View

if user cancel leave and again if he eneter date for leave its not inserting into table how to solve this issue.

Member 10256268 22-Oct-13 4:59am View

now full code is uploaded.

Member 10256268 22-Oct-13 4:58am View

any one help me in this.

Member 10256268 22-Oct-13 4:57am View

This is not working.

Member 10256268 22-Oct-13 4:55am View

what did u change in this code
same issue is coming.

Member 10256268 22-Oct-13 4:47am View

expted output after user cancel leave if he apply leave for sme date or other date the dates should insert into table.

Member 10256268 22-Oct-13 4:46am View

date range work when leave_stauts=null
if user update user_leave_type to 1 if user again insert dates between range it is not inserting in to table.it showing already dates are present

Member 10256268 21-Oct-13 2:38am View

execpted output:

frist i will take leave between two date ie (10/10/2012 to 15/10/2012) if i enter between date i should get already u have applied for these date .how to do that

Member 10256268 21-Oct-13 2:29am View

frist i will take leave between two date ie (10/10/2012 to 15/10/2012) if i enter between date i should get already u have applied for these date .how to do that

Member 10256268 21-Oct-13 2:25am View

the problem is if i enter dates again its enetering into table.how to solve this problem

Member 10256268 10-Oct-13 5:38am View

ok thank u i will work 1st

Member 10256268 10-Oct-13 5:33am View

can u plz suggest the correct forum.

Member 10256268 3-Oct-13 8:07am View

where should i change

Member 10256268 3-Oct-13 7:59am View

change in sp and post the code plz

Member 10256268 3-Oct-13 7:50am View

yes

Member 10256268 3-Oct-13 7:48am View

display only 0 after that dont diaplay any value

Member 10256268 3-Oct-13 7:48am View

in that 0.0 how to remove .0

Member 10256268 3-Oct-13 7:43am View

in output count_days column displaying 0.0 i want to remove the value after point symbol

Member 10256268 3-Oct-13 7:42am View

in output count_days column displaying 0.0 i want to remove the value after point symbol

Member 10256268 3-Oct-13 7:35am View

executed out put is
count_days
0
0
0 like this i want to display

Member 10256268 1-Oct-13 5:26am View

i want retrieve one table from mdb plus how to do that.

Member 10256268 1-Oct-13 5:25am View

i want retrieve one table from mdb plus how to that.

Member 10256268 1-Oct-13 5:22am View

i want to retrieve one table from mdb plus viwer into sql serveris it possible.

Member 10256268 1-Oct-13 5:20am View

same like this i can show data which is present in mdb puls.

Member 10256268 1-Oct-13 5:20am View

same like this i can show data which is present in mdb puls.

Member 10256268 1-Oct-13 5:07am View

please any one can explain what the above code will do.

Member 10256268 30-Sep-13 6:10am View

but i am getting this error :Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider...

Member 10256268 30-Sep-13 6:05am View

i am getting this error :Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

Member 10256268 25-Sep-13 8:20am View

Thank u so much kirill

Member 10256268 24-Sep-13 9:37am View

workinh thank u

Member 10256268 24-Sep-13 9:14am View

can u add TM_User,fullname column to above code

Member 10256268 24-Sep-13 7:56am View

expted output should be like this 1st row DOT NET=ASP.NET 2010, c# 3.0, WCF, c#4.0
2nd row Database=Microsoft SQL Server 2005

Member 10256268 24-Sep-13 7:49am View

expted output should be like this 1st row DOT NET=ASP.NET 2010, c# 3.0, WCF, c#4.0
2nd row Database=Microsoft SQL Server 2005

Member 10256268 24-Sep-13 7:27am View

by using COALESCE function

Member 10256268 24-Sep-13 7:27am View

u see above result ,i should get result like that

Member 10256268 24-Sep-13 7:26am View

no problem in this code ,i should get platform followed by skills with comma

Member 10256268 24-Sep-13 7:18am View

the result should be like this
platform skills
.net ASP.NET 2010,c# 3.0
software tes qa, manual

Member 10256268 23-Sep-13 3:39am View

soory maciej los no use sme result

Member 10256268 23-Sep-13 3:35am View

if i remove task_id frm select statment i am getting same result .
the result is
FullName (Max_end_date)

Deepti Injeti 2013-08-15 00:00:00
Deepti Injeti 2013-08-26 00:00:00
Deepti Injeti 2013-08-22 00:00:00

Member 10256268 23-Sep-13 3:12am View

if i use max function i will get result like this
task_id FullName (Max_end_date)
1890 Deepti Injeti 2013-08-15 00:00:00
1913 Deepti Injeti 2013-08-26 00:00:00
1916 Deepti Injeti 2013-08-22 00:00:00
u can see for different task-id we have different date if i use max function for end_date even then i will get same records ,i want only latest date.

Member 10256268 18-Sep-13 1:30am View

its working fine arun rajendra ,but u see in second inner join Task.status and Reference.LookupID are not pk and fk so pass Task.status and Reference.LookupID in sub query to remain qury

Member 10256268 10-Sep-13 5:19am View

plz see above question

Member 10256268 6-Sep-13 7:40am View

i am so sorry next time i will do it

Member 10256268 6-Sep-13 5:36am View

sorry i want to vote 5 how to do it

Member 10256268 6-Sep-13 5:35am View

sorry i want to vote 5 how to do it

Member 10256268 6-Sep-13 5:29am View

its working thank u ArunRajendra

Member 10256268 6-Sep-13 4:08am View

give full code

Member 10256268 6-Sep-13 3:59am View

display employes who report to the user id given if user id given is team lead , else display the employes who report to the given user id's team lead

Member 10256268 6-Sep-13 2:21am View

nobody knw the answer for this question

Member 10256268 6-Sep-13 1:50am View

i am getting result like this TM_UserID FullName TeamLead
13 Deepti Injeti Subhash Goud
103 Uma Pandrinki Deepti Injeti
106 Chandu Devathi Deepti Injeti
142 Lakshmidevi Banyala Deepti Injeti
401 Alekhya Katuri Deepti Injeti
but this is also correct if change userid as 13 other team is displaying i dont want that sme team display if i give any useid in the above result.

Comments by Member 10256268 (Top 92 by date)