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...

Quick question, why do you think you need a Cursor?

😎

In my books, having to use recursive CTEs qualifies as worst case scenario, do explore the...

eligiable (5/4/2014)

---

It's just the SignedByUserID, that for Bilal Mateen does not exists in tblMer_Outlet, so we can change it to B.UserID from tblGen_Users, both are the same, but that not...

What ever happened to Baby Jane, oops, sorry, Bilal Mateen's ID?

😎

Throwing in my nickles worth, first on the operation side; draw up your worst case scenarios, then think of few ways to make them even worse, how you would tackle...

I've just used this link and ran the download, works like a charm

😎

How about 2008 - 2014 versions:cool:

SELECT create_date AS INSTALL_DATE

FROM sys.server_principals

WHERE name = 'NT AUTHORITY\SYSTEM';

I would recommend using the ANSI standard information_schema

😎

/* Using ANSI standard information_schema */

IF EXISTS (SELECT * FROM tempdb.INFORMATION_SCHEMA.TABLES

...