This is commonly seen in Excel even in SQL 2000 due to how it samples the incoming data to determine the field type. I have had to go as far...

Look at the function stuff and to put in the / in the correct places then try convert/cast.

Know the feeling, like exFat, they still haven't cancelled the beta and it has been on my beta space for over a year. 😀

But...

Steve do you ever get involved with the betas?

That still depends on the size of the largest transaction.

PGarberick (11/15/2007)

---

Please don't get me started on LiveSearch. My kid was doing the club and they called me downstairs. Despite the fact that we had the Safe Search...

I am not totally sure they are not innovating, the problem is getting recognized for you innovation in a market to keep share. It is like with iPhone, people are...

Do you do a lot of large data imports as well? You might want to change the database to simple recover to limit this issue whil in developement especially since...

My statement is think of everything after the from as developing a set of data from the table you are deleteing from. If you do SELECT TableName.* instead you see...

This might help

http://www.faqfront.com/document/sql-server-session-state

but when I last did this for testing I just searched on google for

"asp session state sql"

and

"asp session state sql custom database"

and you can of course narrow to...

Sorry was using @x declared as int, seems to cause an issue when not int so if you use this with HEX in @x pos

SELECT

(0x1F & @x) / 0x01 a,

(0x03FFE0...

Sorry found I typoed my positions as I started with 4 and not 5 as the first set so here is the correction. @x represents your HEX value.

SELECT

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(@x),28,5)) a,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(@x),15,13))...

Hey I...

I am split on this because of a gig I am working right now outside of my fulltime employement. The software and database eliments they want I can readily see...