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: 323482 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

_ms65g_

SSCommitted

Points: 1504

May 18, 2010 at 10:16 pm

#1169215

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: 323482 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

_ms65g_

SSCommitted

Points: 1504

May 18, 2010 at 10:21 pm

#1169217

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)