No, it's not a typo.

Strings in the post are not actual ones, of course.

In actual thing I just used Copy-Paste, so strings were identical.

3rd cilumn does not matter.

I changed the...

There are probably three ways.

Keyword "AS" in you second way is optional.

Should it be named "second way of second way"?

"dt_" objects (not only procedure, tables as well) are used by Enterprise Manager.

They being created when you first time use it on the server.

> because the implicit format is understood to be mm.dd.yyyy.

On your server.

Allen,

as I can understand your workTable contains expense records: 1 record per item gone from the stock.

There must be another table holding same information about income.

There must be some...

Rich,

Spend some time learning how to code triggers.

Triggers are not part of your application, they are part of an table or view. They will executed even when you do update...

Happy to help.

And BULK INSERT will work with the same format file as good as bcp.

There is in fact cross-join between D1 and D2.

I believe they both contain almost complete list of students, so matching criteria are not effective. Criteria like "" cannot use index,...

For Mac - see my 1st post.

For reversal conversion - take some programming lessons.

Anybody who can program and has been given with forward transition can build backward one. It's one...

Oh, Jeff, where you lead him?

What he's done to you?

DECLARE @IPAddress VARCHAR(15)

SET @IPAddress = '5.152.61.94'

select @IPAddress,

CONVERT(int,

CONVERT(binary(1), convert(tinyint,...

> So for some reason although the application shows the dates as 1st to 31st May,

VB6 has 2 days offset when converting floats to dates.

Zero date in VB6...

SELECT ID -- integer identity field

FROM dbo.IP_Adresses

WHERE IP_Address = @IP_Address

SELECT StartDATE, EndDATE,

CONVERT(datetime, StartDATE) dtStartDate,

CONVERT(datetime, EndDATE) dtEndDATE,

(DATEDIFF(dd, CONVERT(datetime, StartDATE), CONVERT(datetime, EndDATE)) + 1)

-(DATEDIFF(wk, CONVERT(datetime, StartDATE), CONVERT(datetime, EndDATE)) * 2)

-(CASE WHEN...

Dizzy,

Cant you include explicit conversion to datetime in this test?

And display converted dates in line with other values?

Why don't just type the format file in Notepad?

BOL describes it quite explicitly, and your file should not be too complex.