Greg Charles (9/11/2009)

---

My preferred method is to script the table schema in the source database and use the Import/Export Wizard to move the data. I either run the script...

And you are expecting...what.......from here?

Hmm.. let me try this out and then ill get back to you here. My column is a char... Im going to change it to varchar then insert data and...

Check the below article out. It gives a nice explanation along with SQL 2000 and 2005 syntax and query idea's.

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=DuplicateRows

Thanks,

S

I agree with the above post. Unless you have some criteria defining with what you want back in that one row, it doesnt make sense. Or maybe we're just missing...

can you tell us what you're expecting in a result-set form?

like:

StoreID NumberofTotalProductPerStore

1 24

2 35

3 29

Something similar would help.

Thanks,

S

Hey Buddy,

You really need to use aliases! In your joins just assign each table a letter or point of reference that you think makes sense.

For example... Server.Database.SchemaName.TableName AS a

...and...

Check your aliases closely if you have any.

Assuming the empid is the unique key, you can use a self join from plan A table and in your where clause specify that you're looking for nulls. Where ever...

Try using this:

BEGIN TRY

BEGIN TRANSACTION

TSQL Logic here

COMMIT

END TRY

--Catch any errors above

BEGIN CATCH

IF @@TRANCOUNT > 0

ROLLBACK

DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int

SELECT @ErrMsg = ERROR_MESSAGE(), @ErrSeverity = ERROR_SEVERITY()

RAISERROR(@ErrMsg, @ErrSeverity, 1)

END CATCH

colin Leversuch-Roberts (5/14/2009)

---

you can't directly map cpu% ( e.g. from perfmon ) to a specific sql query very easily.

try this

--This query will list the top 50 queries which used the...

That's correct. I missed that. Thanks!

So...why exactly is this happening? I thought the whole 'This is a test string' without the quotes would show up in my result-set.

Got it. Thanks for the confirmation :w00t:

AA Hamed,

I have done multiple updates/inserts using left outer joins and they worked like a charm. I could have used EXCEPT but.. I have 9 update/inserts executing in 19 seconds....