i think it has nothing to do with SQL, but rather the ACE drivers that are used to access via Excel;

the ACE driver does the peek at the first 100...

the OP's data as sample data:

i got that far, but my eyes blurred on the expectations:

With MySampleData (Date, Name, ID, Result )

AS

(

SELECT CONVERT(datetime,'3/18/2013') ,'A',1,5 UNION ALL

SELECT '3/18/2013','B',2,16 UNION...

look your command over again, it's got multiple places where other dual-single quotes exist.

try this line instead:

SET @sql ='bcp DatabaseName.[dbo].ABt_file_load_2012 in "' + @IncomingPath + @FileName + '" -c...

oops sorry: it's from an article i posted here:

sp_GetDDL_Latest.txt (scripts any object, returns varchar(max)

sp_GetDDLa_Latest.txt (scripts any object, returns multi row recordset)

the issue is subtle: you need to use dbl quotes, and not two single quotes, to identify teh field and row delimiters:

Declare @sql varchar(8000),@IncomingPath varchar(500),@FileName varchar(500)

set @FileName='12272012_114537_AB123.txt'

set...

Manie you script looks pretty good without testing it myself;

Here's a something similar I built for some unknown forum post here; the basic differences are i'm also capturing changes to...

how does the data actually come? is it a real csv file, and not an excel doc?

I've imported millions of rows via bulk insert or SSIS with delimited files,...

Yes, but that trace only captures changes realted to DDL operations, ie CREATE TABLE/ALTER TABLE etc.

B. Is it possible to capture all...

weird, i haven't seen that issue before specifically; you clearly have dba rights to take it offline and online, so that's not the issue, especially since it's available afterwards.

I have...

take a look at the script contributions on the site:

the second link from this results explicitly says jobs for SQL 2000/05/08,

http://www.sqlservercentral.com/search/?q=script+jobs&t=s

I think another search for the other items you...

ok great!

the trick here is you really need two queries, adn compare them agaisnt each otehr;

you already have the cheapest supplier, but now you wnat to know which regular supplier...

jralston88 (3/14/2013)

---

Lowell,

Thanks for responding. I should have clarified that in my posting - the email account has the full domain. And the mapping you mentioned was done. ...

r-276086 (3/14/2013)

---

Hi I have the following table (created from a view):

BaseSupplierID__SupplierID___ProductID__Price

3_______________3___________1________11

3_______________4___________1________11

3_______________5___________1________15

3_______________6___________1________10

4_______________3___________2________16

4_______________4___________2________10

5_______________5___________3________16

5_______________8___________3________14

5_______________9___________3________10

Basically each product can be supplied from multiple supplies yet there is a base supplier (which in theory should be...

now that you have...

some context is missing; what project are...