Can you please try that on SSMS, and see what happens? it may there something wrong from C#.

It's independent ETL solution by Microsoft but from any source to any destination and you don't need to have SQL Server as software or staging to move data, I highly recommend you to use it, any help...

what about SSIS? I didn't use SSMA.
You can use SSIS to move\copy data in fast and smooth way.

Greate, Sknake

Open new query document and copy the script and paste it there.

Check this http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/867b3a86-18ad-45f8-b051-4e7312233587/ or search on that...

Do you have any triggers on those tables?

Here you're

SELECT WorkOrders.ID, employees.name, employees_1.name AS Expr1
FROM WorkOrders LEFT OUTER JOIN
employees AS employees_1 ON WorkOrders.submitted_by...

Remove alias and use the table name directly. Replace every T1 & T2 with tblEmailClub

After digging I came with bad performance solution :s but I think it works,

SELECT
T1.address1,
tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,
tblEmailClub.email,...

You've right, I'll try something else and reply you.

No, distinct works on column and it removes the duplication, I tried it myself.

hmmm, That's because of obligation of being distinct in first place

SELECT
DISTINCT (tblEmailClub.address1),
tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,...

You say it doesn't work in this way

SELECT tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,
tblEmailClub.email,
tblSourceHistory.datereg,
tblEmailClub.active,...

Use Distinct keyword

*Not to mention I used Pubs database and worked on Authors table (address column)

Dear Andresasongko,


select
REVERSE
(
substring(
REVERSE(address)
, 0
, CHARINDEX(' '

Yes

Yes, SQL Server 2005 has better performance over SQL Server 2000, and I think migration to 2005 is essentially.
No problem from your side else remove * and replace it with columns names. Yes it...

Are you sure you using correct database?

You don't have column "UserName"

You're welcome, I'm happy you solved your problem, please mark it as solved.

oooh. I thought you did, take your time, best of luck!

Very great :) please mark this thread as solved.

How could you by pass MSDN!! http://msdn.microsoft.com/en-us/library/ms190479.aspx

First of all your database design isn't correct, or you've another opinion? discuss that with me..
I don't need to waste time in writing SQL Statement on invalid database design, your query isn't...

haaaa, give me your tryings friend :)

Mark it as solved please!

I can't do that, never ever!!! I was seriously suggesting, some time I don't find RENAME but F2 works! I'll see it myself and be back!

F2 doesn't work?

My friend it's not related to MS SQL Server :) it's about how can you play with the datetime value returned from SQL Server, as SQL Server returns the value, the problem is over here, and you can...

I am happy more than you because your problem solved :)
Please mark it as solved, and feel free to come here again to ask, and share your knowledge :)

Update SP2 on the server machine

So you need to install SP for x86, iff the server which SQL Server not client tools resides in is x86.
See SP2 help file for the instructions.

The SQL Server. Contact the administrator.

Try, be sure the SP2 is also x64

x86 or x64??

Keep me up-to-date...

Sure you must upgrade the server not the client :) read the URL content again they solved the problem.

Analysis and Reporting doesn't mean anything, but it's important to know the cause, did you look to the URL?