Piotr Rodak - All Comments

re: Numbers table

dle — Fri, 14 Nov 2008 19:39:19 GMT

<a href="www.pythian.com/.../log-buffer-123-a-carnival-of-the-vanities-for-dbas">Piotr Rodak offers his example of the use of a numbers table...</a>

re: Numbers table

Piotr Rodak — Mon, 10 Nov 2008 23:31:02 GMT

Thanks guys for the links - they are really cool.

re: Numbers table

Madhivanan — Mon, 10 Nov 2008 11:17:22 GMT

Other uses

sqlblogcasts.com/.../remove-duplicate-characters-from-a-string.aspx

sqlblogcasts.com/.../count-number-of-words-in-a-string.aspx

sqlblogcasts.com/.../extract-only-numbers-from-a-string.aspx

re: Numbers table

Adam Machanic — Mon, 10 Nov 2008 02:16:21 GMT

Well I think there must be some serious anti-SPAM measures on your blog because I apparently can't post any comment with a link in it. So if you want some more ideas for numbers tables, go to my blog and search for dbo.numbers ...

re: Numbers table

Adam Machanic — Mon, 10 Nov 2008 02:02:47 GMT

Trying again, here are some of my previous posts that use numbers tables -- I'll split it into two comments in case it was rejected before for having too many links:

sqlblog.com/.../splitting-a-string-of-unlimited-length.aspx

sqlblog.com/.../counting-occurrences-of-a-substring-within-a-string.aspx

sqlblog.com/.../dealing-with-very-large-bitmasks.aspx

» Numbers table

» Numbers table — Sun, 09 Nov 2008 21:27:19 GMT

Pingback from » Numbers table

Смена COLLATION

MSSQL — Sat, 15 Dec 2007 18:23:51 GMT

Скрипт для смены COLLATION: select 'alter table [' + s.name + '].[' + t.name + '] alter column...

re: csv list of elements as parameter for stored procedure

AdamMachanic — Mon, 26 Nov 2007 19:59:22 GMT

For comprehensive coverage of this topic, please see:

http://sommarskog.se/arrays-in-sql-2005.html

re: So.. this is it

Nettestad — Tue, 13 Nov 2007 14:34:06 GMT

I have a trigger that I use to do consistancy checks on the application data just entered. I can't give the application an error to display to the end user, so I send an e-mail with msdb.dbo.sp_send_dbmail. We are upgrading versions of the app software (the old one used SA and the new one uses NT authentication). Now the trigger won't work. I have narrowed it down to this stored procedure. With NT authentication I don't have rights to even see this procedure. I have logged on as administrator to the network, then myself to the application. When I enter a transaction that causes the error, it works as it should and I get an e-mail. Where do we go to change the security on the MSDB data base to allow execution of all of the stored procedures.

Sure need some ideas. We've looked everywhere and cannot solve it.

Thanks, Ed

re: So.. this is it

Piotr Rodak — Sun, 04 Nov 2007 20:56:24 GMT

yeah, though I bet the stinging feeling on your proffessional ego made by correcting comment won't let mistakes linger in the net too long :)

re: So.. this is it

simonsabin — Thu, 25 Oct 2007 22:28:59 GMT

Welcome to the blogosphere. I'm looking forward to your brilliant ideas.

I like the philosophy "sharing information forces you to look at it from every side, ensure that it is really correct. I will do my best to make so"

Many don't do the latter

re: So.. this is it

Madhivanan — Wed, 24 Oct 2007 10:20:55 GMT

Welcome to sqlblogcasts blog