Viewing 15 posts - 2,731 through 2,745 (of 4,080 total)
Okay, gang, I'm trying a new approach to lazy posters. Experiment #1 is found here.
Steve, if you would prefer I didn't go forward with this...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 9:38 am
I feel compelled to chide you a bit If you know it wasn't the correct format to post in, why didn't you do it the right way?...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 9:35 am
Could you please supply a few rows of sample data for each table, and the expected results. It would allow the people trying to help you to test...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 9:21 am
I obviously missed out on SO much by being born too soon.
Ph'nglui mglw'nafh C'thulhu R'lyeh wgah'nagl fhtagn
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 8:36 am
What kind of roleplaying game involves conspiracies, Gail?
fnord
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2009 at 4:15 pm
No need to be so formal. Y'all can call me for short.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2009 at 10:35 am
Thanks, Lynn, and hi everybody. Forgive the odd name. It's a personal quirk that when I'm feeling somewhat uncertain and tentative, I derive to a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2009 at 10:07 am
In the stored proc, I check for the following matches.
firstname = search text or lastname = search text or (firstname+lastname = searchtext) or (lastname+firstname = searchtext).
I did not notice performance...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2009 at 9:52 am
Another potential solution is to have a stored procedure on the linked server which accepts a number of accounts and returns the results just for those accounts. The stored...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2009 at 8:01 am
This will get it done. It looks clunky, but it runs fast. You can build it into a user_defined function or CROSS APPLY it to the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 20, 2009 at 4:06 pm
Upon re-reading, I see that you have the user entering a single search string. I think it would be better to have them enter a first name and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 20, 2009 at 2:49 pm
I have a concern from looking at your "trivial" example. If your user enters both a first name of "John" and a last name of "Smith", the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 20, 2009 at 2:35 pm
Could you please provide a few rows of sample data, and what you would expect the output to look like based on that sample data?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 20, 2009 at 2:15 pm
Questions:
Is the start date you entered considered to be day 1 of week 1? In other words, if you enter a start date which is a Wednesday,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 20, 2009 at 2:10 pm
Those character strings will CAST or CONVERT directly into smalldatetime, or even implicitly convert.
select CAST('090715' as smalldatetime)
-- implicit conversion
declare @date as smalldatetime
set @date = '090715'
select @date as [@date]
Can you show...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 20, 2009 at 1:37 pm
Viewing 15 posts - 2,731 through 2,745 (of 4,080 total)