1
00:00:01,349 --> 00:00:05,410
texas one thirty cheetos mister where are we talking you to conquer two

2
00:00:05,410 --> 00:00:09,359
nations of the pleasant for delivery of the dinosaur to a certain dollar to

3
00:00:09,359 --> 00:00:10,888
study thirteen

4
00:00:10,888 --> 00:00:13,128
didi thirty-four

5
00:00:13,128 --> 00:00:15,798
open it up

6
00:00:15,798 --> 00:00:19,868
felt then appear on concrete and they were looking out for about their own

7
00:00:19,868 --> 00:00:26,868
kolkata nation before

8
00:00:28,318 --> 00:00:31,210
already productivity much depth thirty days

9
00:00:31,210 --> 00:00:34,350
it is slowly because i used to

10
00:00:34,350 --> 00:00:39,020
begin to create they datasheet for booking so we can still see inflation up

11
00:00:39,020 --> 00:00:40,820
bookings

12
00:00:40,820 --> 00:00:45,100
uh... and i'm going to quickly first of all in a moment a contract to make up

13
00:00:45,100 --> 00:00:49,359
the filled there's not much point in explaining fuel concatenation his you're

14
00:00:49,359 --> 00:00:51,409
looking to the video because

15
00:00:51,409 --> 00:00:54,089
you know his unit not to do it the better

16
00:00:54,090 --> 00:00:57,100
or if you know what it is just for a long video daniel

17
00:00:57,100 --> 00:00:59,939
real on more than me telling you

18
00:00:59,939 --> 00:01:01,489
disclose full-length

19
00:01:01,490 --> 00:01:03,789
at a crate

20
00:01:03,789 --> 00:01:06,920
who query design

21
00:01:06,920 --> 00:01:12,680
and we want to booking details and table bookings

22
00:01:12,680 --> 00:01:14,110
azemi needs

23
00:01:14,109 --> 00:01:16,890
uh... scrapbooking aunty

24
00:01:16,890 --> 00:01:18,030
looking date

25
00:01:18,030 --> 00:01:22,859
hank historically

26
00:01:22,859 --> 00:01:26,370
clinique checking the check out today

27
00:01:26,370 --> 00:01:27,399
her mighty

28
00:01:27,399 --> 00:01:29,409
and

29
00:01:29,409 --> 00:01:30,030
can anyone

30
00:01:30,030 --> 00:01:32,399
nodes

31
00:01:32,399 --> 00:01:33,320
uh...

32
00:01:33,319 --> 00:01:34,609
sappal run it

33
00:01:34,609 --> 00:01:37,370
we get this

34
00:01:37,370 --> 00:01:44,370
but what i wonder if you know one of her comcast the nation's filled in

35
00:01:44,500 --> 00:01:45,810
so you

36
00:01:45,810 --> 00:01:47,439
critical top here

37
00:01:47,438 --> 00:01:49,549
kirkum build-up

38
00:01:49,549 --> 00:01:55,090
uh... making congress anything you want to school it uh... details

39
00:01:55,090 --> 00:02:00,530
explaining original day by some medical cost and i don't know why

40
00:02:00,530 --> 00:02:03,159
wanted to say is

41
00:02:03,159 --> 00:02:05,599
x_ amount of mice

42
00:02:05,599 --> 00:02:09,060
x cost per night equals in the full value so we give in

43
00:02:09,060 --> 00:02:10,959
so it's good information

44
00:02:10,959 --> 00:02:13,259
well first let me work out the

45
00:02:13,259 --> 00:02:14,549
mound of nights

46
00:02:14,550 --> 00:02:16,099
so let's just use it

47
00:02:16,098 --> 00:02:17,768
date they function

48
00:02:17,769 --> 00:02:19,479
thursday p m

49
00:02:19,479 --> 00:02:22,939
and they don't function gives us the difference between two days and so we

50
00:02:22,938 --> 00:02:26,408
wondered if you see the check-in date and the check outside

51
00:02:26,408 --> 00:02:27,688
table

52
00:02:27,688 --> 00:02:30,209
booking details

53
00:02:30,209 --> 00:02:35,759
check-in date success story

54
00:02:35,758 --> 00:02:39,158
very very first thing we needed to go

55
00:02:39,158 --> 00:02:41,469
which is uh... into inquisition what

56
00:02:41,469 --> 00:02:45,689
peter guilty not announcement proclivities mocking comma okay

57
00:02:45,689 --> 00:02:48,530
to the first thing in st different he didnt fall so he will or actually

58
00:02:48,530 --> 00:02:50,248
measure which it days

59
00:02:50,248 --> 00:02:52,308
many differs date which is

