I'm sure everybody in this thread is glad to be able to help you

You should be able to reach the data by calling tables from that server by this format:

server.database.user.tablename

While you can use database..tablename normally, referring to a linked server should be fully...

vibin.das (2/24/2009)

Currently I'm facing an issue in my project.I have a table which stores the content of Documents(Word and Excel) as varbinary in Database.I need to compare the contents...

Either you first declare all the numbers in in float or numeric variables, or you CAST all the numbers in the SELECT. I chose for the first to give you...

From just your input it's hard to say what's the problem. Can you post table description, sample data and the sql you're trying to make?

This totally confuses me. Why not post the full query, replacing real names with fake ones where ever you want? I can't match your last piece of code at all...

I think [ON_KEY_42R5_UDM2]..[dbo.fn_astTypeGetSecondHighestAssetTypeBelowRoot(astAssets.AssetTypeID)]should be changed in [ON_KEY_42R5_UDM2].dbo.fn_astTypeGetSecondHighestAssetTypeBelowRoot(astAssets.AssetTypeID)or, alternatively

[ON_KEY_42R5_UDM2].[dbo].[fn_astTypeGetSecondHighestAssetTypeBelowRoot](astAssets.AssetTypeID)

Using [] defines an exact name. SQL Server uses it always when it scripts for you, because names aren't checked for spaces or...

You don't have to know about C# to learn T-SQL. C# is only used in applications using SQL Server. I suggest you buy a book in the likes of SQL...

I think it should work using a FULL JOIN, COALESCE(DB.item, XML.item) all items and use the bookmark from the DB table.

If you need further help, please post the table description...

The best would be to make a date dimension, with 1 row per day. Make in that dimension also day, month and year columns. If you use indexes well, it...

Bruce W Cassidy (2/3/2009)

Or if the first letter in ssr.SRC_SYS_ID describes the same...

I think that the problem is absolutely in the qty_tested item, try to run the query without that part, and I think it would run smoothly. If that's the case,...

I think the bottleneck is the first view. All these inline select statements generally slow down a lot. If you move these to LEFT OUTER JOINs, at least your query...

I definitely agree with Juno, In Bruges and Burn after reading. The Dark Knight wasn't very special to me, but I seem to be one of the few. I have...

Nils Andersson (1/30/2009)

Im on sql 2000 here som im not able to use cte, sorry.

@r.hensbergen, your query works perfect but I dont see the logic in it.

Can...