Problem with a Query

Question

Post reply

Problem with a Query

_ms65g_

SSCommitted

Points: 1504
More actions
May 18, 2010 at 9:25 pm

#219030

Hi,
I need for achieving a special result. I love somebody to this reason I would post a query that calculate and show a beautiful and big Heart image like this:select ' I Love You' union all
select ' ' union all
select ' * * ' union all
select ' * * * * ' union all
select ' * * * ' union all
select ' * * ' union all
select ' * * ' union all
select ' * * ' union all
select ' * *' union all
select ' * *' union all
select ' * *' union all
select ' * *' union all
select ' * *' union all
select ' * *'
Please do not laugh me!
I try some with REPLICATE by I cannot do that.
Please suggest me a query

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

i feel for you;

i did a search for "ascii art hearts" and found lots of examples;

i found this nice one ad wrapped it with the SELECT...UNION ALL, same that your example did;

hope this helps. remember it really depends on a fixed width font.

SELECT ' ) ' UNION ALL

SELECT ' ( ' UNION ALL

SELECT ' ( ( ) ' UNION ALL

SELECT ' ) " ' UNION ALL

SELECT ' ( ) ' UNION ALL

SELECT ' " | | ' UNION ALL

SELECT ' | (( )) ' UNION ALL

SELECT ' | )) )) ) // ' UNION ALL

SELECT ' )) ( ) / / ( ( ( | ' UNION ALL

SELECT ' .( \ \ ( ( ( ) ) ) )) ' UNION ALL

SELECT ' ( ( ) '.' '. " .' / ( \ ' UNION ALL

SELECT ' ) \ .' '._.' '._ ) ) ' UNION ALL

SELECT ' : '' _.oooooo._ _.oooooo._ '' / ' UNION ALL

SELECT ' ) .odOOOOOOOObo.odOOOOOOOObo. | ' UNION ALL

SELECT ' / dOOOY dOOOOOOOOOOOOOOOOOOOOOb ( ' UNION ALL

SELECT ' OOOY dOOOOOOOOOOOOOOOOOOOOOOOOO \ ' UNION ALL

SELECT ' dOOY dOOOOOOOOOOOOOOOOOOOOOOOOOOb ' UNION ALL

SELECT ' OOO dOOOOOOOOOOOOOOOOOOOOOOOOOOOO ' UNION ALL

SELECT ' OOO YOOOOOOOOOOOOOOOOOOOOOOOOOOOO ' UNION ALL

SELECT ' YOOb OOOOOOOOOOOOOOOOOOOOOOOOOOOY ' UNION ALL

SELECT ' YOObdOOOOOOOOOOOOOOOOOOOOOOOOOY ' UNION ALL

SELECT ' YOOOOOOOOOOOOOOOOOOOOOOOOOxXY ' UNION ALL

SELECT ' "YOOOOOOOOOOOOOOOOOOOOOxXY" ' UNION ALL

SELECT ' "YOOOOOOOOOOOOOOOOOAoS" ' UNION ALL

SELECT ' YOOOOOOOOOOOOOxXXXY ' UNION ALL

SELECT ' "YOOOOOOOOOxXXXY" ' UNION ALL

SELECT ' "YOOOXXXXY" ' UNION ALL

SELECT ' ""Y"" '

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

_ms65g_ SSCommitted Points: 1504 More actions · Answer 2

Thanks, but I am looking for a query that generates the result and we cannot to see the result before running it.

Lowell SSC Guru Points: 323518 More actions · Answer 3

ok, still easy to do...can we assume the query results will be seen in text mode?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

_ms65g_ SSCommitted Points: 1504 More actions · Answer 4

Lowell (5/18/2010)
ok, still easy to do...can we assume the query results will be seen in text mode?

Yes.

_ms65g_ SSCommitted Points: 1504 More actions · Answer 5

I got it! 🙂

select convert(varchar(150),0x202020202020202020202020202020202020202020202020202020202020292020202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202020202020202020202020202020202820202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202028202020202020202020202020282029202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202029202020202020202020202020202220202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202820292020202020202020202020202020202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202022202020207C202020202020202020207C2020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020207C20202020202020282820202020202020202020292920202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020207C2020202020292920202020202029292020202920202020202F2F2020202020202020202020202020202020) union all

select convert(varchar(150),0x20202020202020292920202028202920202020202F202F202020282020202028202820202020207C2020202020202020202020) union all

select convert(varchar(150),0x202020202020202E28202020205C205C2020202820282020202820292020202920202920202020292920202020202020202020) union all

select convert(varchar(150),0x202020202020282028202020202029202E202020202E20202220202E20202020202F20202028205C2020202020202020202020) union all

select convert(varchar(150),0x2020202020202029205C20202E202020202020202020202E5F2E2020202020202020202E5F2020292029202020202020202020) union all

select convert(varchar(150),0x202020202020203A20202020205F2E6F6F6F6F6F6F2E5F2020205F2E6F6F6F6F6F6F2E5F20202020202F202020202020202020) union all

select convert(varchar(150),0x20202020202020202920202E6F644F4F4F4F4F4F4F4F626F2E6F644F4F4F4F4F4F4F4F626F2E2020207C202020202020202020) union all

select convert(varchar(150),0x202020202020202F2020644F4F4F5920644F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F62202028202020202020202020) union all

select convert(varchar(150),0x2020202020202020204F4F4F5920644F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F20205C2020202020202020) union all

select convert(varchar(150),0x2020202020202020644F4F5920644F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F6220202020202020202020) union all

select convert(varchar(150),0x20202020202020204F4F4F20644F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F20202020202020202020) union all

select convert(varchar(150),0x20202020202020204F4F4F20594F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F20202020202020202020) union all

select convert(varchar(150),0x2020202020202020594F4F62204F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F5920202020202020202020) union all

select convert(varchar(150),0x202020202020202020594F4F62644F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F592020202020202020202020) union all

select convert(varchar(150),0x20202020202020202020594F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F785859202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202022594F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F7858592220202020202020202020202020) union all

select convert(varchar(150),0x2020202020202020202020202022594F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F4F416F5322202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020594F4F4F4F4F4F4F4F4F4F4F4F4F78585858592020202020202020202020202020202020) union all

select convert(varchar(150),0x2020202020202020202020202020202022594F4F4F4F4F4F4F4F4F785858585922202020202020202020202020202020202020) union all

select convert(varchar(150),0x2020202020202020202020202020202020202022594F4F4F585858585922202020202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202020202020202222592222202020202020202020202020202020202020202020202020)