NicHopper (6/17/2010)

---

Hi,

Sorry I'd...

I'd use SSIS, query parts of it and build a file by appending the seperate parts.

Is it always three characters before the part that you're interested in? And always three characters after it?

e.g. XX_wantthis ?

If so, simple way to do it is: -

--First, lets build...

Are you just trying to strip the numbers/special characters?

If so: -

DECLARE @input AS VARCHAR(50)

SET @input = '00_MECH_UG,00_PRE_LG'

SELECT @input

DECLARE @output VARCHAR(50)

SET @output = ''

DECLARE @length INT

SET @length = Len(@input)

DECLARE...

Open the report in BIDS (SQL Server Business Intelligence Development Studio).

The code you were given works if executed in the correct...

--First, lets build some test data

DECLARE @table AS TABLE(

rid VARCHAR(50),

posi INT,

busn VARCHAR(7),

ddate DATETIME)

--Using the test data you specified...

I...

DECLARE @date AS VARCHAR(10)

SET @date = '2010/01/29'

SELECT CONVERT(VARCHAR(10), (CONVERT(DATETIME, @date)), 101)

--OUTPUT -> "01/29/2010"

??

The reason you've had no replies is because you've not given us much incentive to work on it. Post your data like this: -

DECLARE @table AS TABLE(

eventid ...

With the restriction you've placed, chances are that the only way you'll get a performance increase would be to either feed the server's hamsters rocket fuel or get a bigger...

In that case, I'd need to be able to reproduce the error to look into it. With no data, that's not possible. When I tried using test data I wrote,...

Please re-read my post and execute the SQL I showed.

The SELECT query you wrote to see the max length of the column is not doing what you think it is...

SQLSeTTeR (6/15/2010)

---

and it's TRUNCATING on AttributeValue....

I found this script awhile ago that dynamically alters tables

--ALTER TABLES SCRIPT

--change the line marked *** to suit your update needs....

-- Jamie Moffat, 4/2/02

DECLARE tablenamescursor CURSOR FOR

--*** ...