Ritesh glad I could help, and thank you very much for the positive feedback. It's nice to know when something works well for someone.

i think you want to avoid giving the db_datareader role in database 1.

the two roles are additive..meaning db_datareader can read EVERY view and table...so adding them to a "restricted" role...

i hope i can explain this well...

a correlated sub query is where a column from the OUTER query is referenced in the sub query to limit the results:

SELECT

...

here's one example using a CTE Tally Table:

with Tally as (

SELECT TOP 11000 --only need ten digits for this job, though

ROW_NUMBER() OVER...

well, there's a few things going all wrong here;

the first one is such a large report ....three million rows.you've lost sight of what an HTML report is supposed to do.

it's...

it's actually pretty easy;

INSERT INTO Letter_C (list of columns)

SELECT (same list of columns,same order) FROM #Temp

EXCEPT

SELECT same list of columns,same order FROM Letter_C

this will find all the...

well all you have to do is get the csv file into a table or linked server so you can use a set based operation against it.

i do not see...

could it be that one machine is connecting to , say, the PRODUCTION database and the other connecting to a older copy of that same DB, but hosted on a...

you've definitely got some data that cannot be converted to int, ie empty string or 'N/a' that someone data entered;

I'd suggest changing the join and the WHERE statement as...

there's a great article on SimpleTalk on the subject.

it's got examples of doing it two ways, via opendatasource and also Excel Automation via sp_OACreate and stuff;

this article is doing it...

man this is really interesting, but the rabbit hole is getting deeper and deeper.

if you send an email via sp_send_mail with SECURE in the subject, does your Exchange Server encrypt...

Micrsofot has a couple of Migration Assistant tools to help you migrate Oracle to SQL Server (and another one for MYSQL to SQL Server)

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

another alternative, if it is just a...

the critical part is adding the WHERE statement...some of your data does not contain a comma...

you want to exclude those items

--items with the offending command and extra data

SELECT LEFT(NAME,CHARINDEX(',',NAME)-1 )

FROM...

here's an example of what Wayne refered to:

With MySampleData as

(

SELECT 'Support Centres , Miscellaneous SC' As TheName UNION ALL

SELECT 'Support Centres , Care of tracey Whitehall' UNION ALL

SELECT 'Support Centres...

i believe the calculated column has to be dropped and recreated as a new calculated column.

i just tried this as a proof of concept, and I get a syntax error...