Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 15,381 total)

  • RE: Alternative to EAV model

    Bhushan Kulkarni (12/21/2015)

    Hi,

    In our project, we have requirement such that user can set user defined properties for Entities- these properties will be dynamic.

    So we implemented it using EAV model.

    Base table...

    December 21, 2015 at 7:27 am

    #1847116

  • RE: Multiple parameter function !

    Ed Wagner (12/21/2015)

    If your goal is to pass a list of values to your function and then treat it as a table to perform a query, you could pass a...

    December 21, 2015 at 7:18 am

    #1847113

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/20/2015)

    jasona.work (12/18/2015)

    Ed Wagner (12/18/2015)

    jasona.work (12/18/2015)

    The way things go around here this week and next, I think they should just make it official...

    Starting 7 working days before X-Mas, each...

    December 21, 2015 at 6:59 am

    #1847109

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/18/2015)

    Sean Lange (12/18/2015)

    Back from Disney and bringing you a song in the holiday spirit...

    C’mon, sing it with me! Oooooooooohhhhhhhh……

    He's making a database

    He's sorting...

    December 18, 2015 at 9:49 am

    #1846830

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/18/2015)

    Sean Lange (12/18/2015)

    Back from Disney and bringing you a song in the holiday spirit...

    C’mon, sing it with me! Oooooooooohhhhhhhh……

    He's making a database

    He's sorting it twice

    SELECT *...

    December 18, 2015 at 8:40 am

    #1846805

  • RE: Changing a computed column

    Xavon (12/18/2015)

    Trying to figure out what the question had to do with a computed column had me stymied for a few minutes. I kept going back over it, trying...

    December 18, 2015 at 8:29 am

    #1846799

  • RE: Creating Trigger

    PJ_SQL (12/15/2015)

    This is my trigger:

    CREATE TRIGGER TRG_A

    ON _A

    AFTER INSERT, UPDATE

    AS

    insert into _B

    SELECT * FROM inserted

    where c is not null

    How do I incorporate in this?

    Thank you.

    Two things...

    December 18, 2015 at 8:03 am

    #1846786

  • RE: Are the posted questions getting worse?

    Back from Disney and bringing you a song in the holiday spirit...

    C’mon, sing it with me! Oooooooooohhhhhhhh……

    He's making a database

    He's sorting it twice

    SELECT * from contacts WHERE behavior...

    December 18, 2015 at 7:58 am

    #1846784

  • RE: Are the posted questions getting worse?

    BrainDonor (12/10/2015)

    Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/

    OMG that is awesome!!!

    December 10, 2015 at 8:33 am

    #1845245

  • RE: Table vs View vs UserDefined Function - Which will give more performance

    karthik82.vk (12/10/2015)

    Hi,

    I am thinking of creating a column store index for the table i am using?

    Is there any specifications for creating it?

    Yes those specifications can very easily be found by...

    December 10, 2015 at 7:54 am

    #1845222

  • RE: how to speed up sp_testlinkedserver

    dschlobohm (12/9/2015)

    it is actually taking 40 seconds and the servers are not even on

    i did change the remote login from 30 seconds to 15 seconds

    and now the sp_testlinkserver...

    December 9, 2015 at 12:59 pm

    #1845031

  • RE: Is this possible?

    Like this?

    select top 1

    Patient_Status

    , Patient_Sub_Status

    , Status_Date

    , patient_id

    from YourTable

    order by Status_Date desc

    December 9, 2015 at 10:50 am

    #1845008

  • RE: Parse string from URL between...

    Luis Cazares (12/9/2015)

    Sean Lange (12/9/2015)

    I like this approach but not sure why it is safer. It is easier to maintain for sure since it removed the duplicate charindex function.

    It doesn't...

    December 9, 2015 at 10:44 am

    #1845007

  • RE: Select a column not in Group By clause

    taseedorf (12/9/2015)

    Sorry to be a troll, but....

    It is emergency because my friend asked me...

    NO...come on.

    Please note....this thread is 5 years old.

    December 9, 2015 at 10:34 am

    #1844998

  • RE: Is this possible?

    cory.bullard76 (12/9/2015)

    Ok, here's the data example

    Status SubStatus ...

    December 9, 2015 at 10:32 am

    #1844997

Viewing 15 posts - 1,951 through 1,965 (of 15,381 total)