Comments by Member 11658469 (Top 41 by date)

Kindly help plz

Thanks for the response.Sorry the exact example below

Table 1

ID ITEM QTY
1 I1 2
2 I1 2
3 I2 10


Table2

ID ITEM QTY
1 I1 10
2 I2 10
3 I3 10
I need the output like below

ITEM Qty BALANCE
I1 4 6
I2 10 0
I3 0 10

I3 exists in Table2 which not exists in Table1

The output should be mentioed above

This will fetch the balance where both tables contains.I need to get the item count from table2 which not exists in table 1

Col1 Col2 Col3 Col4
10 5

I need to get the output as 5 because col3 is having the last value.Kindly help to fetch the output like this.

Thanks for the support

I grouped the query too the the output is coming with sum in wrong calculation

Kindly help to sort out the issue

Kindly reply

I need grouped report In the example for STRUCTURAL with Pipe Rack for 2 months data should display in one record.In the used query the data displayin in 2 different rows

KIndly help

The crystalreport is not installed in client machine.Is it possible to view the reports using Crystalreport without install in client machine.

Because the windows set up is installing more than one machines.So its not possible to install Crystal report in all machines.I added the DLL's in bin folder,still the reportdocument is not initializing.

Kindly reply

Is there any way to check an sql command to fetch roles with 1,5

Hi
My Actual Code is copied below.
SELECT DISTINCT UPPER(PAYMENTLOCATION) AS PAYMENTLOCATION,UPPER(CREDITCARDTYPE) AS CREDITCARDTYPE,
CASE WHEN UPPER(PM.PAYMENTLOCATION) IN ('SHAMELSIMSIM','AUB','AUBSIMSIM','BSB','BBKSIMSIM','HSB','KHB','KHBSIMSIM','NBB','NBBSIMSIM','SBB','SCBSIMSIM','BBK') THEN
CASE WHEN COUNT(T4.SERVICENO) OVER (partition by '973' || PM.ACCOUNT_NUMBER) > 0
THEN COUNT(PM.TRANSACTION_NUMBER) OVER (PARTITION BY UPPER(PM.PAYMENTLOCATION) ,UPPER(PM.CREDITCARDTYPE))
ELSE 0 END ELSE 0 END AS DB_SIMSIM_COUNT,
CASE WHEN UPPER(PM.PAYMENTLOCATION) IN ('SHAMELSIMSIM','AUB','AUBSIMSIM','BSB','BBKSIMSIM','HSB','KHB','KHBSIMSIM','NBB','NBBSIMSIM','SBB','SCBSIMSIM','BBK') THEN
CASE WHEN COUNT(T4.SERVICENO) OVER (partition by '973' || PM.ACCOUNT_NUMBER) > 0
THEN SUM(PM.AMOUNT) OVER (PARTITION BY PM.PAYMENTLOCATION,UPPER(PM.CREDITCARDTYPE))
ELSE 0 END ELSE 0 END AS DB_SIMSIM_SUM
FROM PAYMENTS_LOG_ALL_V PM
INNER JOIN BSS_DATA.BSS_ASSET_INFO T4 ON '973' || PM.ACCOUNT_NUMBER = T4.SERVICENO AND T4.Assettype = 'Mobile_Prepaid' AND T4.ASSET_STATUS = 'Active' AND PM.BILL_PROFILE_ID IS NULL
WHERE UPPER(PM.PAYMENTLOCATION) IN ('SHAMELSIMSIM','AUB','AUBSIMSIM','BSB','BBKSIMSIM','HSB','KHB','KHBSIMSIM','NBB','NBBSIMSIM','SBB','SCBSIMSIM','BBK')
AND T4.Assettype = 'Mobile_Prepaid'

Here in the Table T4 one column CODE which will come 1 or 2 for the same SERVICENO in same table.Due to this code appear twicw we cant fetch the correct datas(SUM) using the query.Means for some SERVICENO if 2 codes with are there twice the transaction count & sum is taking.I need to avoid the second entry.If the SERVICENO is same for the CODES then once the sum will taken based on same condition in the query.
Please help

Thanks for the reply.When I apply the paging the issue resolved.

Sir,

