dcsimg
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.03 seconds.

  1. Re: Replace regular table with temporary in SQL Server

    Thank you very much for your help
  2. 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...
  3. Re: Replace regular table with temporary in SQL Server

    I cannot do this because I have dynamic selection (see my initial code).
    Thank you
  4. 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...
  5. 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
  6. 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)) +...
  7. 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...
  8. 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...
  9. Replies
    2
    Views
    120

    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...
  10. Replies
    2
    Views
    120

    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...
  11. Replies
    0
    Views
    373

    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...
  12. Replies
    22
    Views
    1,509

    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,...
  13. Replies
    22
    Views
    1,509

    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'
  14. Replies
    22
    Views
    1,509

    Re: SQL Server UNION

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

    Thank you
  15. Replies
    22
    Views
    1,509

    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'...
  16. Replies
    22
    Views
    1,509

    Re: SQL Server UNION

    I found solution.
  17. Replies
    22
    Views
    1,509

    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...
  18. Replies
    22
    Views
    1,509

    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...
  19. Replies
    22
    Views
    1,509

    Re: SQL Server UNION

    You gave me a great scenario. Your code doesn't work, but it is my part to adjust. I beleive it will work.
    Thank you very much again.
  20. Replies
    22
    Views
    1,509

    Re: SQL Server UNION

    Wow! So elegant! Thank you very much!
  21. Replies
    22
    Views
    1,509

    Re: SQL Server UNION

    More help is required.
    How to add dependancy on parameters?
    Thank you very much
  22. Replies
    22
    Views
    1,509

    SQL Server UNION

    I have a stored procedure in SQL Server for search:


    ALTER PROCEDURE [dbo].[SopaSearch_Search]
    @JobNumber varchar(9)=Null,
    @JobName varchar(50)=Null,
    @JobLocation varchar(50)=Null,
    @BidDate...
  23. Replies
    12
    Views
    1,001

    Re: Graphic Problem

    I said about MDI just to give as much info as I could. Gray covers appear on some other screens where no WEB controls exist. It is always after some other window covers some area and then is closed....
  24. Replies
    12
    Views
    1,001

    Re: Graphic Problem

    Refresh methods were used. OS is Win 7 64 bit Ultimate with SP 1:

    35349

    VB:

    35351

    Thank you.
  25. Replies
    12
    Views
    1,001

    Re: Graphic Problem

    Sheridan is not covered by gray. ListBox from MS and WEB Browser. Later fter posting this topic I added a standard combobox and it is problematic as well.
    WEB control is fixed by the code I showed...
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)