Viewing 15 posts - 106 through 120 (of 789 total)
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
March 30, 2010 at 8:03 am
Jeff Moden (3/30/2010)
There are two reasons. First, anything larger than 23:59:59.997 will round up to the next day. Second, with...
March 30, 2010 at 7:07 am
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...
March 30, 2010 at 6:38 am
gaurav-404321 (3/30/2010)
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...
March 30, 2010 at 6:07 am
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.
March 21, 2010 at 3:43 pm
Steve I think that you can add also the CU 7 for SQL Server 2008 in the list! 😎
March 20, 2010 at 5:13 pm
Hello from Kosova - the newest state in the World ... http://www.kosovothanksyou.com
March 12, 2010 at 5:31 am
Yep what to say try nvarchar(1000) ! I think this is enough characters number that can be one URL.
March 4, 2010 at 2:25 pm
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...
March 4, 2010 at 11:29 am
MAK-1128556 (2/24/2010)
you should assign as db_owner of that database
Hmmm I think this is not a solution!!!!!!! :hehe::w00t::-P:-D:-):-P;-):w00t::cool::hehe:
February 24, 2010 at 3:12 pm
You are welcome! Comeback again in the forum and you will find much more than your problems ....!
February 24, 2010 at 12:58 pm
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...
February 24, 2010 at 11:37 am
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...
February 24, 2010 at 11:13 am
Yes interesting question ...any reason for the scenario...!?
February 24, 2010 at 10:47 am
Viewing 15 posts - 106 through 120 (of 789 total)