I don't think that there is any "generic" approach.

Nothing usefull can be advised without knowing any sort of details.

Providing invloved table's and other objects DDLs, query itself and its...

That is the first step to get the answer you need:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you follow the above, you most likely will get relevant help quite promptly...

And if you really want a complete copy of Table2 in Table1 then you can do...

I guess the first step whould be reading this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Not enough details to suggest a solution.

What do you mean by merge in your case?

1. May you have the same data in both databases?

If Q#1 = Yes:

2....

Create a temp table to hold results in a way you need.

Then decalre a cursor over your query which lists db names, table names and column names

Then you will need...

The best way would be using pre-build calendar table. The following example creates on-fly calendar containing weekend days for 100 years starting from 1 Jan 2000.

declare @sample table (StartDate datetime,...

or without calendar table:

declare @dtFrom date

declare @dtTo date

select @dtFrom = '2013-12-15'

,@dtTo = '2014-02-18'

select year(dt) [Year], month(dt) [Month], count(*)

from (select top(datediff(d,...

It's almost impossible to build solution which will cover all posible permitations of something which looks like the free-text.

He is a bit more comprehensive logic which cover most of your...

You can try

SELECT a.accountId

,(SELECT SUM(m.debit) FROM accountMovs m WHERE m.accountId LIKE a.accountId + '%') Debit

...

declare @XML xml

set @XML =

'<Recordset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Products>

<Productdetails>

...

1. Wrong syntax

2. Danger of converting date into non ISO formatted date string (code 101, means that potentially you may have something like 05/06/2014. Now tell me is it 5th...

mandrewthebarbarian (2/20/2014)

---

The presented results are not exceptions that should be returned. How do I modify the query to exclude orders where the same SKU is present on multiple...

What in your "sample data " indicates that the stock changed on...

I cannot see from your example, what kind of logic splits set of dates:

to

FROM 2014-02-01 TO 2014-02-02

FROM 2014-02-03 TO 2014-02-05

FROM 2014-02-06 TO 2014-02-14

FROM...