Viewing 15 posts - 136 through 150 (of 402 total)
I'm glad you could easily change it to work with 10 levels. It probably means that I also did my job with the embedded documentation
Yes Jeff that worked a treat,...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 26, 2012 at 7:45 am
====== http://www.clothes8.org ======
Air jordan(1-24)shoes $30
Handbags(Coach l v f e n d i d&g) $35
Tshirts (Polo ,ed hardy,lacoste) $15
Jean(True Religion,ed hardy,coogi) $30
Sunglasses(Oakey,coach,gucci,A r m a i n i) $15
New era cap...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 26, 2012 at 7:16 am
Jeff where to start, this code seems to work perfectly, just had to change it to work for 10 levels 🙂
So 2 things:
A) Thank-you so much for helping me on...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 26, 2012 at 6:50 am
Typical its been blue sky all week!!
Although I am right on the English border (NW Wales) so quite a distance from there!
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 26, 2012 at 3:18 am
Shell Island, spent many a good weekend there sure you'll have a great time 😀
Get the beers in and the BBQ out 😉
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 26, 2012 at 2:54 am
The weekend in Wales is going to be a good one.
Ahh coming to my neck of the woods are you! 😉
Where you going Anthony?
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 26, 2012 at 2:11 am
Jeff thank-you! 🙂
I'll run it on my test box and let you know how I get on in a bit 😀
If this works I'll mail you a crate of your...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 25, 2012 at 2:25 am
SQL Padawan (7/24/2012)
I had to tweak the code I wrote earlier.
DECLARE @TEMP...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 24, 2012 at 9:02 am
Yes I think your right, I'm still trying to get my head around this as have never had to deal with this kind of data..
Consider my posted result for Parent...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 24, 2012 at 8:12 am
Jeff Moden (7/24/2012)
I guess I just don't understand what the connection is between 1,6 and 6,3 is. For that matter, I don't see 6 connecting to anything.
Hi Jeff
Thanks for...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 24, 2012 at 7:26 am
Hi
Apologies I've had my head down trying to get this solution put into place
There are some interesting approaches on this thread and I would like to ask for your help...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 24, 2012 at 2:50 am
First, apologies for not responding sooner. I've actually be working on a demonstration of what I meant and haven't completed it yet.
No problem at all Jeff! 🙂
Yes as you suggest...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 18, 2012 at 2:10 am
Jeff Moden P.S. A While Loop will actually beat the rCTE for performance here. It's not substantial enough to necessarily warrent its use but I thought I'd bring it...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 16, 2012 at 12:42 pm
@Andy,
If you're sure there are no "loops" within the hierarchy, you could set the MAX Recursion Limit to "0" to be unlimited. I am, however, concerned that you may actually...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 16, 2012 at 12:05 pm
If you want to get away from recursive hierarchy crawling, you have to go with either a nested sets hierarchy, or use the SQL 2008 (or later) HierarchyID datatype, or...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 16, 2012 at 8:01 am
Viewing 15 posts - 136 through 150 (of 402 total)