meadow0 (3/5/2013)

---

Hi Guys,

I'll basically do my best to describe what I'm trying to accomplish, and give you the query I have so far (which isn't correct).

I have several different...

ScottPletcher (3/5/2013)

---

I also stated that (12 * 1900) was acceptable to me -- it's essentially self-commenting. The best of both worlds to me. But he stated that would...

Sounds like an extremely odd requirement, so I doubt we're getting the whole picture. I'd suggest that you think about what Chris stated.

Anyway, I guess that something like this would...

winmansoft (3/3/2013)

---

I have to get min date from top 100 rows which satisfies date condition..If i do

select top 1 [date] from WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013' order...

Guessed the mind of the creator of the question correctly, so got it right. However, I think there is some ambiguity in how the question is phrased so it should...

Steve JP (2/28/2013)

---

Throwing the 2 versions of the code through a test rig shows that the methods are reasonable similar on speed. Its how the methods get used is...

geert.de.vylder (3/1/2013)

---

Hi Cadavre,

Thank you for your help and assistance.

Can you explain me what happens per step. I ask this because the result does not group the columns per interval and...

I had to...

I might have over-complicated this, I feel like I have but haven't really got the time to dig into it any further.

Using the following sample data: -

IF object_id('tempdb..#testEnvironment') IS NOT...

RZ52 (2/28/2013)

---

Dear Dadavre,

The proposed solution works good. However, we need also to distinguish those samples that are positive but no O15? factor was detected and tag them as "Non-pathogen" (in...

RZ52 (2/28/2013)

---

Hi,

I am working on a project where the resistance to some antibiotics is studied. We have a database of patients checked for resistance. The result of test for each...

I think that what you're saying is that you entered characters like this on your web interface -- "????" (forgive me if that means something, I was hoping for gibberish...

spencer_robinson (2/28/2013)

---

HI All

I need some pointers/help in getting this done

I have some data sample below each row has two week numbers yyyyww 201301 or 201352. I need to build a...

Hello and welcome to SSC,

If you could knock up some sample data and DDL scripts, then your expected results based on the sample data provided that would be extremely useful...

I do disagree, we have deadlock retry logic on our product. The...