It's probably better to avoid using a reserved word, like INDEX, for a table name.

I think some of the more important reasons to maintain all the data in one database are transactional integrity and referential integrity. Doing a restore to a common, consistent...

Why not just call it a NUMBER table, since that's what it contains? Well, it's really integers, but INTEGER is a reserved word...

(Shameless plug for my own Number Table...

Both of these should work

... rest of query...

order by

ProviderNameLF

or

... rest of query...

order by

1

I am not sure I understand what you are asking for help with.

Are you asking for help with finding or resetting the SA password?

Are you asking for help with how...

lavani.sari (4/30/2008)

---

Thank You..I tried diff data sets but it did not fail..

I did a dbcc reindex on the table...and then it worked..pages were torn somewhere i guess..Incidentally we had a...

I think you will find that the following statement will fail on any SQL Server:

select dateadd(dd,-1,'17530101')

You will need to look at your data to find the rows it fails on.

This is probably the fastest method, because it uses only one date function call:

Select

MyDate = dateadd(month,(12*a.MyYear)-22801+a.MyMonth,a.MyDay-1)

from

(

--Test Data

Select MyYear = 2008, MyMonth = 12, MyDay = 31

) a

Results:

MyDate

-----------------------

2008-12-31 00:00:00.000

(1 row(s) affected)

Here...

I don't see how that view could return NULL. Do you really mean that it is not returning any rows?

You might want to look in detail at the content...

You should post Access questions on the Microsoft Access forum.

This forum is for questions about Microsoft SQL Server 2005.

You can use the function on the link below to create a date table for any range of dates you need.

You can either use it like a table in your...

Are you using SQL Server 2005?

FORMAT is not a valid SQL Server function.

People put the time and effort into things they think will be of value. If not that many people are getting it, then they must not think it is...

First, locate all the SQL Servers.

Then, look at each SQL Server to see what databases are on it.

This should do what you want:

select right(convert(bigint,convert(varbinary(16),newid())),10)