Good idea - I've dropped a bit of excess code too, based on the other suggestions...

DECLARE...

How about this?

WITH CTE AS

(

SELECT rownum, Value

FROM

(

SELECT rownum = row_number() over (order by (select null)), *

FROM @tab

) x

CROSS APPLY (values (case when flag1=1 then value1 else 0 end),

(case when...

It looks as though dup is a copy of NestleComments.

Assuming this is so:

The subquery gets the minimum PK for the comment. This is joined to NestleComments on PK. ...

Try this:

-- Start & End of Fiscal Year:

declare @StartDate Date, @DateInt int, @DateEndInt Int;

set @StartDate = '01 Apr 2012'; -- Start Date of Fiscal Year

set @DateInt = datediff(dd, 0, @StartDate);...

Nested REPLACE is very efficient, so there will not be a faster way.

The usual solution for this is a recursive CTE.

Look at

http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/

for example.

If you post some proper test data it will be easier for people to help!

Also, do you want help designing...

Here's a possible solution:

-- Start & End of Fiscal Year:

declare @StartDate Date, @DateInt int, @DateEndInt Int;

set @StartDate = '01 Apr 2012'; -- Start Date of Fiscal Year

set @DateInt = datediff(dd,...

Perry Whittle (9/25/2012)

---

SQLSACT (9/25/2012)

---

Hi all

I have a quick question regarding pages moving from disk into memory

If I select * from a table, are all pages that make up the table...

This does though, with small adjustments:

DECLARE @s-2 VARCHAR(10)

SET @s-2 = 'tapsaw1'

SELECT SUBSTRING(@s,t2.number,t1.number-(t2.number-1))--,t2.number,t1.number-(t2.number-1)

FROM master.dbo.spt_values t1

INNER JOIN master.dbo.spt_values t2 ON t2.type='P' AND t2.number BETWEEN 1 AND t1.number

WHERE t1.type='P' AND t1.number BETWEEN 1...

Mark-101232 (9/25/2012)

---

Use a numbers table

DECLARE @s-2 VARCHAR(10)

SET @s-2 = 'tapsaw1'

SELECT SUBSTRING(@s,t2.number,t1.number)

FROM master.dbo.spt_values t1

INNER JOIN master.dbo.spt_values t2 ON t2.type='P' AND t2.number BETWEEN 1 AND t1.number-1

WHERE t1.type='P' AND t1.number BETWEEN 1 AND...

If your table is not very big, you could SELECT * FROM Table using 'Results to Text' instead of grid, then copy & paste the output to a text file.:-D

This process uses the 'Quirky Update' without the essential requirements being in place. As such it is unreliable & will almost certainly give incorrect results in the future (or...

Try this:

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx

UB40

1. Using

RTRIM(LTRIM(SD.Code ))<>''

will be very slow - if you've got an index on SD.Code it probably won't be used. Can you tidy the data in the table so you don't...