[font="Verdana"]I don't see many people (other than Jeff,...

[font="Verdana"]Doing a full outer join was a nightmare (union of left and right outer joins) and doing a full cartesian product, er, cross join, was far too easy. The...

[font="Verdana"]I guess I see it as "value to the business". Yes, there is (I agree) a paradigm shift in how you program between PL/SQL and T-SQL. And yes,...

[font="Verdana"]My suggestion would be that after you load a file, zip it. Then you can easily determine which files you have already loaded (and the loaded files take less...

[font="Verdana"]You can try casting to datetime, then using datediff() to calculate the number of seconds.[/font]

[font="Verdana"]I would have expected that to work! Is it still failing on the same number? ('2908H')[/font]

[font="Verdana"]In another thread, Jeff Moden reminded me that numbers of the form '1d3' and '1e3' are legitimate.

A quick example:

select isnumeric('1d4'), isnumeric('1e4')

select cast('1d4' as int)

select cast('1e4' as int)

So I suspect you...

[font="Verdana"]Whoa!

Those look like timezone dependent dates (I'm guessing the -8.00 on the end of one is GMT - 8 hours.)

You will need to use some sort of case statement and...

James (2/16/2009)

---

So does it mean that it has no alternative solution for this kind of situation? Because no matter how I defend the matter of upgrading express to standard edition,...

[font="Verdana"]Please tell me you are not designing a high volume data solution using SQL Server Express? I believe there's a limitation on the size of database it supports, for...

smunson (2/15/2009)

---

Bruce, you've described to a tee what I had in mind when I said "failure to think" .... nailed it, scored a 10, etc., etc., ... ...

[font="Verdana"]Okay, now I have to agree with you....

Jeff Moden (2/15/2009)

---

Not even close... in no way is Oracle even close to SQL Server or vice versa. Let's start with the basics, like returning a result set to...

[font="Verdana"]CTE: Common Table Expression. Introduced in SQL Server 2005. Well worthwhile learnng! They make complicated SQL statements so much clearer.[/font]

[font="Verdana"]...go program in lisp then. looks disgusted :P[/font]