How about this?

Function code:

IF OBJECT_ID (N'dbo.GetEloquaColumn', N'IF') IS NOT NULL

DROP FUNCTION dbo.GetEloquaColumn;

GO

CREATE FUNCTION [dbo].[GetEloquaColumn]

(

@Code_String NVARCHAR(200)

)

RETURNS TABLE

AS

RETURN

(

SELECT STUFF (Eloqua_Field_reference,1,1,'') Eloqua_Field_reference

FROM

(...

Sathish, without seeing your data, we can't debug the Function.. so can u cook up some sample data out of your original data and post it in the form of...

Even i have seen that behaviour.. GROUP BY beats ROW_NUMBER by comfortable margin when it is run over large dataset.. if you could provide samples of your environment, it would...

Try this:

Tweaked with the idea from Mark:

; with cte0 as

(

SELECT name,cost , saledate

,Quarter_Num = DATEPART(Q ,[saledate] )

...

OOooch :pinch:, Mark beat me to it..

one variation between Mark and mine, i used DATENAME for the Month, he used DATEPART.. both do the same, infact, mark's is good one,...

Hmmm.. try this:

; with cte as

(

SELECT name,cost , saledate ,

Quarter_Num = DATEPART(M ,[saledate] )

,Month_Name ...

Syed Khalid, tel me, honestly, it is an interview question or home-work question , isn't it?

😀 Lol,Bob

Exactly, tat is the alias for the sub-query present...

Ah , never CM.. i always enjoy reading through your innovative ideas of solving questions, makes me learn a lot.. i enjoy...

Try this: (This is what ashish was mentioning)

Declare @UserSelection INT

SET @UserSelection = 58

select * from

(

select 1 ,0.00 ,20.00, 7.90

union all select 2, 21.00, 60.00 ,10.70

union all...

Craig Farrell (9/21/2010)

---

I did explode mine out to make sure it covered an entire day rather then just the specific points in his exact result set. I made the...

Craig and Vekatraman, With all due respect to your wonderful attempts, both of your queries are not what the OP is expecting..

Try this:

DECLARE @Tab TABLE

(

Number BIGINT,

Time_Stamp DATETIME

)

INSERT INTO @Tab

...

Glad we could help! 🙂

Thanks for the feedback, Lee