Doctor Who 2 (5/20/2014)

---

Steve Jones - SSC Editor (5/19/2014)

---

Doctor Who 2 (5/19/2014)

---

This is the second time, in this thread, that the idea of hiring a recruiter has come up. (It...

Also - you might care to switch over to using FOR XML PATH rather than EXPLICIT. You will get the same level of control over the content and layout,...

jasona.work (5/9/2014)

---

An advantage I can think of to using two (or more) individual monitors over one large one is, if you maximize a window in a dual monitor setup, it...

It's hard to tell at this point. Is there any way you can provide a bit more detail around the nature of the "update" you're doing?

If you're looking to...

Sure - just fire on back if you have questions.

DECLARE @ModelStore VARCHAR(8)

SET @ModelStore = 'North'

;with nonmodelStores as (select storeID from #Stores where StoreID<>@ModelStore),

nonmodelinv as (select storeID, productID from #StoreInventory...

0

This comes...

I was going to go down the route of a CTE as well, but the OP mentioned 2005.

I don't think you're doing yourself any favors doing a blind seek for nodes and then filtering them in the xml.query() method.

I suspect you'd get a LOT more out...

You should certainly use the appropriate data types. That said - there's nothing mathematically wrong with the answer you got back. For one thing - you didn't specify...

Eric M Russell (4/18/2014)

---

IMHO (4/18/2014)

---

I agree, but it's the fantasy of becoming the next Bill Gates, Steve Jobs, or Mark Zuckerberg that gets kids fired up and fills the ranks...

Sorry - that's the "Show Advanced Editor". As in - right-click the flat file or XML source object in your data flow, then "Advanced Editor". Check the data...

You may also want to check the metadata in SSIs to see if it "guessed" incorrectly as to the underlying data types. If it had to derive the types...

Both requests are possible to some degree. The best tool to do so might be more of a factor of how repeatable you intend the process to be. ...

I'm not surprised that you haven't found much, because I think you're asking the wrong question. SQL Server is a general purpose RDBMS, so it understands how to store,...