i am trying to get tran through third party softwares now....i have installed my sql server on https://my.discountasp.net/mssql.aspx.

Actually i am working on already developed application,where i am adding new features and modifying existing system.The previous developer have used these output parameters instead of using .Net.i do not...

SSCrazy:

Here is what i want to do....

Case 1:Save OR Delete Data into database

string ErrorMessage = "";

...

Yes this worked for me.....thanks alot

IF i run this QUERY

select top 3 COMPANY,Keywords from COMPANIES

give me the following

COMPANY|Keywords

A | Q

B ...

@SSCrazy

Hi,

the below procedure works for me for less amount of data....when i increased the number of data from 100000....now this do not give me result...the server is executing for more...

Done:

Thank you..you save my time

Thank u for ur reply

For SELECT TOP 3 issue...i am not concern to pick specific 3 companies...any 3 may be from these 10 companies...i mean may be company 1,2,3 or...

Actually most of my issues have been solved...now i do not know how to close those topics....

I think this should be clear to all of you....i have more than 100000...

Please help me in this...

i have more than 100000 records in company table...i want to export in excel and then do some correction and then import again.....i have a post...

Actually i am working under project manager...i do what he wants....

Leston...there is search on companies...so obviously we will show first those companies who pay us and will show later who...

As i mentioned earlier,i want to show top 3 paid companies(paid companies are more than 3) on the top of my application display page and then show unpaid companies below

After alot of googling i found solution like this

SELECT top 100 ID, COMPANY,

...

Actually i have search query like below

SELECT top 100 ID, COMPANY,

...

Please Reply me ASAP

this works only when i remove any = sign....from <= or >=

select *

from BDBanner

where ISNULL(FromDate,GETDATE())<= GETDATE()

and ISNULL(ToDate,GETDATE())>= GETDATE()

what i do now?