Deferred Processing - All Comments

re: Yet Another Median Calculation

Wayne Gr — Sun, 23 Nov 2008 04:26:22 GMT

-- This routine accurately gets Median using the TOP xx perecent method

CREATE TABLE Centres (CallCount SMALLMONEY not null)

DECLARE @Median SMALLMONEY

INSERT INTO Centres - get top centre value

SELECT TOP 1 dRecord as CallCount

FROM (SELECT TOP 50 PERCENT dRecord FROM dBase ORDER BY dRecord asc ) sub Order by dRecord desc

INSERT INTO Centres get bottom centre value

SELECT TOP 1 dRecord as CallCount

FROM (SELECT TOP 50 PERCENT dRecord FROM dBase ORDER BY dRecord DESC ) sub ORDER BY dRecord ASC

SET @Median = (SELECT AVG(CallCount) FROM Centres)

DROP TABLE Centres

re: Visual Studio & XSLT Debugging

dan-sullivan — Fri, 14 Nov 2008 17:18:04 GMT

It should be working now.

re: Visual Studio & XSLT Debugging

TomChmiel — Tue, 11 Nov 2008 15:01:56 GMT

Dan, I would like to watch your tutorial but the link does not work.

re: PowerShell and ADO.NET

Mosaic — Fri, 19 Sep 2008 21:31:41 GMT

Great - easy to find and just what I was looking for!

Showing how to use both the DataTable and the DataReader allows me to handle both small and very large sets of data.

Many thanks

re: Evaluating String Arithmetic Expressions in SQL Server 2005

Bebop — Thu, 18 Sep 2008 20:08:38 GMT

The following link helped me get the c# code into SQL Server:

www.sqlteam.com/.../writing-clr-stored-procedures-in-charp-introduction-to-charp-part-1

I did have to use Dans modifications above. Just substitue articles code with code above including Dans mods, and name your StoredProcedure EvaluateArithmeticExpression.cs. Save. Build. Deploy.

You will then see dbo.EvaluateArithmethicExpression under Scalar-valued Functions

Also had to enable CLR integration:

Start-All Programs-Microsoft SQL Server 2005-Configuration Tools-SQL Server Surface Area Configuration

Then Surface Area Configuration for Features-SLR Integration-Enable CLR integration

re: Comparing XML in SQL Server 2005

Jacob Sebastian — Sun, 14 Sep 2008 14:58:57 GMT

Nice work! This is one of the links I give people when they ask me about comparing two XML values. I just wrote a TSQL function that compares two XML values. www.sqlserverandxml.com/.../xquery-lab-36-writing-tsql-function-to.html

re: PowerShell and ADO.NET

Nick — Fri, 01 Aug 2008 18:10:31 GMT

Hey,

Thanks for this blog entry, I figured out how to add a column to an existing dataset table. Now how would I populate the values in the column / rows (I need to combine a 1st name field and a last name field into a "full_name" field).

re: Evaluating String Arithmetic Expressions in SQL Server 2005

Need Help — Thu, 22 May 2008 20:35:00 GMT

Where should I be putting the c# code? in SQL Server or in VS 2005

re: PowerShell and ADO.NET

bk — Tue, 18 Mar 2008 21:07:00 GMT

Awesome tutorial!!

re: Processing XML with PowerShell II

Edward Benson — Tue, 18 Mar 2008 11:16:00 GMT

Very helpful article, thank you!

The %{$_.Property} notation had me completely foxed, until I found out that % is alias of "ForEach-Object" (Using command "Get-Alias %").

Using "ForEach-Object", in place of "%", would make the code much clearer. And "Select-Object" would be clearer still.

re: PowerSMO!

Dan — Tue, 26 Feb 2008 10:51:00 GMT

You can save it using IE to make an MHT archive that you can pass around. In IE-7 use Page->Save As->Web Archive Single File. You can view the *.mht file that it produces without being on line.

Dan

re: PowerSMO!

Tracy Esau — Tue, 26 Feb 2008 03:16:00 GMT

can u please upload a pdf version so that we can read the article under our convinence

re: PowerShell and XmlDocument

ScriptRunner — Tue, 18 Dec 2007 18:13:00 GMT

Nice article, very helpful...

re: Evaluating String Arithmetic Expressions in SQL Server 2005

Maddy — Wed, 17 Oct 2007 12:10:00 GMT

I tried deploying the CLR function given above. Now when i try to execute the function from SQL server, It's not giving the proper results.
Like if I pass the parameter as 1+2+3, then it return me value of 1 i.e. always returns the 1st number.

re: Evaluating String Arithmetic Expressions in SQL Server 2005

Senthil — Wed, 29 Aug 2007 03:24:00 GMT

Hi,
When i try to create the procedure it throws this error
Msg 6567, Level 16, State 2, Procedure EvaluateArithmethicExpression, Line 1
CREATE PROCEDURE failed because a CLR Procedure may only be defined on CLR methods that return either SqlInt32, System.Int32, void.

this is my Procedure
CREATE PROCEDURE EvaluateArithmethicExpression
@input nvarchar(200)
AS EXTERNAL NAME
ArithmeticCalculations.ArithmeticCalculations.EvaluateArithmethicExpression