Start with this:

select

rightt.*,

leftt.*

FROM

#temp2 leftt

left outer join #temp1 rightt

...

based on this:

(CONVERT(nvarchar, FireBrigade_ShiftFallows.ActualStartDate, 102) = CONVERT(nvarchar, @date,102))

I'd do this:

FireBrigade_ShiftFallows.ActualStartDate >= dateadd(dd, datediff(dd, 0, @date), 0) and

FireBrigade_ShiftFallows.ActualStartDate < dateadd(dd, datediff(dd, 0, @date) + 1, 0)

😎

We had a similiar, yet different, problem between two PeopleSoft production servers. We had to configure DTC on both servers to fix the problem even though the data transfer...

Just to be sure, did you modify the DTC settings on both servers?

😎

Okay....

Start here:

http://www.sqlservercentral.com/articles/Administering/debuggingmsdtcissues/1257/

http://www.sqlservercentral.com/Forums/Topic450909-146-1.aspx

😎

Not that familiar with the behind the scenes processing. I just seem to remember seeing something similiar to this before and this was the suggestion given. Can't hurt...

To get you started, you'll want to use a ForEach container and the FileSystem task. Exactly how you would use them, I don't know off the top of my...

Looking at BOL, it looks like you use just like a table.

I would still load the data into a temp table before doing the join.

😎

Take a read of BOL. I think I have seen this before, and you may need to use OPENROWSET.

😎

No. He asking if you can add the table you want to join into the stored proc and join it to the other tables there.

😎

You need to populate a temp table with the results from the stored proc and then join to the temp table. Unfortunately SQL Server does not let you treat...

I'd need a little more specifics. The table DDL, smaple data (in the form of insert statements that can be cut, pasted, and executed to populate the table), and...

I'll agree, you have a process that is working, you don't need to change it unless your requirements change.

One of the things I sometimes needed to do was restore a...

That sounds like a good script for the script library.

😎

I was manually zipping backup files using PKZip. and it did a great job. Problem was: 1) it was manual, and 2) it was time intensive.

Using HyperBac cut backup...