There is some debate about the "best" way to represent the date. With MS SQL, probably best to go with ISO 8601 format:

yyyy-mm-ddThh:mm:ss

where "T" is the separator between the date...

It sounds like the date is not what you think it is! Try:

declare @mySmallDate smalldatetime

set @mySmallDate = '20030721'

select @mySmallDate

That should work just fine. If you try a date which is...

The ISO date format should work. Are you sure the date you are trying to assign is valid?

I think the saying goes, it takes one to know one....

Interesting to hear your views on Crystal Reports. I've not had much experience of Crystal directly; like you, I prefer to build the SQL queries in SSMS. Maybe someone else...

If you are just running "Command" in Crystal, maybe you could simplify your SQL query (or start with a straightforward SELECT and then build up to the final query) and...

Totally irrelevant coincidence, but I sold Kirby's for a (very) short time. Hated it. But, along the same line as Steve, I learnt a lot from the experience.

Like, I will...

If your permissions to the MS SQL Server are restricted, then Profiler probably won't be much use to you. Unfortunately, you need elevated rights (possibly even full System Admin, I...

I third that.... nice question, plus a concise but comprehensive explanation. Thanks.

Congratulations!!!

Independence Day is a great film, right up to the point when they use an Apple laptop to upload a virus into the mothership. Yea, right. Call me picky, but...

I...

You have a couple of choices. For some people, the easiest way to import data is to do a BCP (bulk copy) into a temporary table, and then copy the...

I couldn't find exactly what I was looking for (VB code for an SSIS project), but you may find that pure T-SQL will accomplish what you need. For example:

declare @myDate...

hehe, ok, apology graciously accepted (on behalf of all Forum users).

Can I point out that there are no Gods on this Forum? There are certainly some very experienced users, but...

Brad's question was "How scared should I be?". That depends on how much of a Worrier you are. There are definitely many completely untrained DBAs out there. There are also...