Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 4,820 total)

  • RE: Confused about what function to create

    .Netter (6/16/2015)

    Hey,

    I can't provide any code, as I haven't got that far yet.

    I have built my UserSettings table where by I will be comparing the values between this table and...

    June 16, 2015 at 9:21 am

    #1805770

  • RE: SQL Join

    TomThomson (6/16/2015)

    sgmunson (6/15/2015)

    syed_3177 (6/14/2015)

    I have a right join query where i have a table where all employees attendence entry are registered and another table where pay master table.

    I need a...

    June 16, 2015 at 9:10 am

    #1805761

  • RE: SQL Join

    Alan.B (6/15/2015)

    sgmunson (6/15/2015)

    drew.allen (6/15/2015)

    sgmunson (6/15/2015)Also, just as a general rule, almost no one uses RIGHT joins because it's just not intuitive.

    I've actually wondered about this. I know this is...

    June 16, 2015 at 5:23 am

    #1805702

  • RE: Indexing a view

    richardmgreen1 (6/16/2015)

    The view takes a date given by the user and displays the data for that day. It then moves on a day and displays the data for for...

    June 16, 2015 at 5:14 am

    #1805696

  • RE: Group By in Sub query

    The proper forum is the MS Access forum, here:

    http://www.sqlservercentral.com/Forums/Forum131-1.aspx

    June 15, 2015 at 6:12 pm

    #1805619

  • RE: Group By in Sub query

    sakmsb (6/15/2015)

    sgmunson (6/15/2015)

    sakmsb (6/15/2015)

    The reason this doesn't work is because MS Access doesn't support quite the same set of SQL that SQL Server does. You posted in the...

    June 15, 2015 at 6:09 pm

    #1805618

  • RE: OPENROWSET problem

    Jeff Moden (6/15/2015)

    sgmunson (6/15/2015)

    Jeff Moden (6/12/2015)

    sgmunson (6/12/2015)

    Why don't they just use SSIS ? Even the import/export wizard in SSMS might be a better choice. I suspect...

    June 15, 2015 at 6:00 pm

    #1805617

  • RE: Group By in Sub query

    sakmsb (6/15/2015)

    I tried both of the queries posted by you guys but sadly they are just throwing an error.

    So basically I'd want these two queries to be one, both of...

    June 15, 2015 at 2:08 pm

    #1805575

  • RE: Indexing a view

    Let's start with the fact that the view does nothing but duplicate the new table's data 6 times but uses no GROUP BY or PIVOT to bring multiple rows into...

    June 15, 2015 at 1:57 pm

    #1805572

  • RE: OPENROWSET problem

    Jeff Moden (6/12/2015)

    sgmunson (6/12/2015)

    Why don't they just use SSIS ? Even the import/export wizard in SSMS might be a better choice. I suspect a registry permissions...

    June 15, 2015 at 1:38 pm

    #1805564

  • RE: No of Months between two dates in YYYYMM format

    sqlinterset (6/15/2015)

    I am looking to calculate no of months between two dates which are in YYYYMM format.

    Like no of months between 201505 and 201305

    WITH DATEFIELDS AS (

    SELECT DATEFIELD1 = '201503',...

    June 15, 2015 at 1:22 pm

    #1805561

  • RE: Seconds to AM/PM Time

    sqldummy79 (6/15/2015)

    I have tried to find a blog or forum for the following issue, if someone could provide a link or the code, it would be greatly appreciated.

    I have a...

    June 15, 2015 at 1:06 pm

    #1805552

  • RE: Question regarding database architecture

    kramaswamy (6/14/2015)

    Hi all,

    Not really an SQL Server 2008-specific question, but couldn't think of a better forum to place it in. I'm looking for some advice / suggestions on best practices...

    June 15, 2015 at 9:26 am

    #1805494

  • RE: SQL Join

    drew.allen (6/15/2015)

    sgmunson (6/15/2015)Also, just as a general rule, almost no one uses RIGHT joins because it's just not intuitive.

    I've actually wondered about this. I know this is true of...

    June 15, 2015 at 9:17 am

    #1805487

  • RE: How to do do data massage for this scenario

    koolme_85 (6/3/2015)

    i have a table in the following format

    FAFA_TypePIDFirstNameMiddleNameLastNameSplitNamesUserLogonImpersFirstNameImpersMiddleNameImpersLastNameprsn_position_descacc_id

    82P5 pri56785fnmem nameL nameJeanette RaylesJRAYLESJeanetteLeaRaylesBranch Manager68597050

    82P5 pri56785fnmem nameL nameJeanette RaylesJRAYLESJeanetteLeaRaylesBranch Manager68597051

    82P5 pri56785fnmem nameL nameJeanette RaylesJRAYLESJeanetteLeaRaylesBranch Manager68597052

    82P5 ...

    June 15, 2015 at 9:00 am

    #1805477

Viewing 15 posts - 3,646 through 3,660 (of 4,820 total)