We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a b...

This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a b...

This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a b...

This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a b...

HI ! I remember i wrote something similar to this back in november 2011, here is the link; [http://gallery.technet.microsoft.com/DataCleanUp-Function-5f2d1c30][1] Hopefully you will find it more generic and robust. I am always welcome to hear m...

HI ! I remember i wrote something similar to this back in november 2011, here is the link; [http://gallery.technet.microsoft.com/DataCleanUp-Function-5f2d1c30][1] Hopefully you will find it more generic and robust. I am always welcome to hear m...

HI ! I remember i wrote something similar to this back in november 2011, here is the link; [http://gallery.technet.microsoft.com/DataCleanUp-Function-5f2d1c30][1] Hopefully you will find it more generic and robust. I am always welcome to hear m...

This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a bett

While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below. [code] DROP TABLE AdventureWorks.HumanResources.Department GO [/code...