I used the reply button itself for the reply .But user didn't reply till now.

Sorry for using the Capital letters.

I NEED TO GET DIFFERENT MOBILE NO UNDER SAME CPRCR USING LISTAGG.I AM GETTINH STRING TOO LONG EXCEPTION

SELECT LISTAGG(REGISTEREDMOBILENO, ',') WITHIN GROUP (ORDER BY CUSTOMERID) AS REGISTEREDMOBILENO,LISTAGG(CPRCR, ',') WITHIN GROUP (ORDER BY CPRCR) AS CPRCR
FROM (SELECT DISTINCT RRL.MOBILENO AS REGISTEREDMOBILENO, RS.CPRCR FROM RESELLER_REGISTRATION_LOG RRL
LEFT OUTER JOIN RESELLER_SECURITY RS ON RRL.REGISTEREDBY = RS.CPRCR WHERE RRL.LOGDATE BETWEEN to_date('04/01/2017', 'mm/dd/yyyy') AND to_date('04/30/2017', 'mm/dd/yyyy')) GROUP BY CPR

Here the mobile no is different for example if we have 3 mobile nos then CPR will also fetch 3 times .If different CPR need to fetch different

For ex:

Mob CPR
MOb1,Mob2,Mob3 CPR1

If 2 CPR will be there need the output like that

MOB CPR
MOB1,MOB2,MOB3 CPR1,CPR2

I tried the Listagg with comma separator but the output I got is

Col1 Col2 Col3
00089079/3,00089079/3 39146100,38917455 A481411,A481411

Here Col2 is different but Col1 & Col3 are same.I need output as
00089079/3 39146100,38917455 A481411

We tried to set the pool version but we are getting the error as
There is a duplicate 'system.web.extensions/scripting/scriptResourceHandler' section defined

Thanks for the reply.

How we set 2 directory version for same Application Pool.Please help.

Hi,

This string conversion we know,but the thing is we need to pass the variable in Date Data type.There we face the issue.

Hi,

We tried this one also,same result we are getting.The Output will be "2/22/2016".This one also contains 10 character length.

Thanks for the reply.

We need the date value length should be 8 characters.For the above value 10 characters will be there.Please adivce to restrict the length to 8 characters.

Actually we are connecting the remote server data using the Web refrence.So there is no need to add the Connection strings in our code.We add the refernce and we tried to call the datas from the remote server.Then the issue is showing.

Hi,

As per the solution we cant trace out the solution.We enabled the firewall and the system works.Again the same issue occur.Please help to resolve the issue permenantly.

Please help...

Its resolved thanks for the reply..

That part also i tried but its not working..

There is no server side code in the head tag.Just some javascript functions.

Dear ,

Thanks for the solution.

We would like to load the files inside a form tag in vb.net

<% foreach (string one_document in FileRepository.GetAllDocuments())
%>
<tr>
<td>
<%= one_document %>
</td>
<td>
<%= new FileInfo(FileRepository.RootStorage+one_document).Length / 1024 %> KB
</td>
<td>
Open
</td>
<td>
Open
</td>
</tr>

<% %>
We are getting error.

Please help

Hi,

Please provide a simple javascript code to specify the keys for these functions.

Regards
Sreejith

Hi Thanks for the reply.

We are doing the code in vb.net.So when we convert the code and copy into our application like

Dim lstResult As string() = (From a In myICTCReceCountry With{Key.Country_Name = a.Country_Name,Key.Destination_Country = a.Destination_Country}).ToList.Distinct()
For Each lst As String In lstResult
ddlCountry.DataTextField = lst.Country_Name
ddlCountry.DataValueField = lst.Destination_Country
Next
We facing an error in the With & lstResult variable.Please help

Hi,

Till now we cant able to get the value.The variables are passing but the thing is the code we need to exceute in the pageload of the invoked page is not executing.

Regards
Sreejith

Hi ,

Actually we know to retreiving the parameter from one web page to another.We need the querystring value from passed web page from windows application and get the value in a web page.

Regards
Sreejith

HI,

Thanks for the reply.

Till now the solution didnt get.The above mentioned method also tried but no result.

Regards
Sreejith