This is a method I have used before and heard of others using it with no draw backs. The only disadvantage is that youo have a DB query every page...

hmmm. Does ASP get advanced?

<%

Response.Cookies("Test") = "FFF" Sets it.

Response.Write "|" & Request.Cookies("Test") & "|" Gets it back

%>

Cheers,

Crispin

Easiest way: Set a cookie containing the time when the page finishes loading.

On the next page (or same one) attemp to retrieve the cookie and get the time. Start -...

http://www.w3schools.com Is good.

Cheers,

Crispin

I had the same problem. An easy way to overcome it was import the file into a temp table with a single column (Varchar(8000))

From there, you select out the data...

Here's an old thread where it's done.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11078&FORUM_ID=9&CAT_ID=1&Topic_Title=dead+links&Forum_Title=General

Cheers,

Crispin

You can use sp_OACreate to Instantiate the XMLHTTP (MSXML.HTTP).

You then use the Appropriate sp_OA procs to set the properties and methods.

BOL has plenty worth while examples.

Cheers,

Crispin

The reason you getting an overflow is SQL is "confused" by the date.

You have 03/31/2003. SQL is trying to convert 03 to the day, 31 to the month. There are...

You can use:

select *

from table

where Billeddate between dbo.ConvertDate('01/01/03') and dbo.ConvertDate('03/31/03')

Two problems I can see here.

1) Your years are two digits. You'll have to make a change to the...

Use this function.

CREATE FUNCTION dbo.ConvertDate

(

@DateVarchar(10)

)

RETURNS Varchar(100) AS

BEGIN

Declare

@vDayChar(2),

@vMonth Char(2),

@vYearChar(40),

@vMonthNameVarchar(100),

@vResult Varchar(100)

/*

If ISDATE(@Date) = 0

Begin

Select @vResult = '10 Jan 1900'

Return @vResult

End

*/

Select @vDay = Substring(@Date, 1, 2)

Select @vMonth...

Atleast SQL Optimiser won't have to look long and hard for an index.

Sorry, had to throw in my ten cents worth...

Cheers,

Crispin

Pesrsists have a component that does a binary read / write.

This pulls the data from SQL and sends it to the browser. The browser thinks it's a file and prompts...

I have had gains from creating Non-Clustered index on temp tables. When I tried a Clustered, it became slower. I guess it's because of shifting the data.

Create a Index and...

If you talking about a proc querying two servers, yes. I would lie to you if I told you how etc. Linked servers is not my strong point. There will...

Have a look at sp_OACreate in BOL.

You can do anything with COM and sp_OACreate.

Cheers,

Crispin