if you have the assembly installed you just need this:

CREATE PROCEDURE [dbo].[dbasp_FileHandler]

@data XML

AS EXTERNAL NAME [GettyImages.Operations.CLRTools].[GettyImages.Operations.StoredProcedures].[dbasp_FileHandler]

replacing the names with the ones that you used in your version.

sm8680 (1/3/2014)

---

Hi Steve,

I was trying to create this in a test environment. I got as fair as creating the assemblies. But I'm lost as to creating...

I am currently using this in T-SQL Code that does Database restores. In our DR Site we have some mirrored and some log shipped databases. All of these databases must...

As we all know, there is almost always 20 ways to solve the same problem. This just represents the one that I felt was the best fit for our environment...

Here is a little function I wrote to deal with this very problem.

CREATE FUNCTION [dbo].[dbaudf_SplitSize] (@String varchar(max),@Size INT = 8000)

RETURNS @Array TABLE(

PartNumberINTIDENTITY(1,1)

,Partvarchar(8000)

)

AS

BEGIN

DECLARE@index ...

I found your code useful.

http://databasebuddha.blogspot.com/2013/06/better-linear-regression-forecasting.html

Thank you, I have not posted too much but I have been doing this for years and have quite an arsenal of code snippets I would love to share. I...

As a side note, I also came up with some T-SQL that will generate HTML Charts using Google Charts.

DECLARE@HTMLOutputVarChar(max)

,@TitleStringVarChar(max)

,@InputValidationBit

,@InputValidationMsgVarChar(max)

,@SeriesStringVarChar(max)

,@ColumnStringVarChar(max)

SELECT@HTMLOutput= ''

,@TitleString= 'CPU History'

,@InputValidation= 0

,@InputValidationMsg= ''

,@SeriesString= '1:{type: "area"}, 2:{type: "area"}'

,@ColumnString= '0,1,2,3'

SELECT@HTMLOutput =...

I found the timing of this to be interesting as I just completed a first draft of a CLR Function the returns a SQL table as HTML Table code in...

OK, I have found a benefit of the CONCAT function in SQL 2012. it is automatically converting data types to strings and outputting them rather than giving you data type...

I didn't mean to imply that I was being forced. I was just trying to see if I was missing an aspect that would make it more useful in some...

Why would I use this function rather than simply joining the strings with "+" as it does inside the function. Especially when there are more that two strings being joined,...