Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 1,413 total)

  • Reply To: Recursive function parent-child in t-sql

    The code you provided executed without error and returned 24 rows.  The two temp tables have identical DDL so it seems to maybe make sense to do UNION ALL and...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 19, 2019 at 6:17 pm

    #3681527

  • Reply To: how to call same logic using different parameter in if then else stored procedur

    Could be something like this

    ALTER PROCEDURE [dbo].[employee]
    @isemployee int
    AS
    BEGIN
    DECLARE @Email Varchar (100)
    DECLARE @Name Varchar (100)

    IF (@isemployee = 0)
    BEGIN
    SELECT @Email = text from dbo.emailtable WHERE email = 'XXX'
    SELECT @Name...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 19, 2019 at 5:24 pm

    #3681515

  • Reply To: Stored Procedure

    This code has the 3 ranking methods (row_num, row_rank, and dense_row_rank) and joins to itself twice to get the next and previous list members.  The ORDER BY for the rankings...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 19, 2019 at 2:55 pm

    #3681440

  • Reply To: Which items can be built (do we have enough product for)?

    One sane way to allocate inventory is to do it when the invoices are generated.  Is the purpose here to answer the question "how many of which products can I...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 18, 2019 at 11:46 am

    #3681036

  • Reply To: Logical reads and its size

    It must be for testing.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 13, 2019 at 5:39 pm

    #3679897

  • Reply To: Logical reads and its size

    Jonathan AC Roberts wrote:

    I use this query to find the details of the last time a query was run

    Could you explain please why the guid is there?

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 13, 2019 at 5:05 pm

    #3679884

  • Reply To: Search box returns error when clicked

    In this link: https://wordpress.org/support/topic/strange-search-error/

    The user 'rundlof' wrote:

    I have seen this on non-WordPress sites too, only Chrome. I believe it is an autocomplete entry created as a result of an error...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 13, 2019 at 11:42 am

    #3679774

  • Reply To: wierd type conversion error

    This works:

    declare @v table(
      varchar_id varchar(36));
    declare @u table(
      unique_id uniqueidentifier);

    insert @v(varchar_id) values('09C4C7B4-1275-460A-AE23-FFA9256B1ABE');

    insert @u(unique_id) select * from @v where varchar_id='09C4C7B4-1275-460A-AE23-FFA9256B1ABE';

    select * from @v v join @u...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 12, 2019 at 12:28 pm

    #3679448

  • Reply To: Search box returns error when clicked

    If I paste the entire error message into notepad it says:

    Error: An invalid email address was specified for 'em'. This data will not be sent with any events for this...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 11, 2019 at 6:49 pm

    #3679273

  • Reply To: Search box returns error when clicked

    Yes it still happens after the reboot.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 11, 2019 at 6:39 pm

    #3679272

  • Reply To: Search box returns error when clicked

    It's Chrome.  I closed and opened the browser a couple of times and it occurs again.  I'll reboot.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 11, 2019 at 6:36 pm

    #3679268

  • Reply To: SQL Lite Data Types VS T-SQL Data Types

    Could you explain a little more what you're trying to accomplish?  Sql Lite and Sql Server are very different databases.  From a Sql Server perspective there are a bunch of issues...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 11, 2019 at 2:27 pm

    #3679133

  • Reply To: External Images

    The short answer is no.  Ideally the "share drive" would not be read from by your reporting server and definitely not by letter-aliased file path.  In reality it always depends. ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 11, 2019 at 1:54 pm

    #3679124

  • Reply To: Problem with simple stored procedure

    michael.leach2015 wrote:

    I tried another simple stored procedure above, which I executed.  It didn't display the results window for the SELECT statement result at this time.

    Not sure which proc with what...

    • This reply was modified 6 years, 9 months ago by Steve Collins. Reason: Matched the (useless) capitalization

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 11, 2019 at 1:27 pm

    #3679118

  • Reply To: External Images

    What lead you to conclude it was the images which were causing the render to take so long?  400 thumbnails are tiny.  Is there a query being run too?

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    September 10, 2019 at 9:04 pm

    #3678916

Viewing 15 posts - 1,321 through 1,335 (of 1,413 total)