Viewing 15 posts - 2,011 through 2,025 (of 5,504 total)
Here's one solution including a complete test setup:
You'd need to decide how to deal with timespans that end/begin exactly at the beginning/end of the previous/next timespan. Adjust the < to...
January 26, 2011 at 2:45 pm
TheSQLGuru (1/26/2011)
LutzM (1/26/2011)
Would it be possible to post the actual execution plan?
Also, would you please post the actual execution of a query...
January 26, 2011 at 2:28 pm
Changing the subject for a moment:
I also noticed a change in Joe Celkos replies. Here's a reply I have no problem with pointing others to if they're interested in knowing...
January 26, 2011 at 1:56 pm
@joe:
Thank you for the detailed explanation without the "overhead" that triggered some of us to complain about from time to time. This post is of the kind I would...
January 26, 2011 at 1:51 pm
It looks like you posted the estimated execution plan.
Would it be possible to post the actual execution plan?
Also, would you please post the actual execution of a query that performs...
January 26, 2011 at 10:04 am
Gianluca Sartori (1/26/2011)
...Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.
Why do you think there's a difference?
January 26, 2011 at 9:43 am
Please read and follow the advice given in the first link referenced in my signature.
Like I said in my previous post: the data you provided earlier don't match.
Example:
How do you...
January 26, 2011 at 9:18 am
I'm not sure if I'm missing the point here, but wouldn't it be easier to use an Excel-Macro for it?
It just makes me wonder why to use SSIS to convert...
January 25, 2011 at 4:08 pm
I noticed the major difference between the two user types is the additional query against tblYY. (ANDtblX.Div IN (SELECT FieldId FROM tblYY WHERE HRG='''+@EmpId+''') ).
Unfortunately, it seems like all...
January 25, 2011 at 3:45 pm
GSquared (1/25/2011)
...
A person in a high emotional tone will respond faster than a person in a low one.
...
That's interesting!
I'm actually known to reply almost instantly to such questions. Most of...
January 25, 2011 at 2:46 pm
Dave Ballantyne (1/25/2011)
Any volunteers to read through a draft of an article for me ?Thanks....
Sure, if I can be of any help...
January 25, 2011 at 2:37 pm
If you need to separate the string based on a specific set of character (e.g. '_I_') you should look into PATINDEX and '% I %' instead of CHARINDEX...
January 25, 2011 at 2:18 pm
Copy code snippets for internal reuse (with or without modification) is absolutely fine with me (I usually add the web page where I found it). Otherwise I still wouldn't use...
January 25, 2011 at 2:10 pm
Craig Farrell (1/25/2011)
GSquared (1/25/2011)
And that's almost certainly more than anyone here wants to know about this subject. :w00t:... listens enraptured. "Not really, that's damnably interesting, actually."
Agreed. Keep on!
To answer...
January 25, 2011 at 1:53 pm
Viewing 15 posts - 2,011 through 2,025 (of 5,504 total)