sqlbump.blogspot.com

SQL Bump

MS SQL Server Blog. Tuesday, January 4, 2011. For presentation purposes on reports, i often need to show the data in CSV. The CSV string are normally very similar and for long string of CSV, it become very unsightly. So i wrote a small function to compress the CSV string. From “0001,0002,0004,0005’ to “0001,2,4,5”. Csv list nvarchar( max. Item = stringval, max len = max. Com len = max. Apply dbo.F TABLE NUMBER RANGE (1, l.max len) n. Item, 1, n.NUMBER) = max. Item, 1, n.NUMBER). Csv list, ','. Number tab...

http://sqlbump.blogspot.com/

OVERVIEW OF sqlbump.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

14

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLBUMP.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 9 reviews

5 star

3

4 star

2

3 star

2

2 star

0

1 star

2

Hey there! Start your review of sqlbump.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLBUMP.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

14

SSL

EXTERNAL LINKS

0

SITE IP

74.125.225.10

LOAD TIME

0.594 sec

SCORE

6.2

PAGE TITLE

SQL Bump | sqlbump.blogspot.com Reviews

<META> DESCRIPTION

MS SQL Server Blog. Tuesday, January 4, 2011. For presentation purposes on reports, i often need to show the data in CSV. The CSV string are normally very similar and for long string of CSV, it become very unsightly. So i wrote a small function to compress the CSV string. From “0001,0002,0004,0005’ to “0001,2,4,5”. Csv list nvarchar( max. Item = stringval, max len = max. Com len = max. Apply dbo.F TABLE NUMBER RANGE (1, l.max len) n. Item, 1, n.NUMBER) = max. Item, 1, n.NUMBER). Csv list, ','. Number tab...

<META> KEYWORDS

1 sql bump

2 compress csv string

3 create

4 function

5 dbofn compress csv

6 returns

7 nvarchar max

8 with

9 encryption

10 begin

CONTENT

Page content here

KEYWORDS ON PAGE

sql bump,compress csv string,create,function,dbofn compress csv,returns,nvarchar max,with,encryption,begin,declare,com len int,list as,select,len stringval over,from,dbocsvtable @csv list,nnumber,list l,cross,group,having,substring,return,stuff replace '

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL Bump | sqlbump.blogspot.com Reviews

https://sqlbump.blogspot.com

MS SQL Server Blog. Tuesday, January 4, 2011. For presentation purposes on reports, i often need to show the data in CSV. The CSV string are normally very similar and for long string of CSV, it become very unsightly. So i wrote a small function to compress the CSV string. From “0001,0002,0004,0005’ to “0001,2,4,5”. Csv list nvarchar( max. Item = stringval, max len = max. Com len = max. Apply dbo.F TABLE NUMBER RANGE (1, l.max len) n. Item, 1, n.NUMBER) = max. Item, 1, n.NUMBER). Csv list, ','. Number tab...

INTERNAL PAGES

sqlbump.blogspot.com

1

SQL Bump: Compress CSV String

http://sqlbump.blogspot.com/2011/01/compress-csv-string.html

MS SQL Server Blog. Tuesday, January 4, 2011. For presentation purposes on reports, i often need to show the data in CSV. The CSV string are normally very similar and for long string of CSV, it become very unsightly. So i wrote a small function to compress the CSV string. From “0001,0002,0004,0005’ to “0001,2,4,5”. Csv list nvarchar( max. Item = stringval, max len = max. Com len = max. Apply dbo.F TABLE NUMBER RANGE (1, l.max len) n. Item, 1, n.NUMBER) = max. Item, 1, n.NUMBER). Csv list, ','.

2

SQL Bump: Calculating EAN 8 / EAN 13 Check Digit

http://sqlbump.blogspot.com/2010/03/calculating-ean-8-ean-13-check-digit.html

