Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 15,381 total)

  • RE: The View Insert

    Great question. Oddly after answering I decided to see if it really would correctly. I ran the create table and view scripts. Then ran the insert statement. It says 1...

    July 14, 2016 at 7:41 am

    #1890106

  • RE: Microsoft SQL Developer Certification For beginers

    kailashsingh85 (7/13/2016)

    Kindly suggest exam book for Microsoft SQL DBA and SQL Developer Certification for 1st Level.

    No offense but it doesn't sound like you need an exam book yet. The exam...

    July 14, 2016 at 7:30 am

    #1890100

  • RE: Select vs Set Local Variable

    Mohit Dhiman (7/14/2016)

    Sean Lange (7/13/2016)

    Mohit Dhiman (7/13/2016)

    Even with the primary clustered key, are we sure here that the select always returns 2 at the last?

    Wonder why they always used...

    July 14, 2016 at 7:28 am

    #1890099

  • RE: t-sql 2012 datatype

    wendy elizabeth (7/13/2016)

    What other data type would you recommend? That is large but not as large as varchar(max) is?

    Define large. A varchar can be as large as varchar(8000). That is...

    July 13, 2016 at 3:29 pm

    #1889982

  • RE: How to use a table value function that splits a string

    NineIron (7/13/2016)

    I have a TVF that takes two parameters, string and delimter but, I don't know how to pass the field values into the function in order to get my...

    July 13, 2016 at 12:51 pm

    #1889944

  • RE: Select vs Set Local Variable

    Mohit Dhiman (7/13/2016)

    Even with the primary clustered key, are we sure here that the select always returns 2 at the last?

    Wonder why they always used to tell us there...

    July 13, 2016 at 8:17 am

    #1889868

  • RE: t-sql 2012 datatype

    Jason-299789 (7/13/2016)

    Sean,

    Don't some of the Internal Diagnostic views still use TEXT data types or have they all been changed to (n)varchar(max) datatypes?

    I also believe that when you pipe an...

    July 13, 2016 at 8:15 am

    #1889866

  • RE: Microsoft SQL Developer Certification For beginers

    kailashsingh85 (7/13/2016)

    Hello,

    Anyone suggest for Microsoft SQL DBA Certification For beginners.

    Please let me know topics, exam level wise, fee where we can attend.

    Thanks,

    Kailash

    Maybe start with google?

    July 13, 2016 at 7:22 am

    #1889847

  • RE: Microsoft SQL Developer Certification For beginers

    kailashsingh85 (7/13/2016)

    Hello,

    Anyone suggest for Microsoft SQL Developer Certification For beginners.

    Please let me know topics, exam level wise, fee where we can attend.

    Thanks,

    Kailash

    Maybe start with google?

    July 13, 2016 at 7:22 am

    #1889846

  • RE: t-sql 2012 datatype

    durga.palepu (7/12/2016)

    text datatype is supported in SQL 2012 but will be deprecated in future versions.

    alternative is to use varchar(max) and if you need multilingual support use nvarchar(max) datatype.

    Thanks,

    Durga

    Actually it has...

    July 13, 2016 at 7:18 am

    #1889845

  • RE: Subquery Question

    SQLPain (7/12/2016)

    Thanks Sean, what would be the correct statement, Im using this.

    (SELECT MAX(COUNT(C.AppID) WHERE C.Status = 'Funded')

    Can we do MAX on aggregates?

    No you can't nest aggregates. There seems to be...

    July 12, 2016 at 3:53 pm

    #1889739

  • RE: t-sql 2012 datatype

    I agree with Grant 100000% on not using text. My only change would one of not being as subtle as "you shouldn't use the text datatype". I would say you...

    July 12, 2016 at 3:50 pm

    #1889738

  • RE: Subquery Question

    SQLPain (7/12/2016)

    Facilitator is text field, that's why subquery not a JOIN

    Clearly is isn't a text field or your query wouldn't work. It must be a varchar.

    Regardless I don't see what...

    July 12, 2016 at 3:35 pm

    #1889736

  • RE: Subquery Question

    SQLPain (7/12/2016)

    I am using the following query to see how many apps were approved, funded, etc from the following facilitators:

    SELECT DISTINCT

    C.Facilitator

    ,ISNULL((SELECT COUNT(C.AppID) WHERE C.Status = 'Funded'), 0) AS [Funded...

    July 12, 2016 at 3:06 pm

    #1889732

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/12/2016)

    Now to try and motivate him to finish the last couple merit badges.

    Another challenge is getting them motivated to do the presentation to the council....

    July 12, 2016 at 9:25 am

    #1889635

Viewing 15 posts - 1,396 through 1,410 (of 15,381 total)