test sql

Sql code posted
created at 17 Oct 16:12

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
SET IDENTITY_INSERT QuizItems ON

insert into 
  QuizItems(  ID, 
        Views, 
        Url, 
        Created, 
        Header, 
        Body, 
        FK_CreatedBy, 
        FK_Parent)
select 
  ThreadID as ID,
  0 as Views
  dbo.removeUnsafeCharactersFromUrl(Title) + '.quiz' as Url,
  GETDATE() as Created,
  Title as Header,
  Body,
  dbo.mapUsersFromLmsToLion(PostingUserID) as FK_CreatedBy,
  NULL as FK_Parent 
from Postings
where ParentPostID is null

SET IDENTITY_INSERT QuizItems OFF
480 Bytes in 5 ms with coderay