Viewing 15 posts - 1 through 15 (of 22 total)
Sorry I couldn't get this to work with CTE's holding the consumable data but here is a really close arrangement of the data in hierarchical form needed to bind to...
May 28, 2013 at 11:39 am
Well first using the CTE for temp table to provide consumable data was a cool new thing I had never thought to use a cte for before.
The data portion...
May 24, 2013 at 10:19 am
So for the foreseeable future we will only need two level. Parent Child so the tree would look like this:
FoodGroupA
----Food A
----Food B
FoodGroupB
----Food G
----Food K
FoodGroupC
----Food A
----Food K
Notice A & K belong...
May 24, 2013 at 9:28 am
Two questions.
1st what did I fail to provide in terms of "consumable data" that Geoff put together. The actual query? The reason I ask is as the OP I...
May 24, 2013 at 9:06 am
That's basically what I'm going to do. Just keep them as int in SQL and let .NET timespan do the heavy lifting.....I just thought Msoft...you know the guys who gave...
March 29, 2013 at 6:30 pm
Well I am trying to figure out how long it should take to do something. So say the instructor says I am giving you 5 minutes to find each hidden...
March 29, 2013 at 6:08 pm
Mr. Lange,
Sorry for the delay I was pulled off to another fire before coming back to this project. As for this question and answer I don't see where to mark...
November 26, 2012 at 11:09 am
OK so I have been off on another fire. Back to this one now. What I need to do is have a stored procedure that will take a date (12-12-2011...
December 27, 2011 at 5:05 am
craigB-921010,
I don't see where on this forum I can mark as closed nor give credit other than another post. It took awhile to roll through QA and prod cycles. The...
December 8, 2011 at 9:14 am
Well I've written triggers before but not for auditing. Typically just for business rules purposes. So my question is would I have a parameter available telling me stored procedure XYZ...
November 19, 2011 at 11:10 am
BOL??? Who needs that when you have Google? Thank You for pointing me in the right direction. Well so much for that idea. Only available SQL 2008 and this is...
November 18, 2011 at 4:32 pm
Agrred on the table but awaiting upgrade to 2008. Till the refactor and tune as best as I can. FWIW passing tables and merge statement in 2008 would take alot...
September 6, 2011 at 1:07 pm
Well my chief aim is really further down the road to get them migrated to XML and eventually table based parameters...in the meantime MOST of the times they pass in...
September 6, 2011 at 12:31 pm
I understand the context of this forum is SQL Server side but if you can use C# vb.net etc. to do the transformation then here is a great link to...
June 7, 2011 at 11:01 am
Somehow I started this thread on the wrong foot so my original question was obscure. In the past building hierarchical data I had to use temp tables and go through...
June 10, 2010 at 9:52 am
Viewing 15 posts - 1 through 15 (of 22 total)