60
00:02:52,308 --> 00:02:53,538
check-in date

61
00:02:53,538 --> 00:02:55,408
ami table

62
00:02:55,408 --> 00:03:01,498
uh... booking details

63
00:03:01,498 --> 00:03:02,978
outbreak

64
00:03:02,979 --> 00:03:04,429
an uncommon

65
00:03:04,429 --> 00:03:06,318
como beckett

66
00:03:06,318 --> 00:03:09,538
for single as a function it gives us the difference in the checking day in the

67
00:03:09,538 --> 00:03:13,508
check-out date and place it's run that's checked out

68
00:03:13,508 --> 00:03:16,198
the case with details

69
00:03:16,199 --> 00:03:19,120
therefore so assistance in the nineteen th is for

70
00:03:19,120 --> 00:03:21,378
places and faces four so that's fine

71
00:03:21,378 --> 00:03:22,719
correct ans is ongoing

72
00:03:22,719 --> 00:03:25,218
tonight is a complex nation bit

73
00:03:25,218 --> 00:03:29,758
who wanted to say alone it's a four six four nights

74
00:03:29,758 --> 00:03:30,718
so we've got

75
00:03:30,718 --> 00:03:33,908
the first in which is a function that's on the state difference we've been using

76
00:03:33,908 --> 00:03:35,818
ampersand

77
00:03:35,818 --> 00:03:37,149
and then

78
00:03:37,149 --> 00:03:42,949
pokemon closed quotation marks an insight step of space and knocks

79
00:03:42,949 --> 00:03:45,180
nervous placed a sick day

80
00:03:45,180 --> 00:03:48,938
so now we've got four nights

81
00:03:48,938 --> 00:03:50,179
so what we're doing a good

82
00:03:50,179 --> 00:03:54,908
concatenation is it just putting up the string

83
00:03:54,908 --> 00:03:58,149
noticed passcode mystery when i was writing the string presented the same

84
00:03:58,149 --> 00:04:00,870
for every single record that we're putting up a string

85
00:04:00,870 --> 00:04:02,968
it also contains very rules

86
00:04:02,968 --> 00:04:07,340
which is kind of reasonable definition of kolkata nation

87
00:04:07,340 --> 00:04:11,558
four lines

88
00:04:11,558 --> 00:04:14,068
and no need for a cut the cost

89
00:04:14,068 --> 00:04:15,868
of p

90
00:04:15,868 --> 00:04:18,209
uh... night so she just

91
00:04:18,209 --> 00:04:23,579
to revamp the someone sent close up and go to table rooms

92
00:04:23,579 --> 00:04:30,579
and we won't cost per night from clearance to use it to your company

93
00:04:35,088 --> 00:04:40,288
the crop

94
00:04:40,288 --> 00:04:43,058
cost on mon

95
00:04:43,059 --> 00:04:46,020
so the first thing we look at the field where setting repairs are filled with a

96
00:04:46,019 --> 00:04:50,448
fiat money away from where which is table ruins

97
00:04:50,449 --> 00:04:52,189
and

98
00:04:52,189 --> 00:04:54,468
plus a criteria room

99
00:04:54,468 --> 00:04:57,069
pointy equals

100
00:04:57,069 --> 00:04:59,428
and

101
00:04:59,428 --> 00:05:04,189
model max cady table

102
00:05:04,189 --> 00:05:06,978
looking details

103
00:05:06,978 --> 00:05:08,870
through monday afternoon

104
00:05:08,870 --> 00:05:13,000
okay so if you learn about d two cups of them another video not

105
00:05:13,000 --> 00:05:14,360
too long ago

106
00:05:14,360 --> 00:05:17,379
for five years ago and dear karl funky so you can understand what we're doing

107
00:05:17,379 --> 00:05:18,050
it

108
00:05:18,050 --> 00:05:20,449
the basement of passing the room i t

109
00:05:20,449 --> 00:05:23,930
somebody tell the cost of my from table rem space in that remarked in every

110
00:05:23,930 --> 00:05:26,860
person who can bring it

111
00:05:26,860 --> 00:05:30,160
for months at one hundred twenty four months at one fifty says take in this

112
00:05:30,160 --> 00:05:32,779
room ideal given us the cost back

113
00:05:32,778 --> 00:05:35,610
scaled back into design d

114
00:05:35,610 --> 00:05:37,800
with details

115
00:05:37,800 --> 00:05:43,278
you can

116
00:05:43,278 --> 00:05:45,468
and hair

117
00:05:45,468 --> 00:05:46,978
put pen to sign

118
00:05:46,978 --> 00:05:50,228
if you own timberland and on the side to an american role

