hey Philip Horan,

Nope, I am trying to copy data from DB2 to DB1 and both the database is having data. more over to that in my DB1 and Db2 the...

hey Piotr,

I am not facing problem copying the master data like users and groups,

My issue is the combination of UserId and GroupID in Group_Users table present in DB2 need to...

hey Peso,

Yes, Same Edition and Service pack and also same number of...

Ok Grant,

Cool I got it,

I was kiddin in last post..

Cheers!

Sandy.

Hey Grant,

I am only about two two Plus ....(22)+...lolz:P

Yes, In technology wise, I may not be old like you..lolz..:P

Thanks Grants, I was expecting your reply....because not having a tech...

Ok,

Thanks for guiding me.

Cheers!

Sandy.

Great,

But Can I specify the type of hash join like (In-Memory Hash Join, Grace Hash Join, Recursive Hash Join) ?

Cheers!

Sandy.

Thanks for Reply,

Can you just guide me how can it possible?

I mean the syntax for this,

it would be better.

Cheers!

Sandy.

Thanks Jeff,

Cheers!

Sandy.

hi antonio.collins,

I have used your query too, but still same result, I mean table scan here...

Can u please...

Hi GilaMonster,

Good Idea,

let me try this....

Cheers!

Sandy.

hi GilaMonster,

Thanks for Quick Reply but How can I resolve my issue?

I have a requirements to display more than 4000 character in select statements. but its giving error in Sql...

Hey pradyumna,

Answer :

1st : A Table can...

hey mo Suna Lo,

try this..

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[crosstab]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[crosstab]

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE PROCEDURE crosstab

@select...

Hi Andras,

Thanks for Idea,.

Cheers!

Sandy.