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)

The script on the link below produces a detailed analysis of the file size information for all databases on a SQL Server.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

Totals for the following are...

Update tbl1

set

address = tbl2.address

from

tbl1

join

tbl2

on tbl1.cuid = tbl2.cuid

Your code is more than likely for MySQL, not for SQL Server.

You would probably get better help posting you question o a forum where that answer MySQL question, like http://www.dbforums.com/