Maybe something like this could work?

WITH SampleData AS(

SELECT '00345.0001' code UNION ALL

SELECT '02345.0123' code UNION ALL

SELECT '025013'

)

SELECT ISNULL(...

Well, that's not what I've got using the data that you posted.

I noticed that you didn't only have spaces and you have tabs as well.

Would this help you?

SELECT MAX( CASE WHEN ItemNumber = 1 THEN LTRIM(Item) END) Col1

...

I'm not sure that I would like to have a single try block for complex procedures.

simon.crick (6/12/2014)

---

jfogel (6/12/2014)

---

simon.crick (6/12/2014)

---

Tavis Reddick (6/12/2014)

---

[p]I am having some difficulty understanding the categorizations of roles used here.

[/p][p]My understanding of a database administration role is close to Wikipedia's, where a DBA...

The Wizard Of Oz (6/12/2014)

---

Haha! Yes Luis, good thing that A & C...

The Wizard Of Oz (6/12/2014)

---

For a miniscule (and mostly academic) improvement on PeSo's script,

I've got it so the index/table only gets scanned once (instead of 3 times)

by just using a...

cbrammer1219 (6/12/2014)

---

This doesn't work for what I am wanting, it is counting the spaces, It doesn't count the characters before the spaces, as you see in the data below for...

I just wanted to play a little bit with the DelimitedSplit8k and this is what came out.

CREATE FUNCTION [dbo].[ItemsLength]

(

@pString [varchar](8000),

@pDelimiter [char](1)

)

RETURNS...

What's the data type on the table for those values? string or numeric?

Have you tried formatting the columns correctly before converting them to csv?

I missed the question. What's your problem?

Where do you have those csv values?

In a file? a parameter? a table?

I'm not so sure about this, but you could deny delete on your tables/schema. http://technet.microsoft.com/en-us/library/ms176128.aspx

mushin2003 (6/11/2014)

---

Luis Cazares (6/11/2014)

---

Hi Rob,

The problem with your first query is that you missed to add the join condition for the CustomerID. In result, you're getting a cross join between...

You're on the right direction. You just need to quote your characters/strings. 😉

SELECT ProdID, REPLACE (PATH, '/', '\')

FROM (SELECT 1 AS ProdID, '/folder/folder/file' AS [PATH])blahblah