Comments by ssd_coolguy

ssd_coolguy 13-Jun-13 2:37am View

yep... thanks.. i think we both solved at same time...:)

thank you for your support.. :)

ssd_coolguy 13-Jun-13 2:31am View

reportviewer is not visible..hence report also not..
and when i set report to reportviewer through properties... report viewer and report both are visible...

ssd_coolguy 20-Feb-13 5:58am View

please explain more... not sufficient information...

ssd_coolguy 20-Feb-13 5:48am View

sorry but not understood your question.. :(
What i can understand is you need difference between current and last month then you can use..

between DATEADD(month,-1,getdate()) and getdate()

ssd_coolguy 20-Feb-13 5:28am View

see my another solution 3

ssd_coolguy 19-Feb-13 4:51am View

do your calculation in stored procedure and execute it through SQL JOB. :)

ssd_coolguy 19-Feb-13 4:44am View

can you tell us.. what exactly that sql file contain..?
is there any query?

ssd_coolguy 5-Feb-13 3:49am View

http://www.w3schools.com/js/js_obj_date.asp

try above link..

ssd_coolguy 27-Dec-12 7:20am View

yet i am not clear with your question..
see you have total likes calculated for each month no? means oct and nov?
means your total likes for oct 254 and for nov 220..r8?

ssd_coolguy 27-Dec-12 6:56am View

you just simply add perc.diff column in you @tbl1 table and insert query..

ssd_coolguy 27-Dec-12 6:52am View

why don't you use single command to take backup of sql server..
backup database dbname to disk= 'F:\dbname.bak'

ssd_coolguy 19-Sep-12 4:38am View

5++

ssd_coolguy 19-Sep-12 4:32am View

bcoz..here you have different mail body for every mail id..and for that you need to set body every time..

ssd_coolguy 18-Sep-12 6:38am View

explain more...............

ssd_coolguy 18-Sep-12 4:25am View

you can use it in session start method..

ssd_coolguy 18-Sep-12 2:50am View

not clear.. can you explain more...

ssd_coolguy 6-Sep-12 8:25am View

Thanks Santosh..:-)

ssd_coolguy 5-Sep-12 8:46am View

Deleted

Do yo uhave Google?

ssd_coolguy 5-Sep-12 8:46am View

Do you have google...?

ssd_coolguy 5-Sep-12 6:25am View

Thanks.. :)

ssd_coolguy 5-Sep-12 6:18am View

i think it's not a single string. it's 3 different columns.
your function is correct when input is like '90,75,80'

ssd_coolguy 4-Sep-12 8:33am View

see if i correctly understands you...
i have updated my answer

ssd_coolguy 4-Sep-12 8:29am View

any 1 who downvoted. can you just expalin why... have you tested?

ssd_coolguy 4-Sep-12 7:46am View

see now. i improved my answer..

ssd_coolguy 4-Sep-12 7:23am View

yes.. now it will work.. just improve your solution.. :)

ssd_coolguy 4-Sep-12 7:12am View

have you tried solution 2?

ssd_coolguy 4-Sep-12 7:11am View

can you elaborate more...

ssd_coolguy 4-Sep-12 7:09am View

i think you missed else part here...

ssd_coolguy 3-Sep-12 6:55am View

not getting.. what you are trying to do... can you elaborate more?

ssd_coolguy 31-Aug-12 8:33am View

can you elaborate more?

ssd_coolguy 31-Aug-12 8:10am View

if i m correctly understands your problem then you need data like..

abc R1 .net high
abc R1 sql low
abc R1 jquery low
xyz R2 .net low

you can do it using join to...

ssd_coolguy 31-Aug-12 7:59am View

can you elaborate more?

ssd_coolguy 31-Aug-12 7:48am View

Can't you use loop here?

ssd_coolguy 29-Aug-12 2:48am View

see my updated solution...

ssd_coolguy 29-Aug-12 2:43am View

means you want month & year wise data right?

ssd_coolguy 25-Aug-12 2:17am View

why don't you write insert staement into your store procedure..?

ssd_coolguy 24-Aug-12 5:29am View

we can select only one database while opening new query window..
but we can go through diffrent database using below query..
use database_name
By the way you don't need to select two database while retriving data.

ssd_coolguy 24-Aug-12 3:28am View

if we correcly understands your problem..then
see the 2nd solution for join..
else exlpain more...
you want data from two diffrent server??

ssd_coolguy 24-Aug-12 3:14am View

currently you are using database1 and you want to retrive data from table1 from database2
then..
select * from database2.dbo.table1

ssd_coolguy 24-Aug-12 2:19am View

you asked for course_no and paper_name
if you want course name then it requires table1..

ssd_coolguy 24-Aug-12 2:02am View

what you have tried?

ssd_coolguy 24-Aug-12 1:47am View

