Comments by Davidduraisamy (Top 54 by date)

Let me know whether my solution is ok for you or not

send sample output

I am not sure about that.

In MS SQL server you want use Linked Server,but i am not sure about MySQL

hmmm..

Ya..Check the qusetion and rply properly Aarti

Suppose if scode has more code for particular id then this wont work...right...

SELECT sum( amt ) FROM emp WHERE empid =1

If u want both means in where condition dont use particular condition

hey wat u r asking

Can you explain with examples

how,In his statement there is no aggregate function then how u will do in Pivot

Aarti whether it is possible to do with pivot.

Explain how you want the ouptut..it was not clear

You made group by on both id,name so in this scenario having will handle with both id and name so chek this u will come to know the difference

select name ,id from demo group by id ,name having COUNT(id)>=2

What you are trying to do...can u explain?

ok...have you got result using pivot...

Whether its working fine...

Ok..hereafter i will give only the suggestion.

you cant use pivot because there is no mean of using aggregate function in your query so you cant use pivot in this case,so my query is better option for this.

Just helping others who are struggling..thats it...

is it working fine....

Check the Result and let me know whether the problem solved or not

Can you explain y lock will not work in select statement

can u provide sample example

You can order by in string column...

No need to delete the values..He can update the string values to numeric...Thats enough..

hey if you are applying where condition in all table den how fail condition will come

Restrict the condition in where clause as pass=1

I am not having knowledge about Cluster so only i asked you..If it possible post me the use of cluster shared disk available check and purpose of that..

he is asking about default dateformat...so this is correct---- SET DATEFORMAT dmy;

Procedure will not return the value..If u need any return value then use function

If time permits can you explain about the Cluster shared disk variable

Check updated code and let me know the issue..

If it is like that then have to split the values and use ISNUMERIC function..

To get min,hour,sec

SELECT convert(varchar, getdate(), 108) --– hh:mm:ss

In sql it will return truncate error if ANSI_WARNINGS OFF..
If ANSI_WARNINGS ON then it will trim to valid size and it will do the operation..

Explain the question clearly..

Try this:
select q.Student_ID,q.Fee_Type,q.amount,case when q.amount IS null then q.amount else q.amount-p.paid end as Current_month_due,case when g.paid is null then 0 else q.amount-g.paid end as previous_month_due,(q.amount-g.paid)+(q.amount-p.paid) as total_amount from Student_Fee_Quotations q join
(select d.Student_ID,d.Fee_Type,sum(d.amount) as paid from FeePaid_Details d where
d.Student_ID='PS20130001' and d.Fee_Type='Admission Fee' and d.Month_Details='jan'
group by d.Student_ID,d.Fee_Type )as g on q.Student_ID='PS20130001' and q.Fee_Type='Admission Fee' join (select d.Student_ID,d.Fee_Type,sum(d.amount) as paid from FeePaid_Details d where
d.Student_ID='PS20130001' and d.Fee_Type='Admission Fee' and d.Month_Details='feb'
group by d.Student_ID,d.Fee_Type ) as p on q.Student_ID='PS20130001' and q.Fee_Type='Admission Fee'

you are asking how to create job or SQL Query?

What issue you are facing?

have you got the result?

wats the problem here its working

You have oly this four record or having more record

This is not coming correctly..

What OS you are using?

Have you found the answer...

In select statement you have taken Table name.Take Column name.

declare @value varchar(500)
declare @Whrcol varchar(500)
declare @Whrvalue varchar(500)
set @Whrcol='Product Cat3'
set @Whrvalue='IR DOME CAMERA'
set @value=('select [Column Name] from tblProductsCatalog where ['+ @Whrcol+ '] ='''+@Whrvalue+'''')
execute (@value)

No..this can extend according to Delimiter.