Guys,

Found this site , it has all the answers to my queries and much more.

http://www.epochconverter.com/

I know we can do it via SQL Command option , but is there a way where in all tables of all the database can be shown under the dropdown...

Please post some details of code or snapshots of how you set or use that variable...

See this if helps

http://www.databasejournal.com/features/mssql/article.php/3325701/Import-multiple-Files-to-SQL-Server-using-T-SQL.htm

Brandie , you can specify the no of rows you want it to scan.

Theres a option called Suggest Types under file connection which will scan the records of your file and suggest a datatype , that is really useful , y ou could...

Not clear what your result is based on, some group by ? , plz explain.

Just an update , created non clustered index on column SessionId in both the tables, i am getting results in about 1.5 minutes now.

Thats bcoz , the text i m finding can be anywhere in the value.

There are no indexes on any of the tables used in the query.

Since its being populated from...

Hi Guys ,

I changed the query as per scott's reply in below query.

It is taking too long to execute , I somewhere read that there are issues with Sql server...

Scott, this is really simple , thanks a ton !!...

Yes, Indexing is a good point , i will check on that. Also I have identified that since this is all static data , it can be pre calculated...

CREATE TABLE #CASE_DATA(CASE_ID INT,[USER_ID] INT,BEGIN_DATE DATETIME,END_DATE DATETIME)

INSERT INTO #CASE_DATA_ID VALUES (1295222,1716,'2012-04-19 13:10:00.000','2012-04-19 13:12:00.000')

INSERT INTO #CASE_DATA_ID VALUES (1295222,1716,'2012-04-19 13:10:00.000','2012-04-19 13:12:00.000')

INSERT INTO #CASE_DATA_ID VALUES (1295222,1716,'2012-04-19 13:10:00.000','2012-04-19 13:12:00.000')

INSERT INTO #CASE_DATA_ID VALUES (1295222,1716,'2012-04-19 13:12:00.000','2012-04-19...