can you show us your code...

ssd_coolguy 23-Aug-12 5:05am View

if i understands you correctly then.
you have table contains
1
2
3
4
.
.
n
records and you need only
2
3
4
.
.
n
not 1st record.. am i right?

ssd_coolguy 23-Aug-12 4:55am View

can you elaborate more..

ssd_coolguy 23-Aug-12 1:26am View

i am glad it's working..
accept the answer..

ssd_coolguy 23-Aug-12 1:04am View

see the solution 2...

ssd_coolguy 23-Aug-12 0:54am View

can you show us how you called your sp?

ssd_coolguy 22-Aug-12 2:45am View

if i correctly understand your problem then...
you just need to pass the parameter to your report..

ssd_coolguy 21-Aug-12 5:37am View

can you explain more...

ssd_coolguy 17-Aug-12 9:11am View

hey..why don't to go for running sum query?...

ssd_coolguy 10-Aug-12 6:10am View

what exactly you want.. can you expalin more...

ssd_coolguy 10-Aug-12 5:42am View

can you explain more with example..
means how batchname contains filenames?

ssd_coolguy 27-Jul-12 7:44am View

nice discussion in link....

ssd_coolguy 25-Jul-12 0:32am View

Dude.. if you are using Mysql datatype in Oracle then how it is possible?

ssd_coolguy 23-Jul-12 0:57am View

can you explain more..what you want to do?

ssd_coolguy 21-Jul-12 3:46am View

can you exlpain more.. what actualy you want to do?

ssd_coolguy 21-Jul-12 3:30am View

my 5!...

ssd_coolguy 21-Jul-12 3:30am View

but see below query which returns incorrect result.

select (datediff(day,'2012-07-01','2012-07-06')/7)+1 as Saturday

it should be return 0 na??

ssd_coolguy 21-Jul-12 1:55am View

it will not return correct answer..

ssd_coolguy 20-Jul-12 5:02am View

my 5! nice blog..

ssd_coolguy 20-Jul-12 2:20am View

hey you just have a look on link which i have provided for your previous quetion..
You will get all answers for validation

ssd_coolguy 19-Jul-12 8:28am View

which error did you get? and on which line?

ssd_coolguy 19-Jul-12 8:24am View

so remove order by clouse from the query...

ssd_coolguy 18-Jul-12 8:40am View

have tried google?

ssd_coolguy 17-Jul-12 4:27am View

glad it helps.. now lough.. :)

ssd_coolguy 17-Jul-12 3:46am View

hey.. nothing to lough in it. i am just helping you.. html page is on your pc or remote pc? or do 1 thing you just keep that image in folder with your page and give image name only in path..

ssd_coolguy 17-Jul-12 3:26am View

means i was trying :)

ssd_coolguy 17-Jul-12 3:21am View

yes i got your point.. but can you show us byte of code. so we can help you. is there any browser dependent code? or you need to check browser setting..

ssd_coolguy 17-Jul-12 3:11am View

hei.. i am not sure but this error comes when your string contains any blank space.. that's why you need to replace youre sting with " " to "+".

ssd_coolguy 17-Jul-12 2:51am View

hei AlluvialDeposit..
yes you are right.. it's my mistake.. i tried it on oracle.. ;)
anyway. i modified it.
thank you very much.. :)

ssd_coolguy 17-Jul-12 2:36am View

AlluvialDeposit... you are such a nice person ... :) i can't contorl :-D

hello project virus,
What you have tried??

ssd_coolguy 17-Jul-12 2:32am View

Glad it helps...

ssd_coolguy 17-Jul-12 2:15am View

Have you tried google?

ssd_coolguy 17-Jul-12 1:59am View

hey Bhushan_f & mindbrink,
if your dataset contains multiple tables, you can save it in database as below.
create as DA for table where you wanna insert and update DA using
DA.update(DS,"TableName")
Don't forget to create cammandbuilder :)

ssd_coolguy 11-Jul-12 6:08am View

thanks for reply..
when i add option explicit in it..it's working fine... :)
thanks.. i was fighting for this since 1 hr.. :(

ssd_coolguy 11-Jul-12 6:06am View

thanks for reply..

ssd_coolguy 11-Jul-12 6:06am View

thanks for reply..
yes.. you are right i can view it in view source. :) and when i replaced it with lt/gt.. then i am able to view it.. :)

ssd_coolguy 10-Jul-12 2:50am View

thanks for reply... your links helped me lot... :)
i am about to solve this problem..:) soon i will update answer here..

ssd_coolguy 6-Jul-12 4:26am View

can you explain more with your code..

ssd_coolguy 27-Jun-12 8:12am View

your question is not clear...
can you explain more..what actually you want to do..

ssd_coolguy 26-Jun-12 9:05am View

hey amol..
and which basis you are going to make slot of 5-5??

