This?

select * , rn = ROW_NUMBER() over (order by ssn) + 1000

from person

How about this?

DECLARE @QueryDate DATETIME = '2012-07-01'

SELECT mpd.Product

, mpd.FridayDate

, mpd.MondayDate

FROM ...

Dwain, if you watch closely, those CROSS APPLYs are not on Tally tables;...

This?

DECLARE @Now DATETIME = DATEADD(DD, DATEDIFF(DD, 0 , GETDATE() ), 0)

SELECT C.Company

, C.StartDate

...

CLR Time 😀

Before we proceed, i am total newbie to CLR and C# and built this sitting this morning 😎

without further ado, here is the C# code:

using System;

using System.Data;

using System.Text;

using...

Can you elaborate on the problem? I am really...

SELECT *

FROM #Number

ORDER BY Num ASC

Just add teh ORDER BY clause..

Can you explain a bit further?

1. The format is of DATETIME2 and not DATETIME.

2. You have dots as the separator for the time component instead of colons. A valid date will look like : ...

Suresh B. (5/18/2012)

---

Prasad.N (5/18/2012)

---

hi all,

i have doubt regarding select statement, i have one table with 46 columns , i want select only 42 columns.but iam not like to write

select...

Do you know the names of the 4 columns that you wanna exclude?

You can use dynamic sql to do that, if you know the names of the columns u wanna...

What is the original requirement?

Yes, just replace CrsApp.Dt with dateadd(DD, -1 , dateadd(MM,...

Be careful while using @@DateFirst. It is affected by the Language setting of...

Try this:

declare @YearStart datetime = '01-Jan-2012'

; with numbers as

( select top 12 n = row_number() over(order by (select null))

from sys.columns

)

select LastDayOfEachMOnth = CrsApp.Dt

...