Forum Replies Created

Viewing 15 posts - 391 through 405 (of 557 total)

  • RE: Random fill.

    spaghettidba (4/18/2014)

    My bad.

    The subquery returns always the same value because it is not correlated with the outer query.

    Well, looks like you solved your issue.

    This was the old solution.

    But I...

    April 18, 2014 at 8:23 am

    #1707084

  • RE: Random fill.

    spaghettidba (4/18/2014)

    This could be one way to do it.

    UPDATE T2

    SET SomeColumn = RandomValues.SomeValue

    FROM Table2 AS T2

    CROSS APPLY (

    SELECT TOP(1) SomeValue

    FROM Table1

    ...

    April 18, 2014 at 7:23 am

    #1707056

  • RE: recursive structure.

    Brandie Tarvin (4/16/2014)

    FYI: I added semi-colons to the above statements so you don't have to stick a ; before the WITH CTE statement. Not that it helps. Your lines don't...

    April 16, 2014 at 8:11 am

    #1706480

  • RE: recursive structure.

    Thanks Lowell for the example.

    I am trying to order the data which I have. Which is the relations between the 'child' and 'parent'.

    So I took your example and 'removed' the...

    April 16, 2014 at 3:38 am

    #1706373

  • RE: Need a query to select aggregate data by buckets

    SQL Guy 1 (3/24/2014)

    I have a table which has a unique integer column. It's not contiguous, it has some gaps.

    I need to find a count of records within...

    March 25, 2014 at 10:27 am

    #1699971

  • RE: Need help, SSIS:Multiple Flat files with diferent format

    Similar question from here.

    Regulary I want to import Excel files. (Or CSV files).

    Extention is known.

    Format is not predetermined.

    Is there a solution for this ?

    A general solution which imports data without...

    March 25, 2014 at 10:02 am

    #1699954

  • RE: SSIS importing of Excel information.

    JohnFTamburo (3/24/2014)

    Hi.

    1. What problems are you running into prior to using the SP?

    2. Exactly what solution are you trying to accomplish that the DTSX is not accomplishing for you?

    The question...

    March 25, 2014 at 6:12 am

    #1699822

  • RE: Number of times a function is accessed.

    SQLRNNR (2/6/2014)

    You can try this code that may get some execution counts for the function you are investigating.

    Thanks for the script, in the script I noticed a number of nested...

    February 6, 2014 at 9:14 am

    #1686661

  • RE: Number of times a function is accessed.

    Eugene Elutin (2/6/2014)

    If you want to see how many times any sql executed with calling this functions, Gail's suggestion with profile might help.

    But it has nothing to do with...

    February 6, 2014 at 8:02 am

    #1686619

  • RE: Number of times a function is accessed.

    GilaMonster (2/6/2014)

    ben.brugman (2/6/2014)

    To see how efficient code is working I want to count how many times a function is accessed.

    Depends on the execution plan. The rule that functions cannot have...

    February 6, 2014 at 7:56 am

    #1686613

  • RE: How to make a function a system function.

    Lowell (2/6/2014)

    i actually make things system functions , system procedures, and stuff quite a bit i have a ton of developer tools i've created and adapted that go in master.

    Do...

    February 6, 2014 at 6:08 am

    #1686563

  • RE: How to make a function a system function.

    Eugene Elutin (2/6/2014)

    As far as I am aware, it is impossible to create new system functions in SQL Server (unlike system procs).

    Closest think you might want to do is to...

    February 6, 2014 at 5:52 am

    #1686551

  • RE: How to make a function a system function.

    chetan.deshpande001 (2/6/2014)

    Just a thought ...

    why not use FQN (fully qualified name) to access function created in different database ?

    On a Single instance this would be a reasonable solution. But...

    February 6, 2014 at 5:44 am

    #1686547

  • RE: Filter using dates

    RTaylor2208 (11/29/2013)

    WHERE b.PropertyCode='PCH'

    AND b.CreatedON BETWEEN '2013-11-29' AND '2013-11-30'

    This will give you the time range '2013-11-29 00:00:00.000' till '2013-11-29-29 23:59:59.999' encompasing the whole day.

    Time (and datetime as wel) is...

    November 29, 2013 at 6:37 am

    #1669825

  • RE: Maximum output length in text for a query result.

    GilaMonster (11/29/2013)

    No. It's a property of the client tool only, not something that SQL Server sets within itself

    Thanks Gail,

    I thought so, but it's nice to know for sure.

    Are there suggestions...

    November 29, 2013 at 2:47 am

    #1669781

Viewing 15 posts - 391 through 405 (of 557 total)