ruffindmc (5/19/2011)

Thanks for posting this, it looks very informative.

YSLGuru (5/19/2011)

Thanks for the reply along with sample code.

Q - This requires that the row you want can eb sorted so that it is the fir row...

Craig Farrell (5/19/2011)

BWAHAHAHAHAHAAHAHAHAHA... sorry, but holy newbie! That really needed to...

Looks right to me.

As I'm sure you've realised - I've never really used dynamic SQL before - how do I handle the fact...

DECLARE @test-2 TABLE (

SalesOrderId INT,

ModifiedDate DATETIME,

PRIMARY KEY CLUSTERED (SalesOrderID, ModifiedDate));

INSERT INTO @test-2 ( SalesOrderId, ModifiedDate )

VALUES ( 1, '2011-05-19 01:10:52'),

...

tooba111 (5/18/2011)

UPDATE MYTABLE

SET INVOICE = WITH cte AS

(

SELECT RowID,

Col1,

RN =...

DECLARE @test-2 TABLE (RowID INT IDENTITY PRIMARY KEY CLUSTERED, Col1 VARCHAR(20));

INSERT INTO @test-2 (Col1)

VALUES ('INVOICE'),

('C-125'),

...

While it is commonly called Active/Active, MS actually calls it a "multiple-instance cluster". They have been trying, since 2000(?) to get rid of that Active/Active terminology.

No problem... always glad to help turn the light on!

:Whistling: Actually, you need both the ROW_NUMBER and DENSE_RANK functions...

;

WITH cte AS

(

SELECT * ,

Grp = ROW_NUMBER() OVER (PARTITION BY id ORDER BY...

This should get you the data in the format you want:

SELECT Skill, [Bill], [Jim], [Mary]

FROM (SELECT s.Skill,

...

Okay... what are you going to do with this once converted? It will store properly in one of the date data types as it is.

Have you looked into using the...

Several good solutions here. Just to note that mine does NOT handle times of only three characters (hours < 10); it is assuming that they will be zero filled. If...

ranuganti (5/17/2011)

I have two columns 'date' varchar (8) and 'time' varchar (4)

I want to club 2 columns in to one one column as smalldatetime and order by date and time.

and...