Viewing 15 posts - 2,056 through 2,070 (of 6,486 total)
I am not understanding the specifics of your query, not do I fully understand why you're doing this.
that being said - you probably want to look up using the HAVING...
January 13, 2009 at 3:49 pm
Chip Smithson (1/13/2009)
Another way to lose any leading or trailing spaces....
select column from table where len(ltrim(rtrim(column))) > 6
The rtrim isn't necessary since len will take care of that for you....
January 13, 2009 at 11:06 am
It will help with introducing the ability to defragment the table. With NO clustered index, the only way to defrag a heap is to copy all of the data...
January 13, 2009 at 10:43 am
As long as the "characters" being sought don't include blanks - I agree with Maxim.
If you might be looking for trailing blanks - then concatenate a . and look for...
January 13, 2009 at 10:32 am
Jeff Moden (1/12/2009)
GSquared (1/12/2009)
I like the Inner Join syntax. Makes it easier for me to read (not for you, but it does for me)....
January 12, 2009 at 2:46 pm
My first thought would be - what version of VB? in 2005 and 2008, MS got picky as to what feature you could get to depending on the version....
January 9, 2009 at 3:16 pm
Grant Fritchey (1/9/2009)
Yeah, but "reflect in another block"?
Try replacing "block" with Panel. And see if that makes more sense.
Of course - that's purely my read.
January 9, 2009 at 3:07 pm
GilaMonster (1/9/2009)
DavidB (1/9/2009)
January 9, 2009 at 1:20 pm
GSquared (1/9/2009)
January 9, 2009 at 12:51 pm
Grant Fritchey (1/9/2009)
Jack Corbett (1/9/2009)
Grant Fritchey (1/9/2009)
Jack Corbett (1/9/2009)Hey, that's why I've spent the last 2+ months in NH.
Because my wife told you too?
Every married man has a "She who...
January 9, 2009 at 11:33 am
ramadesai108 (1/9/2009)
But how long does it take to type the word "WHERE" ? Im I missing something? The queries are as simple as:
SELECT * FROM tblA...
January 9, 2009 at 11:25 am
Your error has nothing to do with the DEFAULT setting. It's more haing to do with the fact that your INSERT statements are now imbalanced. As in -...
January 9, 2009 at 11:21 am
Looks like a debugging artifact left in place when deployed to prod. I resort to that in QA when I want to selectively test things that were previously disabled....
January 9, 2009 at 10:04 am
Assuming the incoming file format lends itself to it, you could go "old school" and use BCP. It's fairly easy to automate, so that you just have to feed...
January 9, 2009 at 8:08 am
Can you validate that any of those values in the mFunerals(i) object are actually NULL? .NET seems to "hate" NULLs, so you tend to have to work extra hard...
January 7, 2009 at 2:27 pm
Viewing 15 posts - 2,056 through 2,070 (of 6,486 total)