MS SQL Server Blog. Wednesday, March 10, 2010. Calculating EAN 8 / EAN 13 Check Digit. Just wrote a quick function to calculate the check digit for EAN 8 / EAN 13. Chk digit = SUM. Barcode, LEN(@barcode) - num 1, 1) * CASE. Num % 2 = 1 THEN. Chk digit = (10 - (@chk digit % 10) % 10. Wednesday, March 10, 2010. June 17, 2011 at 7:03 PM. August 17, 2011 at 10:01 PM. January 7, 2012 at 11:27 AM. September 27, 2013 at 10:11 AM. June 5, 2014 at 4:07 PM. August 6, 2014 at 11:02 PM. November 21, 2014 at 7:48 PM.

3

SQL Bump: Number Table

http://sqlbump.blogspot.com/2010/10/number-table.html

MS SQL Server Blog. Friday, October 1, 2010. Number table or tally table as it is also known as, is a very useful table in my day to day query. There are lots of way to do that. In my other post, i uses a numbers table. Here is how i create the numbers table. And to populate it with numbers, a recursive cte is used. Num option (maxrecursion 0). Here i inserted number 0 to 1000. You can change the query to any number you required. Friday, October 01, 2010. May 24, 2012 at 7:30 PM. June 11, 2012 at 11:32 AM.

4

SQL Bump: Sum of Digits of a number

http://sqlbump.blogspot.com/2010/06/sum-of-digits-of-number.html

MS SQL Server Blog. Wednesday, June 9, 2010. Sum of Digits of a number. Using recursive cte, you can calculate the sum of all the digits of a number easily. Example, a number 1234, the sum of the digits will be 1 2 3 4 = 10. Here is the function to do that. Number = @number / 10, digit = @number % 10. Number = number / 10, digit = number % 10. This function will make the calculating the EAN check digit. Wednesday, June 09, 2010. May 24, 2012 at 7:27 PM. Nice and easy solution. August 10, 2012 at 12:54 AM.

5

SQL Bump: January 2010

http://sqlbump.blogspot.com/2010_01_01_archive.html

MS SQL Server Blog. Wednesday, January 27, 2010. First Monday of The Year. How to find the 1. Monday of the year for a given year? This is a commonly ask question and there are lots of solution around. Most of the solution uses a known reference date to do it or some based on the value return from datepart(weekday, date ). The problem with datepart() is it is depending on the SET DATEFIRST value. Just try the following script and you will see. Datepart] = datepart(weekday, '2010-01-04'. Monday of the Year.

UPGRADE TO PREMIUM TO VIEW 9 MORE

TOTAL PAGES IN THIS WEBSITE

14

OTHER SITES

sqlbuddy.com

SQL Buddy - Web based MySQL administration

SQL Buddy – Web based MySQL administration. Just unzip the files to your server and it's ready to use. Seriously, the next step is logging in. Complete control of users. Logins are handled directly by MySQL. Create as many or as few users as you want. The current release is bundled with 47 translations! SQL Buddy is absolutely awesome: it's super-easy to set up, has a beautiful interface, and is fun to work with! I just absolutely love SQL Buddy. So much nicer than PHPMyAdmin.". SQL Buddy 1.3.3.

sqlbuddy.de

SQL Buddy - techstuff: mysql, apache, linux & worpdress ...

Techstuff: mysql, apache, linux and worpdress …. Brute-force Attacke: Einzelne IP’s in Firewall sperren. November 8, 2016. November 8, 2016. SSH Login: eMail Benachrichtigung an Admin versenden. June 2, 2016. Google Suchbefehle – Befehle für die Google Suche. May 8, 2016. May 8, 2016. Google bildet zwischenzeitlich die einzelnen Suchparameter über die Erweiterte Suche direkt im Browser ab, trotzdem ist es sinnvoll die wichtigsten Google-Suchbefehle zu kennen. Suchwortketten mit Anführungszeichen: Dur...

sqlbuddy.willemps.com

phpMyAdmin

sqlbuff.com

sqlbuilder.codeplex.com

Oragon Architecture SqlBuilder - Home

Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Last edited Feb 9, 2013 at 1:44 AM. There is no recommended release for this project. Version 8.4.2015.21029.

sqlbump.blogspot.com

SQL Bump

MS SQL Server Blog. Tuesday, January 4, 2011. For presentation purposes on reports, i often need to show the data in CSV. The CSV string are normally very similar and for long string of CSV, it become very unsightly. So i wrote a small function to compress the CSV string. From “0001,0002,0004,0005’ to “0001,2,4,5”. Csv list nvarchar( max. Item = stringval, max len = max. Com len = max. Apply dbo.F TABLE NUMBER RANGE (1, l.max len) n. Item, 1, n.NUMBER) = max. Item, 1, n.NUMBER). Csv list, ','. Number tab...

sqlburger.blogspot.com

SQLBURGER

Quinta-feira, 14 de março de 2013. Atualização do cache do Intellisense–Microsoft SQL Server. Esta é uma dica rápida pra quem tem dificuldade em trabalhar com o Intellisense do SQL Server. Para este exemplo, estou usando a versão 2008R2, então creio que isso se aplique a todas as versões a partir da 2005. Muitos desabilitam o intellisense exatamente por não compreender o comportamento da ferramenta, porém ela é muito útil. Compartilhar com o Pinterest. Domingo, 6 de janeiro de 2013. 1ª opção: Buscando os...

sqlburn.com

SQLBurn

It is all about the check boxes. Thursday, May 14, 2015. How to keep users from doing a select * on a table. We all know doing a select *. On a table is not good practice. But how do you keep the users, especially report writers, from doing just that? Well it is fairly easy but I would check with the application owner/developer before implementing this. And, as always, do this in dev and test first. That assumes you are lucky enough to have a dev and test environment. Create table dbo.computed. There is ...

sqlbusinessdesign.co.uk

Powerful Business Systems

Please contact us using this form. You can alternatively call us on 0203 0053 793. Please enter your name. Please enter a valid e-mail. Invoice and Customer Management. Boost Productivity By 300% - Sell More, Faster. Let's Go ». Reduce Costs, Errors, Boost Effeciency and Automate Any Tasks. Let's Go ». Manage and Grow Your Customer Base More Effectively. Let's Go ». Quickly Generate Hot Leads and Manage Your Pipeline. Let's Go ». Automated Business 2 Business Dialler. Let's Go ». Let's Go ».

sqlbutler.com

SQL Butler

SQL statements will appear here. Designed in DC / 2015.