Viewing 15 posts - 91 through 105 (of 188 total)
I'm sure everybody in this thread is glad to be able to help you 😉
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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?
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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,...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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 you explain...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
January 30, 2009 at 4:37 am
Viewing 15 posts - 91 through 105 (of 188 total)