Comments by TAUSEEF KALDANE (Top 41 by date)

No Sir, i tried ur query and it is also throwing errors as follows
1. Msg 8155, Level 16, State 2, Line 5
No column name was specified for column 1 of 'a'.

2. Msg 1038, Level 15, State 5, Line 1
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

No, i have visited on this site for opc technology.
http://www.codeproject.com/Articles/12441/OPC-Technology
http://www.codeproject.com/Articles/1135/OPC-and-NET-with-COM-Interoperability
etc

Sir, I don't want any permission from u. I have decided to go for java for my career but I want to some comparisons between java and .net for compatibilty

Sir, i tried it but didn't work

thank you sir, your solution has worked properly.

Sir, Please tell me how to convert excel file to byte array?

there are multiple datasets writing in excel file... nd then 4 datasets for graph.... file is saving at particular location on server using worksheet.SaveAs(FilePath). We want to make it downloadable to any machine.

i wanted to get data in graph from SQL Database directly. i don't want to display source table values into excel. is it possible?

i got following error
Msg 8164, Level 16, State 1, Procedure SP_Firstdistil, Line 174 An INSERT EXEC statement cannot be nested

i need to transfer data between two servers through sql query and it has to update automatically after every 1 hour

sir,
i can't use sp_executesql due to open query. it started throwing errors

i want the value for further calculations.

i had used sp_executesql but it didn't work.

or sir you can provide me some good links that i can get idea about embedded and robotics

i had googled but i want some basic knowledge of embedded and robotics

thank you sir

thank you vinay sir

thank you sir

how to use query analyzer ?

sir i have also tried it without group by clause as follows.

declare @month int
declare @year int
set @month=8
set @year =2014


declare @startdate datetime
declare @enddate datetime
set @startdate=CONVERT(datetime,convert(varchar,@year)+'-'+convert(varchar,@month)+'-'+'01')

if (@month>= MONTH(GETDATE()) and @year>=YEAR(GETDATE()))
begin
set @enddate=(select GETDATE())
end
else
begin
set @enddate=DATEADD(day,-1,DATEADD(month,1,@startdate))
end

create table #thick
(
[date] datetime,
alumina decimal(18,5),
caustic decimal(18,5),
ratio decimal(18,5),
fsfalumina decimal(18,5),
fsfcaustic decimal(18,5),
fsfratio decimal(18,5),
nt_6o decimal(18,5),
nt_6u decimal(18,5),
nt_6_density decimal(18,5),
nt_6_solid decimal(18,5),
sodagpldms1 decimal(18,5),
soliddms1 decimal(18,5),
mudmgpldms2 decimal(18,5),
sodagplpfdms2 decimal(18,5),
solidpfdms2 decimal(18,5),
gplsodae1 decimal(18,5),
phe1 decimal(18,5),
nt_2s3 decimal(18,5),
pglmudp1 decimal(18,5),
ofmgplp2 decimal(18,5),
densityp3 decimal(18,5),
solidp3 decimal(18,5),
hrddensityh1 decimal(18,5),
hrdsolidh1 decimal(18,5),
ufdensityh1 decimal(18,5),
ufsolidh1 decimal(18,5),
mudp4 decimal(18,5),
ntu1density decimal(18,5),
ntu1soda decimal(18,5),
ntu1solid decimal(18,5),
ntu2density decimal(18,5),
ntu2soda decimal(18,5),
ntu2solid decimal(18,5),
ntu3density decimal(18,5),
ntu3soda decimal(18,5),
ntu3solid decimal(18,5),
ntu4density decimal(18,5),
ntu4soda decimal(18,5),
ntu4solid decimal(18,5),
ntu5density decimal(18,5),
ntu5soda decimal(18,5),
ntu5solid decimal(18,5),
ntu6density decimal(18,5),
ntu6soda decimal(18,5),
ntu6solid decimal(18,5),
nto1soda decimal(18,5),
nto2soda decimal(18,5),
nto3soda decimal(18,5),
nto4soda decimal(18,5),
nto5soda decimal(18,5),
nto6soda decimal(18,5)
)

