Hello Katherine,

If you want do do a join, why not just set up a linked server?

Hi neil,

could you please try to move the joins to where clauses as follows, I would be interested to see what the optimizer does with that:

SELECT[D1].[SID_0COMPANY] AS [SID_0COMPANY]

FROMmdp.[/BIC/FZFIGL_C02] [F]

,mdp.[/BIC/DZFIGL_C02T]...

Hi Jeff,

thanks for this article.

A solution to this problem is to use procedural code (at least for SQL2K).

Probably not the intention of the author...:D

-- Declarations

DECLARE @tblResult TABLE (asset_id char(9),...

Hm, Visual Studio Team suit.

Must be from Versace 😀

You can use a full outer join like the following:

SELECT ISNULL(A.KeyCol, B.KeyCol)

,CASEWHEN ISNULL(A.NonKeyCol1,'') = ISNULL(B.NonKeyCol1,'')

THEN 'OK'

ELSE ISNULL(A.NonKeyCol1,' ')

END

,CASEWHEN ISNULL(A.NonKeyCol2,'') = ISNULL(B.NonKeyCol2,'')

THEN 'OK'

ELSE ISNULL(A.NonKeyCol2,' ')

END

FROMTableA A

FULL OUTER...

One drawback of these kinds of solutions is their complexity. There is no easy way to customize the triggers for one or more tables.

I created a similar procedure a few...

If (non-schemabound) views are the only problem, the following might help:

SELECT 'EXEC sp_refreshview ''' + schema_name(schema_id) + '.'+ name + '''' FROM sys.views

(you need to execute this statement and then...

Thanks for your valuable inputs guys 🙂

Sure I will:

I looked at the QoD, which had the following statement that overflows.

select datediff (ms,getdate()-28,getdate())

Now when I read such a QOD, I usually play around in some directions to...

Hi Andras,

thanks for your quick response.

Can you imagine why there would be a float conversion at all?

Thanks!

http://bloggingabout.net/blogs/dennis/file/projectswing.jpg

Hi Steve,

I think you just invented the "community article" 🙂

My hope is that this will be one of those articles with a lot of discussion and ideas.

Here are a few...

Hello Gail,

you should be able to run the query I posted since it uses only system objects in MSDB.

There is no table I created myself.

Regarding the query you provided, it...

Hello Sergiy,

thanks for your response.

Do you have a web or book resource where I could find more of the information you gave me?

Especially the thing with ignoring the table alias...

Hello Gail,

Did you try this query in SQL2K5?

Because when I run it from either QA or SSMS against a SQL2K5 machine, I get no errors.

(remember, this is an ad-hoc query...