CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: chapran

Page 1 of 4 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    5
    Views
    4,301

    Re: SQL Server Errors

    The reason was found. Query Store General/Operation Modes settings were Off, then somebody changed them to Read write with Stale Query Treshold = 30 days. Then probably somebody ran some queries the...
  2. Replies
    5
    Views
    4,301

    Re: SQL Server Errors

    Schema and data. I also tried to split the file using online service. I created 10 files, and tried to run them one by one. First of all the first file took more than 10 minutes and finished with a...
  3. Replies
    5
    Views
    4,301

    [RESOLVED] SQL Server Errors

    Something happened to the SQL Server 2017 database size recently. I was 400MB and in one day it doubled its size.
    When exactly and why it happened nobody knows. The size of each table remains almost...
  4. Replies
    3
    Views
    2,658

    Re: Form on the form

    The previous attempt has frm, the last one is correct, no typo.
    Thank you
  5. Replies
    3
    Views
    2,658

    Form on the form

    I'm trying to implement VB.Net scenario in C#.
    In VB.Net I have an MDI application with MDI form and several child forms.
    MDI has a List Bar control on the left.
    Child forms load and occupying the...
  6. Thread: Select

    by chapran
    Replies
    2
    Views
    4,428

    Re: Select

    Sorry I do not understand your advice. Would you please give more details.

    Thank you
  7. Thread: Select

    by chapran
    Replies
    2
    Views
    4,428

    Select

    I need to create a select statement to get the list of PartialID with corresponding CommissionSplitPercent
    There is no direct relation between these values. This is my attempt graphically:

    35765...
  8. Re: Replace regular table with temporary in SQL Server

    Thank you very much for your help
  9. Re: Replace regular table with temporary in SQL Server

    Can you tell me if using ##TempTable is a bad way? If it is the same as #TempTable then I'm fine and wouldn't want to fight with this stuff anymore because my main area is VB6 development. SQL Server...
  10. Re: Replace regular table with temporary in SQL Server

    I cannot do this because I have dynamic selection (see my initial code).
    Thank you
  11. Re: Replace regular table with temporary in SQL Server

    I get this:


    Msg 208, Level 16, State 1, Procedure dbo.USP_TestTempTable, Line 11 [Batch Start Line 2]
    Invalid object name 'Status'.


    I understand that I have to have the table Status. It...
  12. Re: Replace regular table with temporary in SQL Server

    Any table I tried - Num, #TempTable and ##TempTable are used once. Num and ##TempTable work fine, #TempTable doesn't.
    Thank you
  13. Re: Replace regular table with temporary in SQL Server

    Sorry, but the sources I was working with say that the table may be created and populated with SELECT INTO, like my working code does:

    SET @sql = N'SELECT TOP ' + CAST(@QtyOfDays AS varchar(5)) +...
  14. Re: Replace regular table with temporary in SQL Server

    Right here by using SELECT INTO:

    ----Create Num table just for populating #Dates with all dates
    SET @sql = N'SELECT TOP ' + CAST(@QtyOfDays AS varchar(5)) + N' n = IDENTITY(INT, 1, 1) INTO...
  15. Replace regular table with temporary in SQL Server

    Replace regular table with temporary in SQL Server
    I have a stored procedure which has this code at the beginning (it is simplified to make it easier to understand)



    ALTER PROCEDURE...
  16. Replies
    2
    Views
    2,176

    Re: Copy SQL Server settings

    Doing research on internet I found some script allowing to see some settings. The difference I already see: On the production server the edition of SQL Server is standard, on my workstation it is...
  17. Replies
    2
    Views
    2,176

    Copy SQL Server settings

    My company upgraded SQL Server from 2008 R2 to 2017. I did the same upgrade on my development machine. Since that when I run VB6 program some processes produce errors on my local workstation with...
  18. Replies
    1
    Views
    4,501

    qbXML with QuickBooks Online

    My VB6 application communicates with Intuit QuickBooks desktop via special version of XML language qbXML. The application contains a pretty big number of procedures to send and receive data to and...
  19. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    Thank you. It looks to complex to work with variable table in my case - a lot of parameters and many tables are used in selections and filters. Variable tables are visible inside of dynamic string,...
  20. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    I have this in stored Procedure:



    DECLARE @1_Main TABLE (JobID int)

    --I create dynamic sql:
    If Not(@JobNumber Is Null)
    BEGIN
    SET @sql = N'
  21. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    2008 R2.
    As I know table variables are supported. I know nothing about table expression.

    Thank you
  22. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    Sorry for the delay. I had to finish and test to be sure that it works properly. The solution for AND I created looks like this:


    If Not(@JobNumber Is Null)
    BEGIN
    SET @sql = N'...
  23. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    I found solution.
  24. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    By some reason the button for code tag disappeared from my page. Next time I'll try to add manually.
    One more thing:
    The request was made more complex - users want to have the ability to set search...
  25. Replies
    22
    Views
    4,523

    Re: SQL Server UNION

    It looks like this now and it works. I just need to rewrite all IFs:

    If @DontDisplayArchivedData = 0
    BEGIN
    If Not(@JobNumber Is Null)
    BEGIN
    SET @sql = N'
    SELECT JobID
    FROM...
Results 1 to 25 of 91
Page 1 of 4 1 2 3 4





Click Here to Expand Forum to Full Width

Featured