while (@startdate<=@enddate)
begin

insert into #thick
select * from (
select
@startdate as [date],
isnull(AVG(s1.alumina),'') as alumina,
isnull(AVG(s1.caustic),'') as caustic,
isnull(AVG(s1.ratio),'') as ratio,
isnull(AVG(s2.alumina),'') as fsfalumina,
isnull(AVG(s2.caustic),'') as fsfcaustic,
isnull(AVG(s2.ratio),'') as fsfratio,
isnull(AVG(l1.nt_6o),'') as nt_6o,
isnull(AVG(l1.nt_6u),'') as nt_6u,
isnull(AVG(l2.density),'') as nt_6_density,
isnull(AVG(l2.solid),'') as nt_6_solid,
isnull(AVG(d1.sodagpldms),'') as sodagpldms1,
isnull(AVG(d1.soliddms),'') as soliddms1,
isnull(AVG(d2.mudmgpl),'') as mudmgpldms2,
isnull(AVG(d2.sodagplpf),'') as sodagplpfdms2,
isnull(AVG(d2.solidpf),'') as solidpfdms2,
isnull(AVG(e1.gpl_soda),'') as gplsodae1,
isnull(avg(e1.ph),'') as phe1,
isnull(AVG(s3.nt_2),'') as nt_2s3,
isnull(AVG(p1.pglmud),'') as pglmudp1,
isnull(AVG(p2.ofmgpl),'') as ofmgplp2,
isnull(AVG(p3.density),'') as densityp3,
isnull(AVG(p3.solid),'') as solidp3,
isnull(AVG(h1.hrddensity),'') as hrddensityh1,
isnull(AVG(h1.hrdsolid),'') as hrdsolidh1,
isnull(AVG(h1.ufdensity),'') as ufdensityh1,
isnull(AVG(h1.ufsolid),'') as ufsolidh1,
isnull(AVG(p4.mud),'') as mudp4,
isnull(AVG(tu1.density),'') as ntu1density,
isnull(AVG(tu1.soda),'') as ntu1soda,
isnull(AVG(tu1.solid),'') as ntu1solid,
isnull(AVG(tu2.density),'') as ntu2density,
isnull(AVG(tu2.soda),'') as ntu2soda,
isnull(AVG(tu2.solid),'') as ntu2solid,
isnull(AVG(tu3.density),'') as ntu3density,
isnull(AVG(tu3.soda),'') as ntu3soda,
isnull(AVG(tu3.solid),'') as ntu3solid,
isnull(AVG(tu4.density),'') as ntu4density,
isnull(AVG(tu4.soda),'') as ntu4soda,
isnull(AVG(tu4.solid),'') as ntu4solid,
isnull(AVG(tu5.density),'') as ntu5density,
isnull(AVG(tu5.soda),'') as ntu5soda,
isnull(AVG(tu5.solid),'') as ntu5solid,
isnull(AVG(tu6.den

i have already tried it but i want to pass month and year to query

yes sir i checked and it is correct. but i want application to be hosted on dynamic ip provided by router to server machine. plz help

i used machine name but it thows me an error as follows

HTTP Error 500.0 - Internal Server Error
Calling LoadLibraryEx on ISAPI filter "C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll" failed

sir i got the solution,
i deleted old web.config file and then add new config file and now it is working properly.

i tried this but getting same error plz help me

how would i know about whether i m running application in cluster/Webform or not.

actually i already added runat= "server" but it doesn't work

yes rohan u r right

but how do i use that control in wpf?

i means that a code-behind file(.aspx.cs) is used to process page and http handler is used to process page? then can we say that a code-behind file is httphandler?

it gives only minute wise data. It should give data occurred whithin 10 minutes of interval

thank u very much...................

thank u.........................

Thank u...................

and how do i refer this key in another table?
how do i create foreign key by referring this primary key?

is webmail-lite used to create app?