Hi,

I appreciate your response. I need little more info if I add some more records in B like

INSERT INTO #B VALUES (4,'E2')

INSERT INTO #B VALUES (5,'E2')

then the output...

Hi,

it started working when i connect with another machine which is having 2008. Not sure what was the problem with the previous machine which was having 2012. Need...

To create tables

CREATE TABLE [dbo].[LookupSource](

[id] [int] NULL,

[value] [varchar](50) NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[Lookup](

[Id] [int] NULL,

[Value] [varchar](50) NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[LookupDestination](

[id] [int] NULL

) ON [PRIMARY]

GO

Insert statements

GO

INSERT [dbo].[Lookup] ([Id], [Value])...

Thanks Jeff...

your inputs are highly contributing to our decision makings in partitions...

Thanks and Regards,

Ami

Hi Jeff,

I'm sorry for a delayed reply. Thanks for your help. Below are my answers.

1. Is any of that data ever updated once it's been inserted into the...

Hi Jeff,

Thanks for you reply.

i'll explain the scenario, so that we can decide on whether we need partition or not.

1. It is a datawarehouse system and we have 500+...

i've done something like this,

create table #tbl ( V1 int, V2 datetime, V3 float)

insert into #tbl values (1,'2012-12-12 10:15', 12.5)

insert into #tbl values (1,'2012-12-12 10:30', 2.5)

insert into #tbl values (1,'2012-12-12...

I'm trying like something below

create table #tbl ( V1 int, V2 datetime, V3 float)

insert into #tbl values (1,'2012-12-12 10:15', 12.5)

insert into #tbl values (1,'2012-12-12 10:30', 2.5)

insert into #tbl values (1,'2012-12-12...

It is misprint, it is 10:30 only...

i'm trying to work out the solution given by

Koen Verbeeck - but finding some difficulties in formatting the same into time intervals... and...

If the timestamp is available for next 15 minute then group it....

we have it for 10:15, 10:30 and 10:45

Next timestamp is on 11:15 and not 11:00 so falls under next...

it is V2. It is a timestamp.

and i want to aggregate on V3.

Great help, Thanks,

Regards,

Ami

declare @t table (v1 int , v int, v2 datetime)

insert into @t values(4,10, '2014-01-01 10:00:00')

insert into @t values(5, 20,'2014-01-01 10:05:00')

insert into @t values(6, null, '2014-01-01 10:10:00')

insert into @t values(7, null,'2014-01-01...

Many Thanks,

it works, one more question,

The same way, I would like to bring the date column also. The expected output is, if the value of 'v' is null then...

surely NO. 🙂

if you've written or read and felt something is more valuable.... thought of getting it...

Thanks a lot for your reply. I'll google it...

Thanks,

Regards,

Viji