QA displayed grid or text. Was rows "randomly" lost or only the last few rows. Any funny tab,carriage returns, etc. in the columns? Which version of Excel.

Maybe try the same...

Have a look at BOL 2000:

SET ANSI_PADDING

Specially this one

http://www.mvps.org/vbnet/index.html?code/locale/gettimezonebias.htm

May help a bit.

http://support.microsoft.com/default.aspx?scid=kb;en-us;245786

http://www.vbcity.com/forums/topic.asp?tid=1881

http://www.mvps.org/vbnet/index.html?code/locale/gettimezonebias.htm

Interesting scenario.

What if the producer of the data is located in New York, the SQL Server in London and Consumer / Report Reader is located in Sydney.

The dates in the...

Appreciate all the inputs.

Select Not (AWGTHTGTTA)

You may need to have a look while the sub query is returning multiple records else someone is bound to run into the same problem again.

quote:

---

With that said, the idea of the code existing in a file and potentially outside of the control of the DBAs makes...

The datetimestarted seems to be of the DateTime type, nearest 3/1000 of a second, do you want one row per day/month/year

Replace datetimestarted with Convert(Char(11),datetimestarted,130) and see if...

Which one contains a subquery!

Can you post the statement

quote:

---

One option might be to make it a composite key, add a one/two char column that would be a set to a...

Jonathan, nice solution!

I just removed the STUFF part.

CREATE FUNCTION f_SplitInts(@List Varchar(8000), @Sep Char)

    RETURNS @t TABLE(Piece int) 

  ...

Have a look at BOL 2000: BINARY_CHECKSUM

quote:

---

Returns the binary checksum value computed over a row of a table or over a list...

Agrees with jpipes, we also use temp tables.

Do you Crystal Smart Viewer or VB, etc.