Forum ghosts resurrecting threads! Arch! :-D:-D:-D

Jon,

The last query you posted looks very wrong (or crap, in Australian :-D).

For one or another reason everyone here is struggling to understand your filtering requirements.

I am, again, strongly...

:w00t:

Me too! I hate them! They are commie bustards!

Vote conservatives! :-D:-D:-D

You wanted to say: "I don't really understand how left...

If you need high-performance heavy string manipulation functions write them as CLR functions in c#. T-SQL UDF will always be...

looks like school homework to me, therefore no solution but a guide:

Read about using aggregate functions in SQL, in your case it would be SUM.

Also, please click the link...

I like noodles some times, but usually I have them cooked not coded...:-D

Read about using CTE in SQLServer. Also, introducing variable to hold MAX(TotalTrades) will make your code look better...

The most closest thing to a "Fuzzy" search in SQL is using Full-text predicates (google FREETEXTABALE & CONTAINSTABLE)

You might not like using it...

If you want to have good fuzzy search...

The simplest CLR in C# would look like:

public string UnwrapHierarchy(string value)

{

...

george.greiner (7/14/2010)

---

...

I have been able to filter the A row but all subsequent lines pull all the records as they do not have a "DateFinished" column. How do I...

Paul, have you seen my post #951618 (using UDF), bottom of page 3?

Do you think this approach is viable for most of scenarious? Of course, this function better...

your litle "cheat" will only work for cases where the second part of data is less than 10 .

Check what will happen if you add 1.10 or 2.10 in a...

tasnim.siddiqi (7/13/2010)

---

...

To Paul: A few things for my table. I am a database programmer (a new one). My table will have some 90000+ rows and I need to maintain unique...

george.greiner (7/13/2010)

---

Is it possible to use a WHERE clause using this method? If not what is the best method to query the files I need out as this will...

Modifictaion of my creative way 😀

Requires a function (which, for a better performance, can be implemented in C#):

CREATE FUNCTION dbo.udf_CreativeThinkingWithOnes ( @sHV varchar(max) )

RETURNS VARCHAR(MAX)

WITH SCHEMABINDING

AS

BEGIN

...

Looks like there is no simple way (set-based) to do it in SQL2005.