Just my 2 cents...

I would recommend ALWAYS using a stored procedure in a report. I even have a naming convention for stored procedures that do nothing but return data for...

Within SQL Server Business Intelligence Development Studio, under "Project", is a "SSIS Import and Export Wizard...". I would recommend you start there and see what it does (fairly easy to...

Yes, I am maintaining a sort order manually in this one....

Nice! So it will only "process" for the places where the character in that place is not a character, versus mine where it uses a case on every character.

But...

I am personally trying to get some practice with a tally table, so here is what I came up with:

-- tNumber starts at 1

DECLARE @InString NVARCHAR(MAX)

SET @InString = 'this is...

Just a quick thought...

Another solution, possibly more stable than a time delay, even if you cannot rename the file, is a time delay with a file-size check. If the file...

Can you clarify your question? Are you trying to keep the table from scrolling so that when the users scroll in the browser the entire report, header included, is scrolled...

Ah. Thanks Mark! Good catch, Jeff. The way I set up my quick table I didn't notice that.

Taking some time to play around with the hierarchy (taking the que...

Jeff Moden (7/9/2008)

---

MentalWhiteNoise (7/9/2008)

---

You should be able to track depth easily with yoru CTE (if you are not already). Use this depth to append a precursor string... such as REPLICATE('-',...

Jeff, wether I use the Cross Apply or an Inner Join, the Execution Plan is identical, and the performance on the Cross Apply is better (~13400 "Wait time on server...

I am fairly new to the tally table... (I have used it in a couple of places modifying reference code) so I decided to play around with getting numbers from...

Not sure on performance, but just for fun, here is what I came up with using a tally table...

SELECT TestText,MAX(n.Number), SUBSTRING(TestText, MAX(n.Number)+1, LEN(TestText) - MAX(n.Number))

FROM (SELECT 'T5e3st003' AS 'TestText')...

What format is the source data? Is there a limit to the number of columns you will need to query? There are going to be several ways that you can...

You should be able to track depth easily with yoru CTE (if you are not already). Use this depth to append a precursor string... such as REPLICATE('-', Depth) + Label

Better yet, set it to an expression and reference a "Debug" variable. Then you can turn this delay...