Comments by Member 9846414 (Top 58 by date)

thanks for reply i tried this but i am getting an error
at from
any help plase helpme for above one with that only i can sloved my prblm

select StudentDATE= convert(Date,convert(varchar(50),cast((year(StudentDATE)-1) as varchar )+ '-' +cast(month(StudentDATE)as varchar )+@FROM)),
StudentDATE=convert(Date,convert(varchar(50),cast(year(StudentDATE)as varchar )+ '-' +cast(month(StudentDATE)as varchar )+@TO)) FROM STUDENT where STUDENTID='1' And StudentDATE<=convert(Date,convert(varchar(50),cast((year(StudentDATE)-1) as varchar )+ '-' +cast(month(StudentDATE)as varchar )+@FROM)) and convert(Date,convert(varchar(50),StudentDATE>=cast(year(StudentDATE)as varchar )+ '-' +cast(month(StudentDATE)as varchar )+@TO)) group by year(StudentDATE) order by year(StudentDATE)


help me

http://www.codeproject.com/Questions/637665/how-to-remove-duplicate


please see this link help me

http://www.codeproject.com/Questions/637665/how-to-remove-duplicate

please see this link

http://www.codeproject.com/Questions/637665/how-to-remove-duplicate

please see this link .

i tried .but it not working .can u see once i updated it.wht o/p i want...

i clearly mention above .i am get o/p like that.so plz help me .to remove dulpicate in that particular coloumn .how?

thank u very much sir i got it

thank u very much sir.

thank u very much.but can u tell me how to give path .

i add reportviewer. errors has gone now thank u very much. but how to give report can u help me .in my project i seen i copy path like given below
C:\Users\rahul\Documents\Visual Studio 2008\Projects\Report Project5\Report Project5

in that project report1 buck up is there and report1 and report.rdl.data from these which one i have to choose can u help me plz.

i am getting error at processingmode and serverreport for this we have to add any refrence or any header file help me..

thanks.it is not working.any one acn for this .help me

thank u very much madam :)

thank u very much its working

thank u very much

thanq for response.can you provide setup file for SQL server 2008 BIDS.

thanq for response.I know the procedure in visual studio 2010.i Want to install BIDS from SQL server2008.can u provide setup file for installing BIDS.please help me out,urgent.

this is not installing taking long time up to set was going from that not moving .can u provid another way

thank u very much

thanks for helping me

thank u very much responding to me .i was done by using formula felid

Thanku u very much i am happy .

i was done thanku u very much replaying very soon .Hi can u help me for below link seeing. Actually what i am doing
http://www.codeproject.com/Questions/566062/howplustopluswirteplusaplusconditionplususingpluss

thank u very much

thank u very much i got it . but here i am storing data into studentBasicinfo table for this table i want to write a qurey like this gievn below
select id,section, postion, rating, marks date, score, from studentbasicinfo where id='1'
group by id, section,postion,rating,narks,date,score this query were i should i write
help me plz this query must be excuted after above one can tell me plz

in side a condition .can u tell me how to use this formula step by step

thanks for given hint to us .help me motion to an object for above code

help me i want to join one more table that is student registatraion fro that stdRClass A plz see the output above i was mention help me plz i was trid near joining wrote ike this
With CTE(id,StdRclass,Rowid)
As
(
SELECT id,stdRcalss,ROW_NUMBER()over(partition by C.id ORDER BY C.id)'Rowid' FROM StduentRegistration C
),


CTE1 (id,marks,name,Rowid)
AS
(
SELECT id,marks,name,ROW_NUMBER()over(partition by C1.id ORDER BY C1.id)'Rowid' FROM codepro C1
),
CTE2(id,area,dist,Rowid1)
as
(
SELECT id,Area,dist,ROW_NUMBER()over(partition by c2.id ORDER BY c2.id)'Rowid' FROM codepro1 c2
)

select C.StdrClass, C1.id,C.marks,C1.name,C2.area,C2.dist from CTE C INNER JOIN CTE1 C1 ON C.Rowid=C1.Rowid1 AND C.id=C1.ID ,CTE1 C1 INNER JOIN CTE2 C2 ON C1.Rowid= C2.Rowid and C1.id=C2.id where C.id ='1'order by C.id

