Viewing 15 posts - 91 through 105 (of 187 total)
I'm sure everybody in this thread is glad to be able to help you 😉
February 26, 2009 at 6:54 am
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...
February 26, 2009 at 2:22 am
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...
February 24, 2009 at 4:47 am
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...
February 24, 2009 at 4:34 am
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?
February 24, 2009 at 4:22 am
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...
February 17, 2009 at 8:24 am
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...
February 17, 2009 at 5:51 am
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...
February 16, 2009 at 5:56 am
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...
February 11, 2009 at 7:56 am
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...
February 4, 2009 at 4:43 am
Bruce W Cassidy (2/3/2009)
ssr.SRC_SYS_ID = CASE LEFT(ci.IG_CD, 1) WHEN 'D' THEN 'DDA' WHEN 'G' THEN 'GRM' WHEN 'O' THEN OLL END
[/code]
[/font]
Or if the first letter in ssr.SRC_SYS_ID describes the same...
February 3, 2009 at 3:45 pm
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,...
February 2, 2009 at 4:45 am
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...
January 30, 2009 at 5:35 am
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...
January 30, 2009 at 4:54 am
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...
January 30, 2009 at 4:37 am
Viewing 15 posts - 91 through 105 (of 187 total)