I ponder on these things every day, WYPIWYG (what you pay is what you get), ROI, TCO.....and far too often the cheap option is the first option. Cutting corners to...

Good question, thanks!

Made me think a bit 😀

ScottPletcher (5/5/2014)

---

I would never use a table variable for this -- if something goes wrong after the DELETEs, but before the output has been processed, the data is gone, with...

I´m not certain that you are on the right track here with the Execute SQL Task, it has no means of accessing the Excel spreadsheet other than OPENROWSET or such....

Further on what Koen said, you will have to test explicitly for the existence of the config file, common method is to have a variable with lets say 0 value...

Good stuff!

IIF is supported in Sql Server 2012 and later, my guess to aid portability from Access:-D

Good luck

😎

Around here you only need to speak some SQL, post some example data and we will help you!

😎

jdasilva (5/5/2014)

---

Hello all,

I've played around with Access and SQL statements for some time, not a master by any means, but the data I am storing has gotten to the point...

The problem or at least part of it is mixing positions with the nodes in a Net. To mitigate this, lets use only the position (Mainid) to build the hierarchy,...

Eric M Russell (5/5/2014)

---

What method did you use to port the database?

Remember to use a schema comparison tool to insure things like indexes, table options, statistics, constraints, plan guides, etc....

I would have thought so, better ask around, been a while;-)

From a unix/linux box, the most straight forward would be ssh-tunnel.

😎

This depends of the type of connection between the two points. My advice is to configure this at the network level, even with a DSL connection, a Layer 4/7 VPN...

Try this for size

😎

declare @xml table (xmldata xml)

insert INTO @xml (xmldata) VALUES(

N'<parseObject name="Motel">

<fields>

<field name="vehicleno" fieldType="int" fieldSize="">

<grammar>

<data><![CDATA[

div.biz-page-subheader li > span.i-phone-biz_details-wrap mapbox-icon span.biz-partno

]]></data>

<attribute>html</attribute>

</grammar>

</field>

</fields>

</parseObject>

')

/*----------------*/

SELECT

RO.OT.value('@name','NVARCHAR(256)') ...

Leaving the explanation of the Cartesian Product to Jeff, here is a quick answer to the second question:

The...

I'm not certain that a recursive CTE is...