Thanks for the feedback! Glad to help you.

Have a nice day

Flo

It's a C(#) thing. Like in C or C++ you can specify special characters in strings....

BTW: Is your database SQL Server or MySQL?

Could you please post your SELECT statement?

Greets

Flo

Hi

You can specify DEFAULT values for table columns and you can define a scalar function as DEFAULT value of a column. You can create a table with your users and...

Hi

Try this:

SELECT AutoId, COUNT(*) Duplicates

FROM YOURTABLE

GROUP BY AutoId

HAVING COUNT(*) > 1

Greets

Flo

You use the correct function, just swap your parameters and it works 😉

ISNULL(STATE, 'all')

Greets

Flo

Don't say that. There might be actually two business cases where the tally...

aktikt (4/13/2009)

---

Say it ain't so. This is the first I've heard a set based solution losing to RBAR.

I don't have the desire to check right now, but what about using...

The INSERT was just for some sample data. I'm not sure if you want to eliminate the NULL values within your SELECT or on client side. If you want to...

Hi...

Hi

I'm not sure if your "mysql" was a typo... If you mean mssql try this:

DECLARE @t TABLE (txt VARCHAR(30))

INSERT INTO @t

...

I agree with arun.sas's approach. Maybe just consider to use an own user id instead of the system user_id to avoid problems when you move your remove/add users. You can...

Paul White (4/13/2009)

---

Flo,

More great stuff from you again...!

I hope your internet connection is fixed soon.

Off to bed now, but thanks for the XML CLR solution - neat (though I am...

Hey Paul again!

Sorry! Didn't see your new post...

I did not know that CLR functions can return IEnumerable. Thanks for that!

I tested your function against mine:

Start clr xml solution

Milliseconds: 790 |...