Fantastic, Kumar!

How about this?

select ISNULL(ItemSubID ,ItemSubValue ) ItemSubID , ItemSubValue from #TempData

where ( ItemSubID is null and ItemSubValue < 0 )

or ItemSubID = ItemSubValue

Oh yeah, now i get it , Jeff.. completely missed it ;...

As GSquared hinted, this looks like a homework..But as u are insisting, i am providing a solution.

declare @tab table

( student_id int,

School_Id int

)

insert into @tab

select 100 , 1

union all...

They could be used in SELECT when there is a column from the 2 tables having the same name. Like

SELECT A.Sum_Col1 , B.Sum_Col1

FROM

( select SUM(Col1) Sum_Col1 FROM ...

brett.y (2/16/2011)

---

I dont suppose anybody would be kind enough to explain why there is an A and a B at the end of both selects. If they are removed...

Oops, Jeff had already posted the same solution 🙂 Sorry Jeff,dint see it 🙂

How about this?

DECLARE @Scheduled VARCHAR(2) = '3'

,@BeginTime VARCHAR(8) = '05:55:00'

...

Yes we have got the sample data, but what do u want to achieve from that? I mean, can u be still more clear on your requirement.

Can you please be more specific on your requirement ? I am unable to figure it from your initial post.. This (all possible combination) seems doable with CROSS JOINS ,...

brett.y (2/16/2011)

---

Thank you ColdCoffee that is EXACTLY what I was after. I just now have to work on the where clause. I have wasted 4 hours tring to...

How about this?

declare @data1 table ( Name varchar(10), datepar varchar(25))

insert into @data1

select 'Smith', '3/16/2010@0930'

union all select 'Smith', '3/16/2010@1100'

union all select 'Smith', '3/17/2010@1300'

declare @data2 table...

You dint provide sample data yet.. you are providing us only Expected Result and the current result.. PLease post the sample data, then we will straightaway work on this 🙂

How about this?

SELECT T1C1 , T2C1

FROM

( select SUM(Col1) T1C1 FROM T1 ) A

CROSS JOIN

( select SUM(Col1) T2C1 FROM T2 ) B

First, let us set-up the sample data:

DECLARE @Configuration TABLE

(

ID INT,

NAME VARCHAR(3)

)

INSERT INTO @Configuration

SELECT...