Public Holiday 🙂

vaibhav.tiwari (4/5/2010)

---

...but how can i replace @string with my column name...as i have to use it with the table otherwise i will have to use it by storing the value...

SELECT SQ.Questionid,

cont = MAX(CASE WHEN type = 'Cont.' THEN checked ELSE 0 END),

sup...

Must be annoying :laugh:

LMAO

I never make mistokes Tom :hehe:

Updated implementation:

DECLARE @String NVARCHAR(MAX);

SET @String = N'======Heading========== some phrase ===============bottom line==============';

SELECT extract =

SUBSTRING(data, Start.pos, Length.value)

FROM ...

Would have helped if the extra information had been in the first post.

Post some sample INSERT statements to populate your table with sample data, and show the exact output you expect.

Thanks.

:ermm: Not a running total problem.

DECLARE @Sample

TABLE (

product_id CHAR(7) NOT NULL,

entity_id...

DECLARE @Sample

TABLE (

Questionid INTEGER NOT NULL,

type ...

Integration Services: Performance Tuning Techniques

Parallel Execution in SSIS

SSIS Parallelism

SSIS: A Strategy for Performance

SSIS Top 10 Best Practices - SQL CAT

Update statistics does not perform any logged operations, so no.

DECLARE @String VARCHAR(8000),

@Header VARCHAR(8000),

@Footer VARCHAR(8000);

SET @String = '======Heading========== some phrase ===============bottom line==============';

SELECT @Header...

karthikeyan-444867 (4/5/2010)

---

I am not getting...