Database

;with cte as
(
select person,name,sum(value) as total from @tbl group by person,name
)

select person,'others' as name , SUM(total) as total from cte where name not in('a') 
group by person
union all
select person,'a' as name , SUM(total) as total from cte where name in('a') 
group by person
 order by person desc

BULK INSERT dbo.TBL_CMPS FROM 'C:\UNISA_IMPORT\Final_Import\Campuses.csv'  WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ); 

I are Troll

Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "C:\UNISA_IMPORT\Final_Import\Campuses.csv" could not be opened. Operating system error code 3(The system cannot find the path specified.).

Operating system error code 3(The system cannot find the path specified.)

BULK INSERT dbo.TBL_CMPS FROM 'C:\UNISA_IMPORT\Final_Import\Campuses.csv'  WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ); 

ulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (ID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 1 (ID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 1 (ID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 1 (ID).
Msg 4864, Level 16, State 1, Line 1
Bu

Vuyiswa Maseko wrote:

The Problem is that the SQL Server is in another Machine and am in my Developement Machine. So the Path is not in the Machine

Vuyiswa Maseko wrote:

How can i make the second Column as the First one. Because it tries to add records in the identity field and i get the Following Errors

The docs say:

Specifies the full path of a format file. A format file describes the data file that contains stored responses created by using the bcp utility on the same table or view. The format file should be used if:

* The data file contains greater or fewer columns than the table or view.

UPDATE TableName
  SET overtime = 40
WHERE emp_id = 5

UPDATE TableName
  SET overtime = overtime - 10
WHERE emp_id = 5