saurabh.dwivedy (5/8/2009)

---

Ramesh (5/4/2009)

---

Most of the time cursors/loops performs poorly than set based methods with only some rare cases when loops performs better than a set-based approach.

In your case, one go...

Too much caffeinated today:hehe:

DECLARE @FromDate DATETIME, @ToDate DATETIME

DECLARE @FromDateConverted INT, @ToDateConverted INT

SELECT @FromDate = '2009-04-09',

@ToDate = '2009-04-10',

...

Never mind the newbies...:-D

DECLARE @FromDate DATETIME, @ToDate DATETIME

DECLARE @FromDateConverted INT, @ToDateConverted INT

SELECT @FromDate = '2009-04-09',

@ToDate = '2009-04-10',

...

Madhivanan (5/8/2009)

---

Ramesh (5/8/2009)

---

It can also be done using sp_executesql system procedure

declare @DateTime DATETIME

declare @tablename varchar(100)

declare @sql nvarchar(4000)

create table #temp (starttime datetime)

-- Using sp_executesql

set @sql = 'select @DateTime = min(starttime) from...

It can also be done using sp_executesql system procedure

declare @DateTime DATETIME

declare @tablename varchar(100)

declare @sql nvarchar(4000)

create table #temp (starttime datetime)

-- Using sp_executesql

set @sql = 'select @DateTime = min(starttime) from ' +...

Good...

Thanks Flo for the script:-)

So here is the solution same as Flo's solution except that considers UNIX-EPOCH date formats.

DECLARE @t TABLE( sl_no INT, Initial_date INT, Log_Time INT, Description VARCHAR(100) )...

Something like this should work:

declare @DateTime datetime

declare @tablename varchar(100)

declare @sql varchar(8000)

declare @temp table(starttime datetime)

set @tablename = 'perf270409'

set @sql = 'select min(starttime) from ' + @tablename

insert @temp(starttime)

exec(@sql)

select @DateTime = starttime...

ansharma (5/8/2009)

---

Hi Ramesh

This should be the output (Please note that teh data is stored in UNIX format i.e int data type :

sl_noinitial_datelog_timedescription

2454/9/2009 13:00 ...

You still didn't answered my question?

Edit:

I have the solution but it depends on what you answer to my question.

Its not the experience or the performance factor that decides the usage of data types but the business factors decides. If the business rule requires support for UNICODE (i.e....

Jeff Moden (5/4/2009)

---

Not a bad recommendation... I just do it all from T-SQL. I hope to...

You just have to use the wild card characters, for e.g. to get all text files that begins with "ord" set the path value to "C:\ord*.txt"

What would be the expected output for the following data?

401 4/10/2009 23:00 4/10/2009 23:07 This should return null value

401 4/10/2009 23:00 4/10/2009 23:09 This is a description

In case if you're inserting multiple rows then you may want to have a look at the OUTPUT Clause in Books Online

DECLARE @T1Id INT

CREATE TABLE T1

(

Id INT...

Look up Books Online for Ranking Functions