Viewing 15 posts - 3,241 through 3,255 (of 4,080 total)
Thank you for taking the time to explain.
Good job, Flo 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2009 at 7:23 am
Thanks, Luis.
Sorry to say this, but those CREATE TABLE statements don't seem to work with your INSERT statements. I keep getting an error saying column names are invalid. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2009 at 7:21 am
Luis, can you also send the CREATE TABLE statements for FN and FO??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 6:03 pm
Great 🙂
Thanks for taking the time to let us know.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 5:18 pm
Beautiful 🙂
While I'm looking at this, have you checked out the link I pointed you to in the first message? I expect to use the same CROSS APPLY...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 4:39 pm
Shannon, could you please post up the query and subquery so that we have some idea of what you are attempting. You may have to do a workaround...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 4:26 pm
I have to ask why you are using different tables.
You can certainly join any of those tables that have common ID to get a first name/last name pair,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 3:47 pm
Let me interrupt to drag the conversation away from futbol.
Lynn!! Lynn!! I actually had someone say they had an "ah-hah" moment... with respect to setting up 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
March 30, 2009 at 3:35 pm
Great 🙂 We'll look forward to hearing from you.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 3:26 pm
Luis, I will be happy to help you. I just answered a similar question here. Let me know if you understand how it could...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 3:23 pm
Dang, you're fast, FLO !!!
When I get a chance, I'll crank out a large test set and we can race our solutions, or perhaps they could both be tested against...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 2:56 pm
Here you go. I did not take the time to do the date conversion to the format you had in your output sample, but I'm sure you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 2:54 pm
Can do. It will take a few minutes to set up. In the meanwhile, will you please have a look at this link? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 2:11 pm
I hear you, Lynn.
That thread reads like " I want the problem to be with the SQL Server. Tell me how to fix it....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 2:06 pm
Another link for 249. Fortunately I will never need anywhere near that number.
http://msdn.microsoft.com/en-us/library/ms190197.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2009 at 10:36 am
Viewing 15 posts - 3,241 through 3,255 (of 4,080 total)