happy to help! u r welcome , Maina! 🙂

Try this, sorry, i dint check it first

select distinct table_name from information_schema.columns

EXCEPT

select distinct table_name from information_schema.columns

where column_name in ('A','B')

Easily possible. Try "DelimitSplit8K Jeff Moden" in the site's search, you will find an excellent solution for your problem.

If there are diffrent number of rows getting returned by the 2 queries, then u please remove the "WHERE" clause after the cross join..

Yes oliver, changed from

SELECT CAST(10.086 AS NUMERIC(20 , 2 [/i] ))

SELECT...

Then i guess, CROSS JOIN will help you, as in

WITH CTE1 as

(

select Jan, Feb, Mar,

RN = ROW_NUMBER() OVER(ORDER BY (SELECT 0))

...

Hi there, try this:

select distinct table_name from information_schema.columns

where column_name not in ('A','B')

order by table_name

Replace 'A' 'B' with your column names...

HTH

oliver.morris (7/20/2010)

---

Hi,

Thanks for the reply using numeric

SELECT CAST(10.086 AS NUMERIC(20 , 2))

SELECT CAST (10.8 AS NUMERIC(20 , 2))

returns

10.09

and 10.80 - but I would like it to report 10.8 because...

You can use JOINS , specifically CROSS JOINS to acheive that.. but i have a query, any columns that are common to both?

Try this and let us know if this worked for you!

NUMERIC (A , 1) ?

can u post the table structure and some sample...

Ok even if it doesn, try this:

if object_id('tempdb..#temp') is not null

drop table #temp

create table #temp

(name varchar(10), amount int )

insert into #temp

...

Does your table have any primary key to work on, apart from those 2 columns?

This will be useful only in VSTF or code-maintenance... As SQL Server cleverly distinguishes between objects, i dont think naming it with "tab" is mandatory..

david.c.holley (7/13/2010)

---

Can someone explain why when I add the WHERE statement, SQL Server returns the error 'Invalid column name Rn'? The first query works and I can see the result,...