I agree with Sean, but I feel that that's not everything that you do on your cursor.

To prevent problems if someone messed up with the data on your table, I...

And I forgot to post the easy way to do it. :w00t:

SELECT CAST(GETDATE() AS datetime2(0));

This might work for you.

DECLARE @Today datetime = DATEADD( dd, DATEDIFF( dd, 0, GETDATE()), 0)

SELECT GETDATE(),

DATEADD( ms,

...

The operation varies depending on the data type you expect.

DECLARE @String varchar(4) = '20',

@String2 char(50) = '20',

@int int = 20;

SELECT RIGHT( '0000'...

I don't. I just validate that there are at least 3 dates within the range. This works if the dates aren't important and you just want to know the companies.

Here's a different approach.

WITH MinDates AS(

SELECT CompanyId,

DATEADD( dd, -15, MAX(ActivityDate)) MinDate

FROM ActivityTable

...

Isn't that what this...

This is like torture. I'm at the office, unable to watch the first games of the NFL season and can only see all the spam promoting supposed pages to watch...

baijuep (9/7/2014)

---

Sir, i tried the second query and it gives following error

Msg 8120, Level 16, State 1, Line 1

Column 'Trade.Trade' is invalid in the select list because it is not...

The problem is that when you insert the value into NEWCOLUMN, you're inserting NULLS and default values in the other columns to complete the row.

If you have a PK...

I don't understand your problem. What's PL, KM, KT? How do you define the first and the second row? There's no default order on SQL.

Your query seems inefficient. You could...

Eirikur Eiriksson (9/4/2014)

---

Luis Cazares (9/4/2014)

---

batgirl (9/4/2014)

---

Lynn Pettis (9/4/2014)

---

Yes, I actually threw one of Mr. Celko's own arguments back at him in a post talking about dates.

I liked the COBOL reference...

This solution is an alternative which might be better or might be worse. It can be complicated because each column requires 7 functions and it won't work with 5 columns....

You could do it in the same EXEC() statement. The problem is that you need to be sure that you're generating the same columns or you'll get an error.

Here's an...

I'm sure that it won't return what you expect.

You're ordering by the individual sales order detail and not the total of the month.

You shouldn't be using functions on the columns...