Viewing 15 posts - 39,826 through 39,840 (of 59,072 total)
Heh... "It Depends".... might be a very long interview. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2010 at 5:58 am
Thanks for the feedback. Just to be sure, the "0" is the date serial number for 1900-01-01. Any number would have worked here but "0" is pretty easy...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2010 at 5:54 am
C# Screw (2/9/2010)
your PATINDEX idea seems a step closer to a dream 'WildReplace' function which might be :
CREATE FUNCTION dbo.fn_WildReplace(@SomeText varchar(max),
@Pattern varchar(500), @ReplaceWith varchar(max))
.....
Edit: corrected syntax
Usage :...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2010 at 5:51 am
C# Screw (2/9/2010)
'%[b][[/b]comment:#%[b]][/b]'
where [b][[/b] and [b]][/b] represent...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2010 at 5:49 am
suneel-210238 (2/9/2010)
we have around 2000 products and there will be more coming.
--But I found a soln pls let me know if it is feasible.
I added new column called rowid of...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2010 at 5:45 am
It's not you that's thick... it's me and my fingers that are thick. Thank you for the catch, Andrew
[font="Arial Black"]@ Steve,[/font]
My most sincere apologies, Steve. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2010 at 5:30 am
sanya.bandaru 52584 (2/8/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 11:53 pm
Suresh B. (2/8/2010)
2) I don't think replication is failing due to Tlog full. Confirm the reason for replication failure. Replication...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 11:52 pm
stalin6.d (2/8/2010)
Hi Guyz.I am new to this Forum. Can anyone give me a good tutorials regarding SSRS. Thanks in Advance!
I believe there's one in Books Online for...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 11:49 pm
Why not just add a "hit" log to the stored procedure? You found the information by using Profiler... seems like a user hit log would do well. Then,...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 11:25 pm
When using STUFF, the Tally table doesn't work so well for performance. Remember that although is has a ton of uses, it's not a panacea for replacing RBAR. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 11:17 pm
How many different products?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 9:56 pm
Digs (2/8/2010)
Data...here we go..
Heh... not exactly a "readily consumable" format Digs. Take a look at the article in the first link in my signature for how to get better...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 9:31 pm
Sanz (2/8/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 9:30 pm
Amit Singh (2/8/2010)
you could try a BCP with queryout to output...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2010 at 9:28 pm
Viewing 15 posts - 39,826 through 39,840 (of 59,072 total)