Add some ID with Identity (1,1) in two tables then write this SELECT TABLE1.CHARS, TABLE2.NUMBERS FROM TABLE1, TABLE2 WHERE TABLE1.ID = TABLE2.ID

Jeff Moden (3/30/2010)

---

Um... no, Dugi. Don't use the 23:59:59.999 thing.

There are two reasons. First, anything larger than 23:59:59.997 will round up to the next day. Second, with...

It would be better if you post the structure of your table and some test data then your desire results!

I'm sure that you will have many alternatives how to do...

gaurav-404321 (3/30/2010)

---

I am using datediff functionm to calculate the days span between two dates

SET @StartDate=cast('2010-01-26 00:00:00.000' as datetime)

SET @EndDate=cast('2010-02-25 00:00:00.000' as datetime)

SET @TotalDaysInSalaryPeriod= DATEDIFF(dd,@StartDate,@EndDate)

this is giving 30 as output.

But...

We know that it couldn't done with standard procedures to read XLS file with pass protected, but take a look this code and I hope it would help you.

Steve I think that you can add also the CU 7 for SQL Server 2008 in the list! 😎

Not bad! - I like it!

:hehe:

Hello from Kosova - the newest state in the World ... http://www.kosovothanksyou.com

Yep what to say try nvarchar(1000) ! I think this is enough characters number that can be one URL.

To have the correct results that you are looking for, post your table structure with sample data and the resultset that you want to achieve ...hope that we will help...

Hmmm I think this is not a solution!!!!!!! :hehe::w00t::-P:-D:-):-P;-):w00t::cool::hehe:

You are welcome! Comeback again in the forum and you will find much more than your problems ....!

I can see that you mentioned the SQL Server 2000...so here is the forum for SQL Server 2005!

Anyway, next time when you have a question about SQL Server 2000 you...

First of all SQL Server 2003 doesn't exists!

You can create Linked Server in SQL Server to Access file, when you create it you can see the tables and views in...

Yes interesting question ...any reason for the scenario...!?