Hi there,

It was not displayed because the difference became 35 i.e. 660 (max) - 625 (min).. If you would still like to display macy, here's the modification:

;WITH cte AS

(

SELECT vndname,invdate,invamt,COUNT(invamt)...

Welcome.. It's a pleasure to help..

Hi there,

Putting comma on left or right side has no impact on performance.. 🙂 The syntax is just the same..

I think people put it on the left side so...

Hi there,

As i understand, this happens because Account Number is already displayed while the record is not yet saved.. I'm just going to suggest solution to avoid this problem.. 😛

Instead...

Hi there,

I would just like to ask one thing.. What would happen if there's additional record like this one:

insert into test values (9,'macy','04-06-2006','660.0')

a. The difference between invamt of vndid 7...

Hi there,

I don't know if that is possible.. But, why not drop the function after its use..

DROP FUNCTION [dbo].[f_functionname]

GO

I hope this helps.. 😛

Quatrei.X (8/30/2010)

---

:w00t: COOL! Thanks a lot everyone.

:hehe: I haven't used SET STATISTICS TIME (ON|OFF) before. Thanks 😀

that's the one you guys used right? or is there a tool or something...

The "other" split method is, in fact, faster than the Tally table on my box (48 seconds vs 66 seconds) as, like shield_21 already noted, was stated in the original...

I'm testing Oleg's code method. The place that most XML methods fall apart in is when there are multiple rows. They do work fast as all get out...

Hi there,

Here's another method for splitting comma separated values using recursive cte without using tally table.. When the string contains more than 8000 characters, this performs quite faster (otherwise DelimitedSplit8K...

My apologies for my late reply.. I'm quite busy at work..

Your code works! It even compares NULL against empty string and return them.. So I think this is fine.. I'm...

Welcome.. I'm glad it helps! 😀

Hi there,

Here's a sample for FULL JOIN.. If @table1 has more data than @table2 or vice versa, this will work.. However, this can affect performance depending on the number...

Hi there,

In ABC/IT01, the latest price is...

Hi there,

I just noticed that item_value are arranged in ascending order both for table1 and table2.. This will work provided that you intended to sort first the item_value then compare...