Here is the the code I previously posted with some sample data, works fine on my end;-)

😎

USE [tempdb]

GO

INSERT...

Repeating Gail's request:

Please post the full and complete, unedited output of that CheckDB command. DO NOTHING ELSE FOR NOW!

If...

Quick thought, this can easily be stuffed

😎

;WITH BASE_ID AS

( SELECT BID FROM

(VALUES (4461),(14130),(23891)) AS X(BID)

)

SELECT

BI.BID

,STUFF('CP000000000000'

...

Paresh Motiwala (8/20/2014)

---

Hi SSCommitted,

I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.

Citing this as one of...

Columnstore index will not aid normal row retrieval, the test may therefore portray the negative impact...

Paresh Motiwala (8/20/2014)

---

This result should tell you:

...

John Mitchell-245523 (8/20/2014)

---

Eirikur

Good points there. Hence, my new improved version 2. I've padded out TimeDecimal with another two zeros (that deals with the small numbers), then converted to...

Then Lynn's solution is your...

Quick question, what SQL Server Version are you on (SELECT @@VERSION)?

😎

er.mayankshukla (8/20/2014)

---

Hello Experts,

I had done a page compression on an archive Table on my Dev Server.

And it significantly reduced the size of the table.

I have a non clustered index and...

Quick solution, more a POC than anything else.

😎

USE tempdb;

GO

DECLARE @TSTR NVARCHAR(200) = N'<TV<MR1#4.0#true#2.0#USD>VT>,<TV<MR2#3.0#true#1.5#USD>VT>,<TV<MR3#0.0#true#0.0#USD>VT>,<TV<MR4#0.375#true#0.19#USD>VT>';

DECLARE @SQL_STR NVARCHAR(MAX) = N''

SELECT @SQL_STR = N'select [Model Code],[Persentage],[isAbs],[AppliedValue],[Currency] from (values '

+ REPLACE(REPLACE(REPLACE(@TSTR,N'<TV<',N'('''),N'>VT>',N''')'),N'#',N''',''') + N') as X([Model...

Quick thought, as this is straight forward in T-SQL, why not do this in the source query?

😎

USE tempdb;

GO

DECLARE @TESTDATA TABLE

(

ID INT...

This is straight forward using the ROW_NUMBER function and setting the order by descending order of the PERIOD. Here is an example that should get you passed this hurdle.

😎

USE tempdb;

GO

--PERIOD...

Quick thougt, sounds more like a network/name resolution issue unless the server is very busy. Try this when you know that the server is less busy, look into the tcp/ip...

Thank you for this and not at all sorry...