Viewing 15 posts - 54,961 through 54,975 (of 59,072 total)
That was the key, Serqiy... thanks ol' friend.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 9:14 pm
Hey there, Greg! You finally made it! Welcome to the "mosh pit" ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 7:28 pm
Hi, It looks like my question is too difficult or not so clear, so I... |
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 7:25 pm
Heh...
Thanks for the nice compliment, Chris...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 7:13 pm
First off and as a bit of a side bar... you don't need the BEGIN/COMMIT pair because the default settings for SQL Server are to treat each UPDATE as an...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 7:11 pm
Peter,
Do you have an example of how to use your fine split function to find dates in a table of strings like the original OP posted?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 7:04 pm
What's the maximum number of roles?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:52 pm
Just curious... What does the DTS package do? ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:50 pm
It sure would be nice if you shared what you did to solve it... this is a forum, you know? ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:27 pm
Craig,
You mean you fixed your problem? Would you mind posting the solution? This is a forum, after all ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:24 pm
Just curious... why names like "SP20"
... not exactly "self documenting"...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:21 pm
Wow, Michael... not sure what happened there. I've seen that before (post gobbling others) but not when I've posted. Didn't even show what I posted. Matt might be right... might...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:16 pm
Something like this will work...
ALTER FUNCTION [dbo].[GetSpecialsInCase] ( @TCaseId varchar(25) ) RETURNS VARCHAR(2000) AS BEGIN DECLARE @itemList VARCHAR(8000) SELECT @itemList = IsNull(@itemlist + ', ' + char(13), space (0)) + d.SpecialsDesc FROM (--=== Derived table "d" finds correct distinct SpecialsDesc SELECT...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:09 pm
I know... preaching to the choir but I have to say it... Putting a better server on the dev side may not help that problem...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 6:03 pm
Hey there, Jules... long time no see.
I think these folks are all steering you in the right direction... One instance and multiple databases would be my inclination, as well, for...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 5:57 pm
Viewing 15 posts - 54,961 through 54,975 (of 59,072 total)