Forum Replies Created

Viewing 15 posts - 3,811 through 3,825 (of 26,490 total)

  • RE: t-sql 2012 date 1900-01-01

    And to the that other part of your question about alternative data types, don't. Use the appropriate date/time data type for the date/time column in your table. You...

  • RE: Are the posted questions getting worse?

    Solomon Rutzky (5/14/2016)


    Lynn Pettis (5/13/2016)


    Jacob Wilkins (5/13/2016)


    Lynn Pettis (5/13/2016)


    Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need...

  • RE: Scripts Library

    Alan.B (5/13/2016)


    Lynn Pettis (5/13/2016)


    Alan.B (5/13/2016)


    Lynn Pettis (5/13/2016)


    Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find...

  • RE: Scripts Library

    Alan.B (5/13/2016)


    Lynn Pettis (5/13/2016)


    Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them since there...

  • RE: Would You Move For a Job?

    Eric M Russell (5/13/2016)


    Personally, I don't like it when a recruiter or agency wants to make all the arrangements without me having a face to face with the employer. I...

  • RE: Would You Move For a Job?

    below86 (5/13/2016)


    I've got a phone interview set up for next week. Any advice? I have never had to do a phone interview. This is just a phone...

  • RE: Are the posted questions getting worse?

    Jacob Wilkins (5/13/2016)


    Lynn Pettis (5/13/2016)


    Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a...

  • RE: Are the posted questions getting worse?

    Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a few short string values.

    Thanks.

  • RE: Rows duplicating for each person

    b.grove (5/13/2016)


    I'm confused. I already have a document table with the exact same data in it called Dcoument Signed

    So why create another document table duplicating the existing Document Signed...

  • RE: Rows duplicating for each person

    b.grove (5/13/2016)


    Hi, Thank you for helping. I really need another pair of eyes to look at this and offer suggestions. I have tried everything, code wise to get...

  • RE: Scripts Library

    Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them since there are no links...

  • RE: how to count number of student

    RV16 (5/13/2016)


    I applied this query:

    SELECT SM.yr_cde,

    SM.trm_cde,

    SS.room_cde,

    SS.bldg_cde,

    SS.loc_cde,

    SS.crs_cde,

    SM.short_crs_title_1,

    SS.monday_cde,

    SS.tuesday_cde,

    SS.wednesday_cde,

    SS.thursday_cde,

    SS.friday_cde,

    SS.saturday_cde,

    SS.sunday_cde,

    SS.begin_tim,

    SS.end_tim,

    SS.days_tim_ovrid,

    SS.begin_dte,

    SS.end_dte,

    SS.comment_txt,

    SS.seq_num_2,

    SM.x_listed_parnt_crs,

    count(SCH.ID_NUM) "No of student"...

  • RE: Need help on Sorting...

    GilaMonster (5/13/2016)


    This looks like Oracle code.

    While some people do know Oracle, this is a SQL Server forum (as in Microsoft SQL Server), and that's what most answers will be written...

  • RE: Rows duplicating for each person

    Once again with feeling:

    Since we can't see what you see you need to help us more. The DDL (CREATE TABLE statement) for the table(s) involved (can be shortened to just...

  • RE: Rows duplicating for each person

    R.P.Rozema (5/13/2016)


    Lynn Pettis (5/12/2016)


    Thought I'd reformat your code some and replace the 3-part naming convention you used with 2-part naming using table aliases. This is important as Microsoft has...

Viewing 15 posts - 3,811 through 3,825 (of 26,490 total)