Viewing 15 posts - 106 through 120 (of 1,155 total)
Carl Federl (5/12/2008)
May 12, 2008 at 11:58 am
While you may be able to get this guy working with context switching, it will be extremely difficult to manage and troubleshoot. The easiest solution is to create each...
May 10, 2008 at 10:00 am
What is the actually the problem with the query? Is it too slow? Post the execution plan for your query. You can post the xml version or...
May 10, 2008 at 12:26 am
rbarryyoung that is a pretty sleek avatar 😀
May 10, 2008 at 12:13 am
rbarryyoung (5/5/2008)
Try something like this:
SELECT ITEMNAME
FROM ITEMS
WHERE ITEMNAME LIKE '%' + Replace(@StringThatUsersUseToFind, ' ', ' % ') + '%'
rbarryyoung,
This may yield incorrect results depending on the spaces in...
May 10, 2008 at 12:10 am
rhandloff (5/9/2008)
May 9, 2008 at 11:41 pm
This is not leading down a path of success and successful implementation. At minimum you should have logins that segregate schemas. This way you can maintain objects for...
May 9, 2008 at 10:42 pm
xanthos (5/9/2008)
You might want to replace the dot in the time columns.DECLARE @date DATETIME
DECLARE @time CHAR(5)
SET @time = '07.45'
SET @date = CONVERT(DATETIME,REPLACE(@time, '.', ':'))
SELECT @date
SELECT LEFT(CONVERT(VARCHAR,@date,108), 5)
These guys have hit...
May 9, 2008 at 10:04 pm
I believe I remember Antonio and Jeff doing some performance testing on parser functions and if I recall correctly the tally table is slightly faster (maybe a ms or 2)....
April 8, 2008 at 12:22 pm
NP, we all have these moments. I too have to beat my head against the desk DOH!!! 🙂
Anyway, glad you got it working.
April 8, 2008 at 12:13 pm
The column names are irrelevant in a join. You are matching the data.
select mycols....
from p21_view_po_hdr_form
inner join oe_hdr
on...
April 8, 2008 at 11:32 am
Why not replace all the apostrophes andtrim the columns, for comparison. Also, I agree that the inner join would be much better, if applicable.
DECLARE @STR VARCHAR(10)
SET
April 7, 2008 at 2:30 pm
I am glad to here you got everything sorted. Thanks for posting the solution.
April 7, 2008 at 6:34 am
Keep in mind that for every distinct person returned a sub query will execute, in this case you have 3 sub queries. That means if you return 100,000 distinct...
April 6, 2008 at 8:32 am
I found this article that says the old connection may be timing out before attempting to connect to the failover partner..
It is worth a look.
April 6, 2008 at 8:10 am
Viewing 15 posts - 106 through 120 (of 1,155 total)