Click here to Skip to main content
15,039,809 members

Comments by Member 11658469 (Top 38 by date)

Member 11658469 12-Jul-21 4:12am View
   
Dear All,

Thanks for the support.I found the solution.

Regards
Sreejith
Member 11658469 12-Jul-21 0:24am View
   
Dear All,

Kindly help to find the non duplicate records from xml parameter
Member 11658469 26-Jun-21 2:26am View
   
Kindly help plz
Member 11658469 26-Jun-21 1:49am View
   
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
Member 11658469 26-Jun-21 1:34am View
   
This will fetch the balance where both tables contains.I need to get the item count from table2 which not exists in table 1
Member 11658469 22-Jun-21 2:11am View
   
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.
Member 11658469 20-Jun-21 1:27am View
   
Thanks for the support
Member 11658469 17-Jun-21 0:48am View
   
I grouped the query too the the output is coming with sum in wrong calculation
Member 11658469 16-Jun-21 11:24am View
   
Kindly help to sort out the issue
Member 11658469 16-Jun-21 8:40am View
   
Kindly reply
Member 11658469 16-Jun-21 8:28am View
   
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
Member 11658469 19-May-21 5:38am View
   
KIndly help
Member 11658469 18-May-21 7:50am View
   
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.
Member 11658469 18-May-21 7:31am View
   
Kindly reply
Member 11658469 4-May-21 3:59am View
   
Is there any way to check an sql command to fetch roles with 1,5
Member 11658469 1-Aug-18 4:21am View
   
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
Member 11658469 17-Apr-18 4:57am View
   
Thanks for the reply.When I apply the paging the issue resolved.
Member 11658469 5-Apr-18 7:42am View
   
Sir,

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

Sorry for using the Capital letters.
Member 11658469 5-Apr-18 4:38am View
   
I NEED TO GET DIFFERENT MOBILE NO UNDER SAME CPRCR USING LISTAGG.I AM GETTINH STRING TOO LONG EXCEPTION
Member 11658469 5-Apr-18 1:32am View
   
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
Member 11658469 4-Apr-18 9:14am View
   
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
Member 11658469 12-Apr-16 11:13am View
   
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
Member 11658469 12-Apr-16 10:29am View
   
Thanks for the reply.

How we set 2 directory version for same Application Pool.Please help.
Member 11658469 1-Mar-16 0:09am View
   
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.
Member 11658469 29-Feb-16 10:30am View
   
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.
Member 11658469 29-Feb-16 9:45am View
   
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.
Member 11658469 28-Feb-16 2:43am View
   
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.
Member 11658469 28-Feb-16 1:47am View
   
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.
Member 11658469 8-Nov-15 8:31am View
   
Please help...
Member 11658469 22-Oct-15 4:55am View
   
Its resolved thanks for the reply..
Member 11658469 22-Oct-15 3:46am View
   
That part also i tried but its not working..
Member 11658469 22-Oct-15 3:34am View
   
There is no server side code in the head tag.Just some javascript functions.
Member 11658469 5-Sep-15 11:14am View
   
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
Member 11658469 1-Jun-15 9:40am View
   
Hi,

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

Regards
Sreejith
Member 11658469 7-May-15 2:53am View
   
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
Member 11658469 4-May-15 10:50am View
   
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
Member 11658469 4-May-15 9:47am View
   
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
Member 11658469 4-May-15 9:45am View
   
HI,

Thanks for the reply.

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

Regards
Sreejith