For those that missed our most recent Webinar, you can find a recording embedded below. Some of the video qualityisn’t great, but the sound is quite clear.
As the Webinar explains, HR-XML's forthcoming Version 3.0 release is informed by almost 10 years of industry contributions and is architecturally more consistent and robust than ever before. [...]
CREATE PROCEDURE [TOPS].[UnpivotTable]
(
@tableName AS VARCHAR(512),
@whereClause AS VARCHAR(2000) = NULL,
@commonColumns AS VARCHAR(2000) = NULL
) AS
-- ==========================================================
-- Author: Patrick Caldwell
-- Create date: 2007/12/19
-- Description: this procedure unpivots data in a table
-- [...]
– the function
CREATE FUNCTION SplitString
(
@TargetString NVARCHAR(MAX),
@Delimeter NVARCHAR(MAX)
)
– the part repository
RETURNS @Parts TABLE
(
PartId INT IDENTITY(1, 1),
Part VARCHAR(MAX)
)
AS BEGIN
– just some variables to keep track of things
DECLARE
@CurrentIndex INT,
@DelimeterIndex INT,
@PartLength INT;
– initialize the loop
SELECT
@CurrentIndex = 0,
@DelimeterIndex =CHARINDEX(@Delimeter, @TargetString, 0),
@PartLength = @DelimeterIndex - @CurrentIndex;
– [...]
I was reading a little tgdaily today and I found an article about a new iPhone app that may be showing up in the app store in the near future. The new application is called Trapster and it’s a “social-networking speed trap warning website.”
I know what you’re asking. Well, I don’t actually know [...]