Viewing 15 posts - 2,101 through 2,115 (of 5,504 total)
allmhuran (1/15/2011)
That's a good idea and one I had only vaguely considered. I'm not sure how I would approach them though. Guess I'll give them a call 🙂
At least regarding...
January 15, 2011 at 8:43 am
@allmhuran:
I disagree with your statement "-- alphabetic months are always safe."
Alphabetic months depend on the language setting. Therefore, I won't consider this format as being safe by any means.
Simply run...
January 15, 2011 at 8:40 am
To include your Holiday table, you could use
UNION ALL
SELECT CAST(HolidayDate AS DATETIME),CAST(HolidayDate AS DATETIME)+1
FROM @Holiday
...
January 15, 2011 at 3:01 am
The sample data can be found here (it's the Edit: 11th post of this thread).
Regarding the MG_LOCATION: not only there is more than one value for MED. It's also not...
January 15, 2011 at 2:46 am
Jeff Moden (1/14/2011)
...
I was getting a bazillion PM's asking for private help. I got tired of replying "Please post it on the forum" so I just let my PM...
January 15, 2011 at 2:35 am
It seems like there is a known issue when trying to get the attributes out of the outer most node.
In this blog in a comment they mention "Your best bet...
January 14, 2011 at 4:53 pm
CirquedeSQLeil (1/14/2011)
...Hmmm. I can't clear anything out either.
You could drop me a PM with an alternative e-mail if you'd like to...
January 14, 2011 at 3:10 pm
Jeff Moden (1/13/2011)
LutzM (1/13/2011)
Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.
I don't suppose there's a chance of doing it...
January 14, 2011 at 2:15 pm
I would use a slightly different approach:
Store the xml data in table with a xml data type column.
Add an xml index.
Shred the data using XQuery instead of OpenXML.
To get an...
January 14, 2011 at 8:14 am
You might want to have a look at the TallyTable article referenced in my signature. There's an example with a detailed description.
Based on that, follow the link in my signature...
January 14, 2011 at 7:54 am
Ray K (1/14/2011)
Jeff Moden (1/13/2011)
January 14, 2011 at 7:49 am
Please have a look at the CrossTab article referenced in my signature.
I'm sure this concept will help to resolve the issue.
January 14, 2011 at 5:19 am
rsanuj (1/14/2011)
thanks for reply.but in this case week column in result not fixed.
In this case the CrossTab articles Wayne pointed you at will help you to resolve the...
January 14, 2011 at 12:24 am
From my point of view we have a few options for the base table design:
a) using Joe's table design
In this case you could easily end up with inconsistent data like...
January 13, 2011 at 4:55 pm
Viewing 15 posts - 2,101 through 2,115 (of 5,504 total)