QUOTE(kzimmerm @ 25 Jun, 2009 - 11:32 AM)
UNION is the way to go. You have to make sure your columns in both selects produce the same result set.
then it is as simple as
CODE
select blah, blah from sometable1
union
select blah, blah from sometable2
Kurt
Thanks... I really want to insert the value of "my" two Select statements into 2 columns in a different table, then display the "new" table, using another Select statement.
Thanks for your help once more...
QUOTE(Torti @ 24 Jun, 2009 - 02:51 AM)
CODE
insert into tbl_AllUsers(
select count(*)Total_Notification_Users from accalert.TBL_AANSCUSTOMERS WHERE
(datecreated between '02/28/2009' and '04/01/2009')and(EMAIL_ADDR1 IS NOT NULL OR LEN(EMAIL_ADDR1)<3)
select count(*) as Total_SMS_Users from
accalert.TBL_AANSCUSTOMERS
where
(datecreated between '02/28/2009' and '04/01/2009'
) and (EMAIL_ADDR1 IS NOT NULL OR LEN(EMAIL_ADDR1) < 3) and SMS_PERMISSION=1
)
when run independently, the execute.
I need a merged result so I could display it on an ASP.NET web form.
Thanks in advance.
QUOTE(Torti @ 24 Jun, 2009 - 02:51 AM)
CODE
insert into tbl_AllUsers(
select count(*)Total_Notification_Users from accalert.TBL_AANSCUSTOMERS WHERE
(datecreated between '02/28/2009' and '04/01/2009')and(EMAIL_ADDR1 IS NOT NULL OR LEN(EMAIL_ADDR1)<3)
select count(*) as Total_SMS_Users from
accalert.TBL_AANSCUSTOMERS
where
(datecreated between '02/28/2009' and '04/01/2009'
) and (EMAIL_ADDR1 IS NOT NULL OR LEN(EMAIL_ADDR1) < 3) and SMS_PERMISSION=1
)
when run independently, the execute.
I need a merged result so I could display it on an ASP.NET web form.
Thanks in advance.
QUOTE(Torti @ 24 Jun, 2009 - 02:51 AM)
CODE
insert into tbl_AllUsers(
select count(*)Total_Notification_Users from accalert.TBL_AANSCUSTOMERS WHERE
(datecreated between '02/28/2009' and '04/01/2009')and(EMAIL_ADDR1 IS NOT NULL OR LEN(EMAIL_ADDR1)<3)
select count(*) as Total_SMS_Users from
accalert.TBL_AANSCUSTOMERS
where
(datecreated between '02/28/2009' and '04/01/2009'
) and (EMAIL_ADDR1 IS NOT NULL OR LEN(EMAIL_ADDR1) < 3) and SMS_PERMISSION=1
)
when run independently, the execute.
I need a merged result so I could display it on an ASP.NET web form.
Thanks in advance.
Thanks... I really want to insert the value of "my" two Select statements into 2 columns in a different table, then display the "new" table, using another Select statement.
Thanks for your help once more...
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
