Comments by Burning Thoughts

Burning Thoughts 4-Jul-16 1:41am View

this is what i am looking for
id name amount Rank
1 AAA 50000 1
7 SSS 50000 1
2 BBB 49999 2
6 EEE 28005 3
4 DDD 28000 4
3 CCC 15001 5
5 KKK 15000 6

Burning Thoughts 4-Jul-16 1:27am View

can you rank those amount based on highest amounts like below

50000 1st,
49999 2nd,
35000 3rd

Burning Thoughts 4-Jul-16 1:07am View

values which are closer getting same rank

Burning Thoughts 20-Jun-16 5:59am View

Thanks alot..

Burning Thoughts 20-Jun-16 5:24am View

how do i make it work on entire table, the solution which is given by you is working fine when only 3 rows. when i use it on actual table it is giving different result
it means top 1 row which started as

col a =0 col b =0 col c= -94

what ever the lookupvalue you pass to it is giving -94 only

Burning Thoughts 20-Jun-16 4:33am View

i need 13 to be returned.

am getting 14 as per your solution

Burning Thoughts 23-Sep-15 9:12am View

http://www.codeproject.com/Articles/28096/Excecute-SSIS-package-DTSX-from-ASP-Net
am creating package based on above page

using Microsoft.SqlServer.Dts.Runtime;

protected void btnExecute_Click(object sender, EventArgs e)
{
Application app = new Application();
Package package = null;
try
{
string fileName =
Server.MapPath(System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName.ToString()));
FileUpload1.PostedFile.SaveAs(fileName);

//Load DTSX
package =
app.LoadPackage(@"D:\SSIS_ASP_NET\SSIS_ASP_NET_DEMO\SSIS_ASP_NET_DEMO\Package1.dtsx", null);

//Global Package Variable
Variables vars = package.Variables;
vars["Business_ID"].Value = txtBusinessID.Text;
vars["Business_Name"].Value = txtBusinessName.Text;

//Specify Excel Connection From DTSX Connection Manager
package.Connections["SourceConnectionExcel"].ConnectionString =
"provider=Microsoft.Jet.OLEDB.4.0;data source=" + fileName + ";Extended Properties=Excel 8.0; ";

//Execute DTSX.
Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();
}
catch (Exception ex)
{
throw ex;
}
finally
{
package.Dispose();
package = null;
}
}

Burning Thoughts 26-Feb-15 3:24am View

after running function am getting this error An invalid floating point operation occurred

Burning Thoughts 25-Feb-15 23:50pm View

Thank you...

Burning Thoughts 25-Feb-15 5:51am View

not exact.but got some idea .. thank you any way other answers are also well come

Burning Thoughts 25-Feb-15 4:57am View

Deleted

SELECT CASE WHEN [Adherence_(Disbursed within TptT)]/[Opportunities_(All Files Disbursed)] THEN (1-0.0000034226)
WHEN [Adherence_(Disbursed within TpT)]/[Opportunities_(All Files Disbursed)] THEN "Wrong Data",
[Adherence_(Disbursed within TpT)]>[Opportunities_(All Files Disbursed)]
ELSE "NA"
END
from baselin

Burning Thoughts 25-Feb-15 4:52am View

Deleted

select [Adherence_(Disbursed within TpT)]/[Opportunities_(All Files Disbursed)] as dis,(1-0.0000034226) as dis2 from baselin

am able to create one condition for query how to club all

Burning Thoughts 26-Nov-14 1:06am View

2nd solution also good i got answer for my question

Burning Thoughts 25-Nov-14 4:43am View

let me try .. hope it will come .any way thank you

Burning Thoughts 25-Nov-14 4:34am View

if(@x=1)
select * from ... where id=@id and month=@month
if(@x=2)
select * from where id=@id and month=@year

while executing

if i select 1

procedure need to take variable input as id and month

if i select 1

procedure need to take variable input as id and month

if i select 2

procedure need to take variable input as id and year

Burning Thoughts 25-Nov-14 4:23am View

if i select 1 st procedure exec query need to take 56-id and JAN as variable
if i select 2 nd procedure exec query need to take 56-id and y1 as variable

Burning Thoughts 30-Oct-14 8:49am View

updated

Burning Thoughts 30-Oct-14 6:29am View

is it

Burning Thoughts 15-Oct-14 0:57am View

Deleted

select MyCountry
from Country
where countryname in(select countryname from Country)

Burning Thoughts 15-Oct-14 0:48am View

can you explain your requirement more

Burning Thoughts 14-Oct-14 9:17am View

thank you its working .....

Burning Thoughts 14-Oct-14 9:14am View

Deleted

this is working .. fine but summation of column data may give wrong data

Comments by Burning Thoughts (Top 22 by date)