not an easy way...unless your "Table1" has columns named the same as "Table2"

you can maybe find something quickly with this sql:

you can ignore a lot of you 181 columns that...

definitely a built in function, especially considering both encrypt() and decrypt() show up with syntax highlighting.

I googled a bit and I guess you are right that they are undocumented/unsupported.

Thanks Florian, but it's the "select the topic" that is killing me

that navigation provides the paged navigation list of all 2500 + subscriptions I've subscribed to...in the case of, say...

Steve I'm having a similar...

it's integer division that is killing you

@integer / 100, if it is less than one, is zero. SQL server shortcuts the math and says int / int is an...

doh i missed he said he did that already;

only advice i have left is one post i read said that rather than update statistics, they dropped and recreated the statistics,...

this is a common issue after upgrading;

you've got to update statistics and rebuild indexes after upgrading or restoring a database that came from a previous version in order to...

doh! CLR is what i meant....I just grabbed a sample project off of codeproject.com to see if it's easy to do...

this sounds like something perfect for a CTE to do. expose an SMTP dll and read an email account.

as far as i know, you have to select the encrypted column from syscomments:

select object_name(id), encrypted, * from syscomments where encrypted 0

instead of printing, you have to use RAISERROR instead to get your ongoing progress:

--print error immediatly in batch

while 0=0

begin

raiserror ('my Progress So far....',0,1) with nowait

waitfor delay '00:00:05'

end

i didn't see the execution plan as getting attached; can you re-post it?

yeah for big datasets, bcp is the only way to go;

here's an example, works perfectly, creates a tab delimited file:

exec master.dbo.xp_cmdshell 'bcp master.dbo.ALLCITYZIPCOUNTYSTATE out c:\sampleout.txt -S localhost\SQLExpress -T -c -t...

quick and dirty is to use grid mode, select the results and copy, then paste directly into Excel;

it pastes right in as tab delimited automatically..

i don't know if you can...

a typical example from SQL server's metadata:

SELECT

sysobjects.name As TableName ,

syscolumns.name As ColumnName

from sysobjects

inner join syscolumns on sysobjects.id = syscolumns.id

where sysobjects.xtype='U'

order by syscolumns.name,syscolumns.colid