Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: Noob xquery problem

    Thanks a ton for the help! Can the answer look different if you wanted to use node navigation? I think that's what I was trying to do the...

  • RE: Unexpected end of input error, another noob question

    That's about as simple as it gets, thanks a ton!

    -Ben

  • RE: XML Noob Question

    First off, thank you for such a detailed response! I'm in awe of your reply. That's a lot to digest and need to read through your reply multiple times,...

  • RE: Understanding the question at hand (word problems!)

    Thank you for replies everyone, glad that I'm not going crazy

  • RE: Query with most expensive CPU usage

    Grant Fritchey (2/5/2014)


    If you know you have a query that is causing performance problems, I'd start by looking at the code to see any of the common issues and then...

  • RE: Two results

    pietlinden (2/2/2014)


    Wouldn't OR'ing the two filters together do it?

    SELECT i.Configurtation_Item, COUNT(i.ID) AS CountID, I.Sub_Category

    FROM ConfigIssues AS i

    WHERE Configuration_Item LIKE '%outlook%' AND (Sub_Category LIKE '%Emails %' OR Sub_Category LIKE '%Managers %')

    GROUP...

  • RE: Two results

    sharonsql2013 (1/30/2014)


    I am looking to see the count of IDS, for both the sub categories separately . But don't know how to get it in one query

    Here is the query.

    SELECT...

  • RE: Virtualization and SQL Developer

    sql4gnt (1/29/2014)


    If you are doing it strictly for development purposes, then there shouldn't be any problem with just running a local instance of sql server.

    Personally, I run everything inside virtual...

  • RE: Volunteering to gain SQL experience

    All great ideas thanks guys!

  • RE: How to study for MCSA SQL Server 2012

    You've solidified my interest!... I'll be at both.

    -Ben

  • RE: Volunteering to gain SQL experience

    Pieter, as I'm faced with a similar circumstance I've elected to do the things that you had mentioned, starting a blog, being active in the forums, and have gotten in...

  • RE: Volunteering to gain SQL experience

    I appreciate your honesty about internships, they are very hit or miss. I've ordered the SS developer version this morning from Amazon, it'll be fun to see what is...

  • RE: Volunteering to gain SQL experience

    Thank you for advice Jeff Moden! I currently am working with SQL Server Express, but I only have it on one machine, and have been working through queries that...

  • RE: How to study for MCSA SQL Server 2012

    Just stumbled upon this post, and in close to the same boat as the OP. I'm interested in advice about volunteering... Also, being new to this is there any value...

  • RE: Last 3 months data

    Sean Lange (1/23/2014)


    rho_pooka (1/22/2014)


    Would something like this work? I wrote it in "notepad" so not sure if syntax is correct...

    SELECT *

    FROM Table

    WHERE Time_Open <= GETDATE()

    AND Time_Open >= DATE_SUB(MONTH, DATEDIFF(MONTH,...

Viewing 15 posts - 1 through 15 (of 25 total)