append rows to (select statement) result

Question

0.00/5 (No votes)

See more:

please i want to select all [varchar(shortcodes)] from table to put it in dropdownlist
and make the first item in dropdownlist (All)when user select value from this list show data for this shortcode and if user select All show data for all codes

how to append word all to int data selected from table
any idea ?

Posted 6-Jun-12 8:48am

eman88

Add a Solution

2 solutions

Solution 2

You can use temporary table:

SQL

IF NOT OBJECT_ID(N'@SomeData',N'U') IS NULL
    DROP TABLE #SomeData

CREATE TABLE #SomeData(f1 INT, f2 CARCHAR(30))

INSERT INTO #SomeData (f1, f2)
SELECT f1, f2 
FROM YourTable

DECLARE @iVal INT
--get max +1 
SELECT @iVal = ISNULL(MAX(f1,0))+1 
FROM YourTable
--add 'ALL' word with corresponding value
INSERT INTO #SomeData (f1, f2)
    VALUES (@iVal, 'ALL')

--fetch data from temporary table
SELECT *
FROM #SomeData

After all, remember to delete temporary table!

Posted 6-Jun-12 12:52pm

Maciej Los

Comments

VJ Reddy 6-Jun-12 19:54pm

Good alternative. 5!

Maciej Los 7-Jun-12 3:12am

Thank you, VJ ;)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

idle63 · Accepted Answer · 2012-06-06T09:04:00

Solution 1

You can use UNION to solve this. This is an example for interbase SQL Server. Probably you need to adapt.

SQL

SELECT  
    CAST('2' AS INTEGER),
    CAST(YOURINTFIELD AS CHAR(30))
FROM YOURTABLE
UNION
SELECT  
    CAST('1' AS INTEGER),
    CAST('All' AS CHAR(30))
FROM YOURTABLE
ORDER BY 1,2

Posted 6-Jun-12 9:04am

idle63

Comments

eman88 6-Jun-12 15:15pm

thanks so much it works for me :)

[no name] 6-Jun-12 15:17pm

You are very welcome. Thank you for accepting my solution.
Regards, Bruno

VJ Reddy 6-Jun-12 19:54pm

Good answer. 5!

[no name] 7-Jun-12 14:26pm

Thank you. Regards.

Maciej Los 7-Jun-12 3:13am

Good work, my 5!

[no name] 7-Jun-12 14:26pm

Thank you. Regards.