Forum Replies Created

Viewing 15 posts - 61 through 75 (of 7,164 total)

  • RE: Best Approach For Junction Table Mainrenace

    vincentshanecurtis - Tuesday, August 22, 2017 10:35 PM

    In this case though I'm not deleting the primary record just trying to keep the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Invalid Date

    karl 93387 - Friday, July 21, 2017 2:19 PM

    where isdate(col) = 0

    careful using isdate when checking to see if...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Using Dynamic Query in a Transact SQL Select

    SQLRNNR - Tuesday, August 22, 2017 10:38 PM

    I would recommend a procedural language and not tsql for a problem such as this....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Using Dynamic Query in a Transact SQL Select

    imanalimi - Tuesday, August 22, 2017 8:49 PM

    Hi Guys,
    I am trying to calculate formula  using SQL Server 2016.
    How can I get the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: export data to Excel using sql stored procedure

    Jeff Moden - Tuesday, August 22, 2017 10:10 PM

    polo.csit - Tuesday, April 11, 2017 7:39 AM

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Practical usage of SQLCLR: Building QueryToHtml function

    Jeff Moden - Tuesday, August 22, 2017 9:41 PM

    Darko Martinovic - Tuesday, June 6, 2017 12:42 AM

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Practical usage of SQLCLR: Building QueryToHtml function

    Jeff Moden - Tuesday, August 22, 2017 9:43 PM

    Darko Martinovic - Tuesday, June 6, 2017 12:45 AM

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Practical usage of SQLCLR: Building QueryToHtml function

    Well done. I appreciate the effort required to put an article like this together let alone the coding to build the tool itself.

    I know a guy that hangs on this...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: export data to Excel using sql stored procedure

    Assuming this Excel file will not be so large that you cannot do this synchronously, reliably...another idea would be a design where the Excel file would be created by the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SQl Statement Need help with, please

    In addition to what you have tried so far, it also helps if you provide the table definitions in the form of CREATE TABLE statements, sample data in the form...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Add function to existing CLR assembly?

    You can definitely add a new method to an existing assembly. Altering the assembly will not automatically change the results of sys.assembly_modules. You also need to compile the complementary T-SQL object...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: QUERY HELP

    Happy to assist. Please help by posting the table definitions in the form of CREATE TABLE statements, sample data in the form of INSERT INTO statements, the expected results based...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Temporal SQL Server Databases

    @RandyAV, I read "Managing Time in Relational Databases" and am thoroughly enjoying the journey down the bi-temporal rabbit trail. I am driving a greenfield development effort at a large financial...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: The Bones of SQL - The Calendar Table

    corey lawson (9/8/2016)


    Good Friday was a "enterprise" business day off when I worked for company owned by Merrill Lynch, but that could also be because the NYSE is closed...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: The Bones of SQL - The Calendar Table

    Jo Pattyn (9/8/2016)


    Great article

    Could you change the where-clauses to use proper date-variables instead of strings

    WHERE CalendarDate BETWEEN convert(date,'2/27/2016',101) and convert(date,'3/1/2016',101)

    instead of

    WHERE CalendarDate BETWEEN '2/27/2016' and '3/1/2016'

    If you wanted to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 61 through 75 (of 7,164 total)