ssd_coolguy 26-Jun-12 9:04am View

Deleted

hey amol..
and which basis you are going to make slot of 5-5??

ssd_coolguy 26-Jun-12 7:02am View

hi..
is your table contains only 1 day data?

ssd_coolguy 26-Jun-12 5:48am View

can you elaborate more..
show it is in tables..

ssd_coolguy 26-Jun-12 5:38am View

not working means ?
you got an error?
can you elaborate more..

ssd_coolguy 26-Jun-12 5:30am View

hey.. now i have updated link...
just check it..

ssd_coolguy 26-Jun-12 1:15am View

sorry i didn't get your question..
can you elaborate more

ssd_coolguy 25-Jun-12 9:22am View

i don't think there is too much diff in both..

ssd_coolguy 23-Jun-12 7:04am View

hey.. let us know what you have tried?

ssd_coolguy 23-Jun-12 4:05am View

let us know what you have tried?

ssd_coolguy 23-Jun-12 3:59am View

hey.. let us know what you have tried?

ssd_coolguy 22-Jun-12 9:03am View

hey thanks for help..see solution 3..;)

ssd_coolguy 22-Jun-12 9:03am View

hey thanks for help..see solution 3..;)

ssd_coolguy 21-Jun-12 13:08pm View

good one answer...

ssd_coolguy 21-Jun-12 13:02pm View

hey dude let us know what u have tried..
and the main thing is... where is your question?

ssd_coolguy 21-Jun-12 12:57pm View

hey thanks... for accepting solution

ssd_coolguy 21-Jun-12 7:58am View

correct answer..

ssd_coolguy 21-Jun-12 7:53am View

i installed vs2008 on server but still it is giving same error..
just ISAPI filters as updated as below:
RSIsapiPlugin & ASP.NET_2.0.50727.0

shall i need to update my iis??

ssd_coolguy 21-Jun-12 7:02am View

hey..let us know what you have tried?

ssd_coolguy 21-Jun-12 6:55am View

hey let us know...you are entering two people in same time or diff?
or you will update for second?

ssd_coolguy 21-Jun-12 6:30am View

thank you... :)

ssd_coolguy 21-Jun-12 6:07am View

thanks... for reply..
means i need to install 3.5 on server..

ssd_coolguy 21-Jun-12 5:10am View

hey what do you mean "each epmloyee where doteofjoining is lowest"?
is there multiple records for employee...?
can you explain more...

ssd_coolguy 21-Jun-12 4:38am View

hey ..let us know what you tried..

ssd_coolguy 20-Jun-12 9:18am View

thank you..:)

ssd_coolguy 20-Jun-12 9:08am View

hey let us know which language you are using?? asp,.net?

ssd_coolguy 20-Jun-12 9:02am View

correct answer my 5!!

ssd_coolguy 18-Jun-12 9:30am View

yes i will sure spend time to learn vb.net...

i got solution with below code also just check it...

intmax = nextno.ToString("TXT000000")

if intmax contians 14 then it will return TXT000014... :)Thanks..

ssd_coolguy 18-Jun-12 8:47am View

yes.. i tried below code.... but no output :(
intmax = String.Format(intmax, "TXT00000")

ssd_coolguy 18-Jun-12 8:41am View

Thanks for reply..
but can please give me example.

ssd_coolguy 7-Jun-12 2:56am View

hey i don't think is there any way to add column in between two existing column using TSQL.for that you need to use temp table or Enterprise Manager will write all of the code for you...:)

ssd_coolguy 7-Jun-12 2:07am View

hey can u please explain more.. what exactly you want?

ssd_coolguy 6-Jun-12 6:18am View

hey shahin ...thanks for reply..

ssd_coolguy 6-Jun-12 6:10am View

Hey.. thank you very much...
your version 2 solution is working fine.. :) :D
Thanks..

ssd_coolguy 5-Jun-12 13:21pm View

hii..waiting for solution...:)

ssd_coolguy 5-Jun-12 9:42am View

