opc.three (3/30/2012)

---

DBA_Dom (3/30/2012)

---

One other advantage I have seen with having a clustered index on a specific column and then also have an non clustered index on the same column is...

We are grouping values that are written in a sequence of 1 minute, for this values we are show start datetime of a sequence and end datetime of sequence. For...

Ok. here it the script to populate data:

create table #t (IMEI int, Date datetime)

insert into #t

select

3, '20091210 11:49:09.000'

union select

3, '20091210 14:30:08.000'

union select

3, '20091210 14:31:07.000'

union select

3, '20091210...

Thanks a lot! Will check links shortly!

stevefromOZ (9/9/2009)

---

I would probably use an Expression on the variable and pre-pend the full path to it. Alternatively, you could use a second variable to hold the path and...

Hel (9/9/2009)

---

Hello Steve,

I'm trying to use your sample and got the following error:

Error: 0x3 at Foreach Loop Container: Variable "User::adoVar" does not contain a valid data object

Warning: 0x80019002 at Foreach...

Hello Steve,

I'm trying to use your sample and got the following error:

Error: 0x3 at Foreach Loop Container: Variable "User::adoVar" does not contain a valid data object

Warning: 0x80019002 at Foreach Loop...