Database

solarthur01 wrote:

Does anyone know hot to import data from a spreadsheet into sql server table.

AlexeiXX3 wrote:

Does anyone know how to get child rows of a row as a string?

/* create tables for examples */<br />
create table student (StudentID int, Name varchar(50))<br />
create table student_course (StudentID int, CourseID int)<br />
create table course (CourseID int, Name varchar(50))<br />
<br />
insert into student select 1,'Fred'<br />
insert into student select 2,'Joe'<br />
insert into student select 3,'Mary'<br />
<br />
insert into course select 1,'Maths'<br />
insert into course select 2,'Cooking'<br />
insert into course select 3,'Languages'<br />
<br />
insert into student_course select 1,1<br />
insert into student_course select 1,3<br />
insert into student_course select 2,1<br />
insert into student_course select 3,1<br />
insert into student_course select 3,2<br />
insert into student_course select 3,3<br />
<br />
go<br />
<br />
/* the bit that really does the work */<br />
CREATE FUNCTION dbo.udf_GetStudentCourses(@StudentID int)<br />
RETURNS VARCHAR(1000) AS<br />
<br />
BEGIN<br />
   DECLARE @CourseList varchar(1000)<br />
<br />
   SELECT @CourseList = COALESCE(@CourseList + ', ', '') + c.Name<br />
   FROM Student_Course s, Course c<br />
   WHERE s.StudentID = @StudentID<br />
	and c.CourseID = s.CourseID<br />
<br />
   RETURN @CourseList<br />
END<br />
go<br />
<br />
/* get the results */<br />
select Name,dbo.udf_GetStudentCourses(StudentID)<br />
from Student

<br />
declare @string varchar(1000)<br />
select @string=movieids from test where X = 1<br />
EXECUTE ('SELECT * FROM movies WHERE movie_id IN ('+ @string +')')<br />

AlexeiXX3 wrote:

I wonder what the difference is between EXE and EXECUTE??

Update Account<br />
set HeadOfficeId = AccountId <br />
where ImportedHeadOfficeId = ImportedId