Extract Phone numbers from a line feed text column and show it in …
Sep 8, 2014 · Now I need t-sql query to show above source data into 3 columns by extracting phone numbers from each line feed.. new t-sql query output should look like this...
Microsoft Query cannot run SQL code with a T-SQL variables in it?
Oct 17, 2011 · I am unable to use Microsoft Query to return data from a query that includes T-SQL variables. The weird thing is that Microsoft Query handles the data fine, but then has a …
how to find the duplicate records in sql server
Oct 3, 2012 · If this is not related to SSAS, post yoir question in the SSIS forum or the T-SQL forum for faster resposne.
Monitoring Replication using T-SQL - social.msdn.microsoft.com
Jan 23, 2008 · I want to know is it possible to monitor the Replication Agent (if thats the right bit to monitor) using T-SQL.
Bridge Table T-SQL Performance Issue
Mar 5, 2011 · I have this problematic T-sql statement in a Data Warehouse. The part that is causing problems is a where clause on a field in a dimension table that is linked to the fact …
T-SQL query to find database information on all servers
Nov 9, 2017 · 1. sp_helpdb shows details about growth and more info a separate result set but only when a database name is specified. For all databases it just limits to the first set so I …
Converting Reserved Words to Upper Case
Jun 25, 2008 · There are third party tools such as red gate sql prompt, that provides intellisence for t-sql that as you begin to type options are posted to the right in the appropriate case. …
t-sql 2012-Update statement in merge does not work
Jul 31, 2015 · In the following t-sql 2012 merge statement, the insert statement works but the update statement does not work. I know that is true since I looked at the results of the update …
Enterprise t-sql Stored Procs against tables -vs- Views
Sep 17, 2010 · Option 1 - Be sure to optimize your Database design so your application will only require at most 6 joins and used stored procs for queries using proper indexs to gain the most …
CTE Tutorial - social.msdn.microsoft.com
Oct 7, 2021 · Answers 0 Sign in to vote User-595703101 posted Hi Ruthless, I'll suggest you to read my tutorial on SQL CTE (Common Table Expression) in SQL Server where you will find …