jacksonandrew321 (10/11/2014)

---

Hi Folks

I wrote query to update id int(1,1) to some value but its not giving me the result. Is it not possible to update id on the table. Please...

I'm not sure what you mean by "always the same." There are things that you can't do with Raw that you can with Path.

IF OBJECT_ID('XMLForHomework') IS NOT NULL DROP...

Great article. So far I have only had one employer mention reading my blog, which is still a little light, but is still a better representation of me than...

You can use the where or put the query into your XQuery (I don't know which is more efficient):

DECLARE @X XML;

DECLARE @CategoryID int = 9;

SET @X = '<root>...

SET @X = '<root>

<production.Categories categoryid="1" categoryname="Beverages" description="Soft drinks, coffees, teas, beers, and ales" />

<production.Categories categoryid="2" categoryname="Condiments" description="Sweet and savory sauces, relishes, spreads, and seasonings" />

...

I prefer to use Row_Number().

with cte as

(Select *

, row_number() over (Partition by [Doc#] order by Version Desc, [Occurrence #] Desc)

as RowNum from...

Uncheck the impersonate checkbox. I have never checked that and it works.

Select DueDate

, case when DateDiff(day, Current_timestamp, DueDate) >= 45

then 'YES' else NULL end as [45 Days Expectant]

, case when DateDiff(day, Current_timestamp, DueDate) <= -30

...

Which of the stairway articles are you looking at? In the second one, he is connecting to the Person.Contact table not the Person.Person table.

rho_pooka (2/19/2014)

---

I'm working through the 70-461 training book, and have gotten to the chapter about XML. If I'm querying element centric XML would the following code be the most...

When you say, "not working" what do you mean? Do you get an error? Do you get unexpected results? If unexpected results, what are the values that...

imba215 (2/17/2014)

---

Hello!

I have two tables with this info:

TABLE 1

COL1 COL2 COL3

AAA BBB CCC

QQQ WWW EEE

AAA SSS DDD

WWW EEE RRR

BBB BBB BBB

TABLE 2

COL1 COL2 COL3 COL4

b b b 343

a a a...

complexType can have sequence as a sub-element. http://www.w3schools.com/schema/el_complextype.asp

xs:complexContent cannot have xs:sequence as a child. You can have xs:extension or maybe xs:restriction which in turn can have xs:sequence as its child.

http://msdn.microsoft.com/en-us/library/ms256053(v=vs.110).aspx

One correction (I'm getting used to user interface). You need to order by RankID:

WITH cteUsersAndSoftware(UserName, Software)

AS

(

SELECT DISTINCT s.User_Domain0 + '\' + s.User_Name0 AS 'UserName',

(CASE

WHEN p.DisplayName0 LIKE 'Microsoft Visual Studio%...