I've had similar experiences with Excel. SQL Server doesn't always like the dates used by Excel. My solution has been to import the Excel spreadsheet into a staging...

Before you completely quit...try one more thing. Run a trace. Maybe that will show you what is really happening. Since this is so weird, make sure you capture...

It's possible the GUID tablenames was done for 'security' reasons. No interloper would know what the table was for based on the name....still doesn't make it right, but that...

We really need to see the query you are using to create the results you are getting. You could be using a join wrong, or the wrong type of...

Sean Lange (4/5/2016)

Luis Cazares (4/5/2016)

I constantly avoid that person's threads....

It looks like you are using the wrong syntax for ANSI_PADDING. I believe it should be On or Off...not True or False.

-SQLBill

No need to feel stupid...sometimes we all overlook the obvious.

-SQLBill

I wonder if Microsoft is going the way of Windows 10 with SS2014. Instead of releasing major updates (Service Packs), just releasing CUs as they come available.

-SQLBill

Are you only refreshing data? Or do you need to update the schema also? If you only need the data, you could use BCP to bring the data...

I believe you are going about it wrong. Your comparison needs to be in a WHERE clause:

SELECT [time]

FROM Table1

WHERE CAST([time] AS time) > (CAST('16:00' AS TIME))

GO

Now I haven't...

Bottom line...no. DBO schema is the 'everyone' schema. Mylogin schema is owned by Mylogin (so the sqlbill schema is owned by me). For anyone else to accessw mylogin...

Andrew Bagley (2/26/2016)

I have another thought about my "invisible data" problem..

My DB had to be restored about 10 years ago and I found that objects created were no longer dbo....

You should also be able to use ISNUMERIC to see what data is not numeric and therefore can't be converted.

-SQLBill

As for the inserting of data....is there a trigger on the table that might be keeping you from inserting more than one row at a time?

-SQLBill

The data exists in the SQL Server database since you can query it okay. Is that correct?

If so, then the issue isn't with inserting the data. It's there, it's...