but diff oup is coming only one row is duplicating .i want to display one more coloumn that is stdRclass in fornt id what u said it was working fine nice.but when i am trying to add one more it was not getting for this help me

here 2 table are joing but i want to join one more table i mention above that is stdentregiration from that i wnt only stdRclass colounm can u tell me sir

hi sir it was came for particular id in this only tables combing and display another table i s missing that studentRegistration table from that stdRClass coloumn also been display . can u tell me ?plz edit above add one more table plz tell me i was done but confuse me

thank u veryyyyy much . what i am acepting it was came but it was displaying all the details
can u tell i want only one person then where i should mention where id='1' like this thank u very much

i was used ditinct key in qurey like this
SELECT Distinct SR.stdRClass ,SD.stdDname ,SD.stdDMarks ,SA.dist,SA.Aera
FROM studentregistration SR
INNER JOIN studentDetails SD ON SR.stdRid = SD.stdDid
INNER JOIN studentAdress SA ON SD.stdDid = SA.stdAid
WHERE SR.stdRid='1' and SD.stdDid ='1' and SA.stdAid ='1'
group by SR.stdRClass ,SD.stdDname ,SD.stdDMarks ,SA.dist,SA.Aera
but it not was slove

i have tried that also but same was geting i mention above .can u to tell me how to solve this

help me i was change i want to display like as shown above

thanks for answering i have tride this but some problem is occuring .i was not ment that in my table in studentdetails and studentAdress have Repation of rows are there plz see above again i was mention help me for this

in stdentadress and student detatils tablelike same way has been they help me

ya in table studentdetatils
stdDid stdDname StdDmarks
1 xx 30
1 xx 30
1 xx 30
2 yy 50 ... s on like this all
sry i was not memtion above help me

ya is correct but how to solve this issue help me madam .then how to go plz any suggestion or hint

thank u verymuch i am using formulka feild can u tell error for this boolean variable required here lke that error is comming i was written in formula like this toText (year(CurrentDate)) + "-" + toText (year(CurrentDate) + 1) help me by sloving this error

thank u verymuch i am using formulka feild can u tell error for this boolean variable required here lke that error is comming i was written in formula like this
toText (year(CurrentDate)) + "-" + toText (year(CurrentDate) + 1) help me by sloving this error

thanku very much hepling me i got it . displaying in horizontall manner but i want to dsipaly rin range thats y i use formula feild in that i have writen like this toText (year(CurrentDate)) + "-" + toText (year(CurrentDate) + 1) but error generating like boolean variable required her .how to solve this error plz help me

help me

toText (year(CurrentDate)) + "-" + toText (year(CurrentDate) + 1) i was tried in formula feild like but it asking error like this boolean variable required

thank u .but i dont know how to write a formula for thi can u help me :)

thank u very much but i am have table like this plz see below
id score marks date
1 20 40 6-6-2012
2 30 32 7-7-2012
3 50 52 4-3-2013
1 40 10 4-3-2013
1 56 6 6-8-2013...so on years has been they

from this above table having only one colounms we need not add any coloumn to this table or we need create any table . from this table only we have to retrivew daterange from date coloumn thanku for help me and thank very much for responding to me

thank u very much

thank u very much

Actuvally in my id having integer as well as string .i was writen like this where id='1A'
when i was enetr like this string was not ascepting ,thats y i use like to avoid that one like this (SELECT DISTINCT DATEPART(YYYY,Sdate) as s FROM dbo.StudDet where id like '%"1A'%"
it shows error at here select cast(DATEPART(MONTH,Sdate) as varchar(max)) as Months,Score,
DATEPART(year,Sdate) as st
from dbo.StudDet where id like '%"1A'%"
help me .thank u very much for helping me

thank u verry much thanks a lot . but it display all the details . iwant to dispaly only particular id how where id ="1" this where i should write tell me plz

iut dispaly oly particular years i want to display all the years . plz see below like and help me thanks in advance
http://www.codeproject.com/Questions/549971/howplustoplusdisplayplusdateplusinplusonepluscolou

thank u but .i was tried but i am not getting plz write query for this