hey dude.. sorry please don't mide. sorry if i said anything. but actualy from morning i am trying to get answer but i can't hence..i am frustrated.. :(

Thanks for your reply...

ssd_coolguy 5-Jun-12 9:30am View

hey you are saying about webmethods... and i am asking about class in webservice..
if you didn't get question then ask for more clarification..
please don't post it in answer...

ssd_coolguy 5-Jun-12 9:21am View

hey nope...
see i have created webservice and created one class in that webservice (class clsxml) and now when i create object of that webservice that time i want to use that class(clsxml).. but how??

ssd_coolguy 5-Jun-12 9:04am View

hey dude... please read my question carefully. i was not asked about how to add webservice in application.

ssd_coolguy 5-Jun-12 1:04am View

hey i think we are going wrongway..
can you just see the conversation between me and JimJos.
i am trying to updated the dataset using dataadapter but my datasets source is xml file...
your help would be appreciable...

ssd_coolguy 5-Jun-12 0:49am View

yes boss i think it will work..
but see my seanario..xml dataset conatins only 2 rows but another dataset contains many row..means do i need to make data relation between them?

i cleared xmldataset and added another dataset's datatable into it and tried but it giving same error..:(

ssd_coolguy 5-Jun-12 0:23am View

hey.. i hav used refreshschema(). and i cheked with select *. but it asked for remaining fields..:(

my create query is like :-CREATE TABLE [Compalint] (

[UserID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Password] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Email] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[LoginID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Type] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ACTIVE_FLG] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[LAST_SIGN_IN] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[LAST_PWD_CHG] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

PRIMARY KEY CLUSTERED ( [UserID] ) ON [PRIMARY] ) ON [PRIMARY]GO

ssd_coolguy 4-Jun-12 8:43am View

hey sorry but how i can remove it from update list... i tried to remove from select but it's giving error as primary key needs to update statement..:(

ssd_coolguy 4-Jun-12 6:04am View

hi shahin .. i am confused... :(

because.. when i seen the commandtext from cmdbld.GetUpdateCommand().commandtext() and i got below update command..

UPDATE [compalint] SET [userid] = @p1, [loginid] = @p2 WHERE (([userid] = @p3) AND ((@p4 = 1 AND [loginid] IS NULL) OR ([loginid] = @p5)))

update command is right.. but why it is giving error?? :( :(

ssd_coolguy 4-Jun-12 5:59am View

yes right...

ssd_coolguy 4-Jun-12 5:20am View

yeah Sir you are right we need to set the 'RowState' property is UPDATE mode..
As per you, we can't update the tabel if we not take dataset from that table only..
So is there any way to solve this problem??

Sorry for my poor english :(

ssd_coolguy 4-Jun-12 5:12am View

thanks for reply..
what you mean improve the update command? i am not writing any updated command..
and my table contins only one primary key "uesrid".
Can you please explain more??

ssd_coolguy 4-Jun-12 5:03am View

thanks for reply...
dataset ds1 contains userid and loginid. and it is getting from xml file.
and i want to update compalint table's loginid field only.. because userid is primary key..
is my dataadapter update code is wrong?

ssd_coolguy 1-Jun-12 6:06am View

Anand.. use your date column for sort..

ssd_coolguy 1-Jun-12 5:57am View

thanks... it solved my problem. :)

ssd_coolguy 30-May-12 8:54am View

hey sanjeev
see the improoved question..

ssd_coolguy 30-May-12 8:50am View

Deleted

hey sanjeev i used xmldoc.save("file.xml") and got data like

<complaints>
<Table>
<userid>1
<name>suhas
<Password>7DCB7FBA2B871F5E2A5D7A41A</Password>
<email>
<loginid>ssd
<type>Others
<active_flg>A
<last_sign_in>2008-06-20T10:23:28.717+05:30 <last_pwd_chg>2008-06-12T14:39:15.903+05:30
</Table>

ssd_coolguy 24-May-12 8:22am View

hey thanks..

ssd_coolguy 22-May-12 6:00am View

if you have backup file then you can restore you table with values..

ssd_coolguy 21-May-12 5:12am View

Deleted

hey mido..
i have question on it..
how can you write DML statements in function??

ssd_coolguy 17-May-12 6:34am View

welcome...
accept the solution ;)

ssd_coolguy 17-May-12 1:12am View

1.Create dmp file without data and insert it into new account.

2.Create another dmp file for only those table for which you needs data too.(give table name while creating dmp file)

3.drop those tables from new account and insert another (step 2) dmp in new account.

hope above steps will helps..

ssd_coolguy 17-May-12 0:32am View

you mentioned that you need data also.. :)
but if you don't want data then while ceating dmp file give rows='N' parameter.

ssd_coolguy 16-May-12 5:16am View

hey dude, you can not use aggregate function in where clause.
if you want condition on aggregate function you can use group by clause.

ssd_coolguy 16-May-12 5:11am View

if you want to transfering data from excle to SQL databse
you can go for DTS packages..

ssd_coolguy 15-May-12 7:23am View

can you please explain more...
because if you want only phone no field from file then above code is not useful and if this is onetime activity then you can go for DTS package.

ssd_coolguy 15-May-12 0:11am View

did you got any error while running your code?
how many fields .slv file contains?

ssd_coolguy 14-May-12 6:19am View

hey prasad, thanks i got clue from your post.. :)
plz see my solution..

ssd_coolguy 14-May-12 5:47am View

i think this issue might be access issue...because used password is in encrypted format.

ssd_coolguy 14-May-12 5:25am View

thanks for reply.. :)

Comments by ssd_coolguy (Top 145 by date)