Do you have the option of adding a table and use the numeric column to link the two? ASCII code in base 10 is not going to be too useful...

This should get you started

😎

;with XMLNAMESPACES (

'http://www.abc.com/Details' as qsds)

Select

ID

,Version

,Start_Date

,End_Date

,DE.TAILS.value('Age[1]','varchar(50)') AS Age

,MO.DULE.value('.[1]','varchar(50)') AS MModule

,MD.*

FROM Table1 T1

OUTER APPLY...

Paul White (4/30/2014)

---

Eirikur Eiriksson (4/30/2014)

---

FYI: ran the test on the CLR Split, mm's memory optimized version and the lead window function version. Hardly any benefit of using the window function,...

FYI: ran the test on the CLR Split, mm's memory optimized version and the lead window function version. Hardly any benefit of using the window function, 0.001 on average and...

Check out

Stairway to Transaction Log Management in SQL Server[/url]

😎

I do agree but sometimes I get carried away on the cloud of perfection and everlasting solutions:-P

ScottPletcher (4/29/2014)

---

Then expand the initial code to handle 10 bytes (or 20 if you're that worried about it). Yes, I'd be willing to revisit code if the known 5...

You know as well as all of us that requirements do change (par definition), are you...

This is simply a brute force division, could be done this way

😎

DECLARE @DECIM DECIMAL(18,5) = 125521.12345;

/* Brute force division */

;WITH NX(N) AS (SELECT N FROM (VALUES

(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS X(N))

,NUMBERS(N)...

Chowdary's (4/29/2014)

---

Dear All,

I know this is some what get irritate to you,Very sorry for that but i hope that you can give me some suggestions for This.

Am using Windows Server...

What about Base36, almost...

Sean Lange (4/29/2014)

---

What I don't really understand here is what is the point of this? This data is pretty much unusable because you have no way of putting it back...

Sean is quicker typing 😀

DECLARE @STRINGS TABLE

(

MYID INT IDENTITY(1,1) NOT NULL

,MYSTRING CHAR(4) NOT NULL

)

INSERT INTO @STRINGS (MYSTRING)

SELECT MYSTRING FROM

(VALUES...

Quick solution, you will have to sum up each row though

😎

USE AdventureWorks2012;

GO

DECLARE @TABLE_NAMESYSNAME= N'SalesOrderDetail';

DECLARE @TABLE_SCHEMASYSNAME= N'Sales';

DECLARE @SQL_STRNVARCHAR(MAX)= N''

SELECT

@SQL_STR = N'SELECT '+

STUFF((SELECT ',DATALENGTH(' + C.COLUMN_NAME + N') AS [DL_' +...

Set MIN and MAX memory to the desired number

😎

EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'min server memory (MB)', N'4096000'

GO

EXEC sys.sp_configure N'max server memory (MB)', N'4096000'

GO

RECONFIGURE...