119
00:05:50,228 --> 00:05:54,108
whatever car she saw in you need to know where you are so full months at one

120
00:05:54,108 --> 00:05:55,378
hundred twenty pound

121
00:05:55,379 --> 00:05:58,499
and last but not least won or lost without xd

122
00:05:58,499 --> 00:06:04,340
we're gonna say

123
00:06:04,339 --> 00:06:05,879
for lots of them i don't know

124
00:06:05,879 --> 00:06:07,759
uh... knowledge

125
00:06:07,759 --> 00:06:11,269
plano tx you know

126
00:06:11,269 --> 00:06:13,848
persian ok tonight

127
00:06:13,848 --> 00:06:15,478
uh...

128
00:06:15,478 --> 00:06:17,930
equals

129
00:06:17,930 --> 00:06:22,519
lesotho equals

130
00:06:22,519 --> 00:06:23,399
uh...

131
00:06:23,399 --> 00:06:29,468
an employee produced a going on that date dysfunction

132
00:06:29,468 --> 00:06:31,819
times eliminated

133
00:06:31,819 --> 00:06:37,598
warns that the lookup function

134
00:06:37,598 --> 00:06:39,550
as i can run them

135
00:06:39,550 --> 00:06:44,179
yen's contains invalid syntax why does not surprise me

136
00:06:44,178 --> 00:06:46,579
for ninety and tonight he calls

137
00:06:46,579 --> 00:06:51,550
soni nine percent

138
00:06:51,550 --> 00:06:53,408
equals

139
00:06:53,408 --> 00:06:58,639
four hundred ninety group six hundred

140
00:06:58,639 --> 00:06:59,749
gorgeous new dot

141
00:06:59,749 --> 00:07:03,500
pound sign in again

142
00:07:03,500 --> 00:07:05,918
if you make

143
00:07:05,918 --> 00:07:09,838
uh... yes uh... for marshall hundred twenty pump unlike his for tonight

144
00:07:09,838 --> 00:07:11,629
headache that's only if it

145
00:07:11,629 --> 00:07:13,120
with that

146
00:07:13,120 --> 00:07:16,590
and psychology shift f two e speaker

147
00:07:16,589 --> 00:07:17,378
that if you

148
00:07:17,379 --> 00:07:22,649
exactly what's happening

149
00:07:22,649 --> 00:07:25,399
okay so that's the uh...

150
00:07:25,399 --> 00:07:28,068
thus a string through passing him

151
00:07:28,069 --> 00:07:31,189
so that was competitive nation reap basically create a string for every

152
00:07:31,189 --> 00:07:32,909
single record

153
00:07:32,908 --> 00:07:34,629
but different parts of the stream

154
00:07:34,629 --> 00:07:36,509
uh... change depending on

155
00:07:36,509 --> 00:07:39,009
different other information the record so

156
00:07:39,009 --> 00:07:42,288
for example that they this is dancing the check-in and check-out date as that

157
00:07:42,288 --> 00:07:44,709
changes prior record

158
00:07:44,709 --> 00:07:46,948
the change in also had to do your cup

159
00:07:46,949 --> 00:07:51,908
uh... eight record as a different so the cost of model change as well

160
00:07:51,908 --> 00:07:54,278
concatenated it all together

161
00:07:54,278 --> 00:07:56,930
and we end up with

162
00:07:56,930 --> 00:08:00,769
four my cell in london twenty pound per nite x one leg up

163
00:08:00,769 --> 00:08:03,808
uh... let's say that query

164
00:08:03,809 --> 00:08:08,939
that personally sailors your booking date

165
00:08:08,939 --> 00:08:11,849
descending so we get a nurse on first

166
00:08:11,848 --> 00:08:15,779
and say he recorded query

167
00:08:15,779 --> 00:08:19,728
uh... bookings pics indeed

168
00:08:19,728 --> 00:08:21,389
so that's concatenation

169
00:08:21,389 --> 00:08:24,650
uh... it doesn't have a bit confusing more stimulating and it's just been

170
00:08:24,649 --> 00:08:26,889
important there when you make this field here

171
00:08:26,889 --> 00:08:28,399
he get the right

172
00:08:28,399 --> 00:08:31,899
you make sure you have all the empress ends and you get the right syntax those

173
00:08:31,899 --> 00:08:32,990
down saying

174
00:08:32,990 --> 00:08:38,680
snakes we've got all the ambitions in the right place in yugos brought spaces

175
00:08:38,679 --> 00:08:41,250
tricky it is a bit of a pain bout

176
00:08:41,250 --> 00:08:42,539
is worth doing

177
00:08:42,539 --> 00:08:44,469
so i think you watching dancing expedia