Hey, Where are all the SQL gurus -:) Am awaiting answer for the last three days. Any suggestion??

Thanks PhilCart,

ODBC tracing was on, and so it was eating up the hard disk space. Switched Off the tracing and deleted the SQL log file. Now its okay.

Didn't help.

I get error when I run the following:

Dbcc Shrinkfile('C:\Documents and Settings\Admin\Local Settings\Temp\SQL.txt',1)

Server: Msg 8985, Level 16, State 1, Line 1

Could not locate file 'C:\Documents and Settings\Admin\Local Settings\Temp\SQL.txt' in sysfiles.

I...

Thanks Luke

Package|properties|Logging solves my problem. But please explain how can I do the last step of mailing the results.

Also I want to make sure that whenever the database...

Thanks for support by all,

Actually I am supposed to carry out testing of data integration for my client, and have to show them results in interprise manager or Query Analyzer...

Thank you ALZDBA

Actually your solution is similar to

select Facility1 as [Facility 1]

,(select count(*) FROM MyTable WHERE Cond1) as [First Condition]

,(select count(*) FROM MyTable WHERE Cond2) as [Second Condition]

,(select...

Thanks all,

Now another issue,

I have a column named 'Temp'. If used in query, SQL takes it as a system name, and highlights it blue.

Any workaround??

Its not possible for me...

Lester

sp_mshelpcolumn 'Data_table' gives me the following error

Server: Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'sp_helpcolumn'.

NigelRivett

I don't know how to use syscolumns. Please give example.

Ok guys

Jeff's idea worked for me.

Nice discussion

Thanks

It is just for experimental purpose, that I want to enter a couple of rows manually.

I know INSERT statement can do it, but I just want to do it...

Thanks Phil,

worked great.............good learning

Just another question guys

How can I put the output from two select statements in one row.

Like

Select count(*) from A as 'Rows from A'

Select count(*) from...

Yes Adrian,

You may count it as a cross post, but I put it under a different subject to know if there is any generic sql script that can compare...

what is DDL and how can I create statments?. Sorry am a newbie.

Thanks. Adrian............the script worked fine, but I couldn't solve my problem. I just discovered that all the dates are present in both Tables A and Table B.

Now the issue...

thanks Lowell,

Distinct is working fine