Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 8,731 total)

  • RE: Maximum number of CROSS APPLY functions

    The Dixie Flatline (10/4/2016)

    Define cascading please. Output from itvf_1 becomes input to itvf_2 ??

    That's exactly it.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2016 at 1:05 pm

    #1904734

  • RE: Generate Create Script for a table - include indexes, keys, statistics

    Would a T-SQL option help?

    http://www.sqlservercentral.com/scripts/SQL+Server+2005/67515/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2016 at 11:08 am

    #1904704

  • RE: Parse street

    Here's an option that doesn't need additional functions.

    This will fail without warning if the street name has a number.

    DECLARE @SourceTable TABLE (

    ID INT IDENTITY(1,1)

    ,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2016 at 9:06 am

    #1904683

  • RE: count every hour per day

    joanna.seldon (10/4/2016)

    Hi

    I have got this far using your query

    SELECT dateadd(hour, datediff(hour, 0, a.StartDate ), 0) as TimeStampHour, Count(*)

    FROM Database.dbo.MainTable a

    Where a.StartDate >='20160101'

    and a.Department like 'Catering%'

    GROUP BY dateadd(hour, datediff(hour,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2016 at 7:47 am

    #1904662

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/3/2016)

    What ever happened to basic problem solving skills?

    Why would want something like that? It's overrated. Especially when you have a bunch of experts at your service handling crystal...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 2:22 pm

    #1904558

  • RE: split string by number of characters

    Hi Alan, you're still missing the GetNumsAB definition. I'd be interested on checking out how everything works. 🙂

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 12:58 pm

    #1904528

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/3/2016)

    Okay, post a question then a few minutes later post an "answer" that they say works and not to post to that thread. Fine, except what was...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 12:34 pm

    #1904515

  • RE: maxrecursion Other Option

    patla4u (10/3/2016)

    If I use maxrecursion in query, is this change server level the thesold or database level ?

    Can I implement in production ? What is the advantage and disadvange...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 11:21 am

    #1904489

  • RE: Are the posted questions getting worse?

    jasona.work (10/3/2016)

    Ugh...

    Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 11:00 am

    #1904476

  • RE: maxrecursion Other Option

    If you post your code with sample data, you might get an alternative to the code.

    The reason to prevent the use of maxrecursion is that it might not be necessary...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 10:31 am

    #1904471

  • RE: split string by number of characters

    The simple answer would be to use something like this:

    DECLARE @myv VARCHAR(MAX) = 'AB,CD,EF,GH,IJ';

    WITH

    E(n) AS(

    SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

    ),

    E2(n) AS(

    SELECT a.n...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 9:47 am

    #1904449

  • RE: Difference between MySQL and Oracle? What's better?

    andrew gothard (10/3/2016)

    To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 9:38 am

    #1904445

  • RE: How to get date??

    peter478 (10/3/2016)

    Thank you Luis, I would need something on Access, some tips how to do it, I hope I will find something.

    Google the functions and change them to the Access...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 8:37 am

    #1904421

  • RE: How to get date??

    Since you only want an example, here's one that works on SQL Server.

    If you want to make it work on Access, you have to find the correct function names and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 8:16 am

    #1904413

  • RE: Maximum number of CROSS APPLY functions

    ZZartin (10/3/2016)

    Eirikur Eiriksson (10/2/2016)

    Quick thought, I wouldn't expect the optimizer to do anything but abort the optimizing process on a time out when handling queries with hundreds of apply operators.

    😎

    It...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2016 at 8:05 am

    #1904409

Viewing 15 posts - 2,086 through 2,100 (of 8,731 total)