[font="Verdana"]

Certainly not. I have suggested the solution as per the 1st post. You havn't mentioned these possiblities, otherwise I would have been considered it as well....

[font="Verdana"]

Considering you have complete set of data into TableA and TableB have incompletedata. Here you need to update the TableB according to the TableB, right?

try this ...

Update TableB

Set TableB.Office...

[font="Verdana"]Do you mean something like this ... ?

Update OldTable

Set OldTable.EmpId = NewTable.EmpId

From OldTable Inner Join NewTable On OldTable.Education = NewTable.Education

confirm on this.

Mahesh

[/font]

[font="Verdana"]With the while loop you can do it. To explain well to you, post some live example date.

Mahesh[/font]

[font="Verdana"]You are facing this error dues to mismatch of parameters. You are passing more parameters than what actually Stored Procedure requires. i.e. If you have 10 parameters in Stored Procedure...

[font="Verdana"]

Replication is the best option over triggers.

Mahesh

[/font]

[font="Verdana"]

If possible, post some sample data with desired o/p

Mahesh[/font]

[font="Verdana"]

mick burden (4/28/2008)

---

I'd like to be able to save a web page to a table and then be able to display it again by clicking on a hyper link, is...

[font="Verdana"]

Select user_id, Min(add_date) as [Frist Log], Max(add_date) as [Last Log] From {Table} Group By user_id

by the way, you have ,mistakenly given wrong col heading.

Mahesh

[/font]

[font="Verdana"]

Select category, count(*) From {Table}

Where createdDate Between {start date} And {end date}

Group By category

confirm on this.

Mahesh

[/font]

[font="Verdana"]

Create Procedure {Proc Name}

(@xml nText)

As

...

Declare @XmlHandle Int

Declare

[font="Verdana"]

If you have Asp. Net as fron end, then what cause you to do...

[font="Verdana"]

select distinct ml.conta as 'Integração'

,Max(pc.descricao) As 'Tipo Conta'

,CL.NOME as 'Cliente'

,ml.u_subconta as 'Subconta'

,DEBMES, CRDMES, SLDMES

,DEBANT, CRDANT, SLDACCANT

,DEBACUM, CRDACUM, SLDACUM

from ml (NOLOCK) inner join pc (nolock) on pc.conta=ml.conta

inner join cl (nolock)...

[font="Verdana"]Second approach is much better than first one. It will decrease the network traffic tremendously.

By the way, if you would have been posted the question directly instead of provinding URLs,...

[font="Verdana"]

From time to time my tables are dropping 1 by 1 and the last event in the profiler is pointing to this event - SQLDMO_1, is this the cause of...