Without using parsename:

;WITH sample_data(val)

AS

(

SELECT '1.9999-Q1'

UNION SELECT '01.9999-Q11'

)

SELECTval,

part1 = substring(val,1,charindex('.',val)-1),

part2 = substring(val,charindex('.',val)+1,(charindex('-',val)-charindex('.',val))-1),

part3 = substring(val,charindex('-',val)+1,...

rightontarget (6/16/2014)

---

Hi all,

I have a table:

id pallet color

1 a red,blue

2 ...

This click takes less than a second in staging and about 33 seconds in production.

A common cause of this kind of problem is when critical indexes are not moved...

No, no... My apologies...

Doctor Who 2 (6/12/2014)

---

Alan.B (6/11/2014)

---

I am going to make a wild guess and say that you are in Albuquerque, NM or somewhere nearby? I don't know much about that market...

Users say a lot of things...

A few questions to help you sort this out:

1) Do you track your DB growth? Do you have any idea how fast this DB...

I just wanted to add...

I am going to make a wild guess and say that you are in Albuquerque, NM or somewhere nearby? I don't know much about that market but know that there...

I don't know if that is possible. I thought I saw an article...

Premièrement, je ne parle pas français. Je n'ai pas une solution complète mais cela devrait aider...

passer à l'anglais(switching to English)...

OK. You have the following data:

-- données de l'échantillon

IF...

I think we could figure this out a little easier if you included the query plan the each query produces. Could you run this with " include actual query plan"...

The deal with two nodes with the same name you could refer to them by their position....

Eirikur Eiriksson (5/28/2014)

---

Here is a very simple approach

😎

USE tempdb;

GO

DECLARE @TXML XML = N'<?xml version="1.0"?>

<CommonEventData>

<Row>

<CallSource>999</CallSource>

<CallerCityStateZipCode>

</CallerCityStateZipCode>

<CallerName>TEST</CallerName>

<CallerPhone>TEST</CallerPhone>

</Row>

<Row>

<Beat>E27</Beat>

<MultiEventId>0</MultiEventId>

<PrimaryUnitId>E09A1</PrimaryUnitId>

</Row>

</CommonEventData>'

SELECT

MAX(RO.W.value('CallSource[1]','NVARCHAR(50)') ...

You could go with:

SELECT cast(8999999*rand() as int)+1000000

For multiple rows you could go with:

SELECT cast(8999999*rand(cast(newid() AS varbinary)) as int)+1000000

FROM <something>

Edit: typo

I just read this. Great work Don. Very thorough and a really good read. I am looking forward to the rest of the SQL Server Security stairways!