Viewing 15 posts - 1,681 through 1,695 (of 5,590 total)
Jeff Moden (3/16/2011)
The most recent code offered by Wayne S works exactly the way you want it to. Try it.
Jeff, I think that you're replying to the message just...
March 16, 2011 at 7:51 am
GilaMonster (3/15/2011)
WayneS (3/15/2011)
So Gail - how did your presentation go? I'm sorry that I couldn't see it.
Awesome. Great fun. Timing went perfectly too (for once)
Trying to figure if I managed...
March 15, 2011 at 9:59 pm
So Gail - how did your presentation go? I'm sorry that I couldn't see it.
March 15, 2011 at 4:00 pm
jude-32296 (3/15/2011)
Also, if you know of a good way to get references that cross databases, I would appreciate any suggestions.thx
I'm not sure what you mean by this... can you elaborate...
March 15, 2011 at 3:55 pm
I think you are going to have to look for it with the PATINDEX function - specify " %.%.%" as the pattern. This will return the position where the space...
March 15, 2011 at 3:55 pm
jude-32296 (3/15/2011)
March 15, 2011 at 11:30 am
Craig Farrell (3/15/2011)
WayneS (3/15/2011)
Steve Jones - SSC Editor (3/15/2011)
Just a reminder, 24 hours of PASS, the Women's edition, is going on today.http://www.sqlpass.org/24hours/spring2011/SessionsbySchedule.aspx
Interesting... I only recognize the names of five...
March 15, 2011 at 11:24 am
GilaMonster (3/15/2011)
WayneS (3/15/2011)
Does anyone know if we'll be able to download them later on?Streaming, not download. Something an issue with but PASS doesn't seem to be willing to change
Darn. Yours...
March 15, 2011 at 11:24 am
About the only way to do that with the JET engine is to have some alpha characters in that field in the first few records. I agree, this is a...
March 15, 2011 at 11:17 am
Steve Jones - SSC Editor (3/15/2011)
Just a reminder, 24 hours of PASS, the Women's edition, is going on today.http://www.sqlpass.org/24hours/spring2011/SessionsbySchedule.aspx
Interesting... I only recognize the names of five of the speakers...
March 15, 2011 at 11:04 am
Steve Jones - SSC Editor (3/15/2011)
Keep in mind that this key is in EVERY nonclustered index, so you don't want it narrow.
Actually (and I believe you meant to say this),...
March 15, 2011 at 10:51 am
Take the current day (of the month) and add 100 to it.
Then, starting at the second character, take two characters.
It looks to me like they are trying to get a...
March 15, 2011 at 10:44 am
MattW2010 (3/15/2011)
I actually already got feedback from the biz and that's exactly what they were looking for!
😎
March 15, 2011 at 10:40 am
March 15, 2011 at 10:34 am
Thanks for the feedback Matt. To be fair, you actually did get most of the way there yourself. Do you have any questions about this?
March 15, 2011 at 10:31 am
Viewing 15 posts - 1,681 through 1,695 (of 5,590 total)