Hello,

To Sergiy:

You are right. The first what I did was an analyze and developed diagram. Then I decided that I have to check every date from input range if it is between datod AND datdo.

May be I described my problem wrong. What I needed was join "utvar" from #T1 with every date from #T2. Table #T2 is created by input date range.

I have source data #T1:

cislo datod datdo utvar

37792002-04-01 00:00:002002-11-30 00:00:007003

37792002-12-01 00:00:002003-04-30 00:00:008007

37792003-05-01 00:00:002008-10-28 08:17:007003

Input date range:

@DatumOd='20030420'

@DatumDo='20030512'

Source data #T2:

cislo datum kodds hodin

37792003-04-23 00:00:00100495

37792003-04-24 00:00:00100450

37792003-04-25 00:00:00100585

37792003-04-28 00:00:00100495

37792003-04-29 00:00:00100495

37792003-04-30 00:00:00100450

37792003-05-02 00:00:00100450

37792003-05-05 00:00:00100435

37792003-05-06 00:00:00100495

37792003-05-07 00:00:00100495

37792003-05-09 00:00:00100435

37792003-05-12 00:00:00100495

This is result what I need:

cislo datum kodds hodin utvar

37792003-04-23 00:00:001004958007

37792003-04-24 00:00:001004508007

37792003-04-25 00:00:001005858007

37792003-04-28 00:00:001004958007

37792003-04-29 00:00:001004958007

37792003-04-30 00:00:001004508007

37792003-05-02 00:00:001004507003

37792003-05-05 00:00:001004357003

37792003-05-06 00:00:001004957003

37792003-05-07 00:00:001004957003

37792003-05-09 00:00:001004357003

37792003-05-12 00:00:001004957003

I used storedprocedure and "utvar" I got from:

SET @utvar2=(select utvar from #T1 where cislo=@cislo1 AND (@datum between datod and datdo))

On finally it looks very simply 🙂 .

Thank you for your help and advice