The error is telling you everything you need to know.

Look for an unusual large string literal and define where you should add a...

You could change your nested query like this:

( select TOP 1

cast(f.valuestr as float) min_valuestr,

f.valuetime

from bvfindings f

where f.ObjectName = 'Hematocrit'

and f.sessionid = s.sessionid

and f.ValueTime > s.open_time

ORDER BY min_valuestr)

However, you...

Jeff Moden (7/16/2015)

---

I still want to know what someone considers to be a month. DATEDIFF(mm,'20150630','20150701') will say that a month has passed when only 1 day will have passed....

Ok, so you want to change the whole streak and I only changed the month. This code will update the data correctly.

WITH CTE AS(

select * ,

...

Antares686 (7/16/2015)

---

Recheck the logic, the Type cannot be both 4 and 3, which means 1,1,1 , 1,1,0 and 0,1,1 cannot occur. Which is why I bring it up to see...

Basically, what Sean said.

There's no option included in SSMS because most people won't delete rows older that a certain amount of time. There's also no standard on defining the date...

I'll just copy your SQL Fiddle code in here to make it clear for anyone that might have the same issue or want to add a comment.

CREATE TABLE [dbo].[SourceData](

...

Is this where you write "Thanks for the question"? 😀

Thanks for the question :hehe:

To change this into a procedure, read the CREATE PROCEDURE entry from BOL (Books OnLine).

To create the file, read about the bcp utility.

You could also create the file by using...

Chris Wooding (7/14/2015)

---

Antares686 (7/13/2015)

---

Kutang Pan (7/10/2015)

---

Is there any other way to write the below query:

SELECT

SUM(CASE WHEN Type = 4 AND STATUS IN (1, 2, 3) THEN Value ELSE...

Wow, now they're asking how to code the examples from BOL. :hehe:

That seems very similar to the example in BOL for Specifying XPath-like column names

You could even google the query and you'd get the references. 😀

I'm not sure about what you're doing and I can't test it right now because I don't have SSMS installed in here. However, I'm wondering if you only use 1's...

You actually would need to divide your query as you're trying to create a relation between rows that are not related.

WITH AValues AS(

select a.id,

a.data,

ROW_NUMBER() OVER(ORDER BY a.id) AS rn

from a...

KGJ-Dev (7/15/2015)

---

Hi Gail,

When i see the table structure and question, i am also confused with the same questions. i still didn't get authorization to see the data. I...