Search:

Type: Posts; User: sapator

Page 1 of 13 1 2 3 4

Search: Search took 0.39 seconds.

  1. Replies
    9
    Views
    352

    Re: eliminate multiple zeros

    This is closer:


    With V_CTE(Collected_WorkstationCode,Status,Value,Total)
    AS
    (select Collected_WorkstationCode, 'V' as Status, sum(gross2) as Value, sum(gross2) as Total
    from...
  2. Replies
    9
    Views
    352

    Re: eliminate multiple zeros

    I need the total of V '2823,02' added to the total of Total of C '7,50'
  3. Replies
    9
    Views
    352

    Re: eliminate multiple zeros

    Hi.
    Thanks for that but either way I would still have to sum 2 different columns as I state next.
    I have no idea how I can do this
    Thanks.
  4. Replies
    9
    Views
    352

    Re: eliminate multiple zeros

    This is what I did:
    Collected_WorkstationCode Status Value Total C
    RenBox4 C -7,50 7,50 -7,50
    RenBox4 V 2823,02 0,00 2823,02

    I have a hidden column 'Total'
    What I need to do is when status is...
  5. Replies
    9
    Views
    352

    Re: eliminate multiple zeros

    Me too but I get, not contained in either an aggregate function or the GROUP BY

    I have fixed this with A UNION AND CTE but now I have another issue:


    With V_CTE(Collected_WorkstationCode,V,C)...
  6. Replies
    9
    Views
    352

    eliminate multiple zeros

    Hi.



    select Collected_WorkstationCode, sum(gross2) as V,
    CASE WHEN gross < 0 THEN sum(gross) ELSE sum(0) END AS C
    from [dbo].[EAI_SourceData] where cinema = 01
    and COLLECTED_DATE =...
  7. Replies
    2
    Views
    482

    Re: Same navbar on multiple pages.

    Hello.
    If you where using asp.net I would have suggested Master Pages.
    In PHP , have a look here , maybe it can help you do the same:...
  8. Re: Find value that is not included in a group of rows.

    Hi.
    Thanks I will have to remake the tables when I get the chance and try this, as we are constantly on and off from work due to the covid BS.
    So I just got to the office today from September 8th...
  9. Replies
    3
    Views
    836

    Re: Asp.net webforms listbox

    Not sure if you still have the issue but,
    I haven't read throughout the code as am in a hurry but if I understand correctly you expect to add items that they don't appear.
    Try using not...
  10. Re: Find value that is not included in a group of rows.

    WebPayTN_lngPayTransNumber WebPayLog_strStep
    100000001 StoreTransDetails
    100000001 GetPurchaseInfo
    100000001 RedirectionInfo
    100000001 GetPurchaseInfo
    100000001 RedirectionInfo...
  11. Re: Find value that is not included in a group of rows.

    That will give me a empty table
    with both:




    SELECT
    WebPayLog_strStep
    FROM tblWebPaymentModuleLog
    EXCEPT
  12. Find value that is not included in a group of rows.

    Hello.

    I have

    WebPayTN_lngPayTransNumber, WebPayLog_strStep
    1 BankResponseRaw
    1 NOTBankResponseRaw
    1 ...
  13. Replies
    13
    Views
    621

    Re: Employee monitoring software- pls help!

    I don't think software usage per hour will do something for you.Unless the software is a call centre.
    I'm at home half of the month due to covid and I actually finishing more tasks will a lot less ...
  14. Replies
    2
    Views
    883

    Re: newbie creating report questions

    Hello.
    http://vb.net-informations.com/crystal-report/vb.net_crystal_report_load_dynamically.htm
  15. VS 2010 Re: [RESOLVED] Crystal Report: Object reference not set to an instance of an object

    NP.
    You're welcome.
  16. VS 2010 Re: Crystal Report: Object reference not set to an instance of an object

    What type is the Crystal Report File?
  17. VS 2010 Re: Crystal Report: Object reference not set to an instance of an object

    I would suggest a clear remove of all the CR installed in Program and Features and then a restart of the machine and then install again.
    Also re - drag and drop any CR component in VS FORM
    Also...
  18. VS 2010 Re: Crystal Report: Object reference not set to an instance of an object

    CrystalDecisions.CrystalReports.Engine.dll
    CrystalDecisions.ReportAppServer.ClientDoc.dll
    CrystalDecisions.ReportAppServer.CommLayer.dll
    CrystalDecisions.ReportAppServer.CommonControls.dll...
  19. VS 2010 Re: Crystal Report: Object reference not set to an instance of an object

    A couple of things tho.
    If you are running this from another machine then you need to install the crystal report runtime in that machine.
    Also take a look at one folder that I am using crystal...
  20. Re: Connection String Issue - Could Not Find Installable ISAM

    I'm not sure of the behavior of ADODB in newer jet engine.
    I would suggest using System.Data.OleDb.OleDbConnection
  21. VS 2010 Re: Crystal Report: Object reference not set to an instance of an object

    Take a look at the bin folder when you run the application outside of VS.
    Make sure the crystal report dll files are in there.
  22. I need to find what function in dll a program is running.

    Hi.
    Firstly.
    YES, it a hack. :eek:
    The company that support one of our apps just when on a vacation rampage so I'm trying to examine the flow of their app so I can fix a bug we are getting because...
  23. Re: Strange Windows update that included BIOS recovery

    We have found a Microsoft - I better had a virus that this one, update in the company that crashed several PC's, well all where Laptops to be exact .
    I think is either 1040 or 1020 ? Something in...
  24. Replies
    1
    Views
    380

    Re: database mail error

    You don't provide much info on what you do.
    But take a look here?
    https://support.microsoft.com/en-us/help/2837910/fix-error-1222-when-you-use-service-broker-in-sql-server-2012
  25. Replies
    22
    Views
    831

    Re: WHO needs to get it together

    Can't believe someone did not post this yet:
    https://www.youtube.com/watch?v=qjN5uHRIcjM
  26. Re: How to set a global connection string for all crystal reports in my project

    No problem.
    As I've said I don't know if this a common practice .
  27. Re: How to set a global connection string for all crystal reports in my project

    Personally I use a class that I put any needed config file connection and reference them.
    I don't know if this a common practice but It sums the connections into a Class that can be easily...
  28. Replies
    64
    Views
    1,765

    Re: What was your last purchase?

    We are a smaller economy so we kinda have almost every product.
    Also 10 years on crisis is a benefit on these situations. We are already in panic for 10 years so we've learned to control it :D
  29. Replies
    12
    Views
    628

    Re: substring begin end

    DECLARE @string VARCHAR(500) = 'h&eloooblaAblblbsdf&TransactionId=1231234&Trmkdf$&hellooo'

    select CHARINDEX('&', @string, PATINDEX('&Transaction', @string)+1)


    Still gives 2 but no worries,...
  30. Replies
    1,499
    Views
    65,946

    Re: Corona virus, China major city lockdowns, etc.

    Same here.
    Unfortunately I'm one of the few that will "close the door" after everyone else works from home. :mad:
  31. Replies
    1,499
    Views
    65,946

    Re: Corona virus, China major city lockdowns, etc.

    Turkish agents and other tribes.
    5% Syrians.
    Syrians are quite welcome. The rest are quite unwelcome.
  32. Replies
    1,499
    Views
    65,946

    Re: Corona virus, China major city lockdowns, etc.

    OK.
    No prob, see you in a couple of months when the... FLUE goes away.
  33. Replies
    1,499
    Views
    65,946

    Re: Corona virus, China major city lockdowns, etc.

    Just bumping for the "in your face" reminder at summer.
    Take care,thanks.
    :bigyello:

    P.S.
    99 Cases in Greece....Gooooo foorrr 100!!!! Go go gooooo!!
    99 cases 1 death.

    1 Case in Turkey. Long...
  34. Replies
    64
    Views
    1,765

    Re: What was your last purchase?

    So you gave $629.30 for a gaming monitor.
    Anddd then you gave another $629.30 for a programming monitor?

    :p
  35. Replies
    3
    Views
    498

    Re: XML for Crystal Reports

    Hi.
    Had huge problems with Crystal and was based on the CR version. Some versions work some version (does not matter if newer, for example show pdf newer version fails) do not.
    I'm not saying that...
  36. Replies
    12
    Views
    628

    Re: substring begin end

    I Think this might work?



    DECLARE @string VARCHAR(500) = 'h&eloooblaAblblbsdf&TransactionId=1231234&Trmkdf$&hellooo'
    select CHARINDEX('&', @string, CHARINDEX('TransactionId=', @string,1))

    ...
  37. Replies
    12
    Views
    628

    Re: substring begin end

    Again
    This is wrong


    DECLARE @string VARCHAR(500) = 'h&eloooblaAblblbsdf&TransactionId=1231234&Trmkdf$&hellooo'

    select CHARINDEX('&', @string, PATINDEX('&%Transaction', @string)+1)


    What...
  38. Replies
    12
    Views
    628

    Re: substring begin end

    I can't mess with the compatibility level on company databases.
    Yes I have no issue with the starting value, I have an issue with the ending value (TransactionId=1231234& ) . I don't know how I will...
  39. Replies
    12
    Views
    628

    Re: substring begin end

    Hi @ GaryMazzone .
    This will give out
    TransactionId=12312

    String_Split is not available in the db I'm using
    About PATINDEX-Function this will find the first occurrence and that is fine but...
  40. Replies
    12
    Views
    628

    substring begin end

    Hi.

    A text like heloooblaAblblbsdf&TransactionId=1231234&Trmkdf$hellooo....

    I want to get the begin end of TransactionId so either TransactionId=1231234 or just 1231234
    With the below I get...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width