need help using BETWEEN operator for datetime

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

need help using BETWEEN operator for datetime

Author

Topic

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 00:49:38

I have this query and when I add an additional WHERE clause using BETWEEN operator to collect data between two particular dates in time it doesn't work...in this case query it always returns "No" whether there is data or not..if I remove it, it works fine...any ideas??


SELECT        COALESCE (CASE WHEN [Total Tardies] < 6 THEN 'Yes' ELSE 'No' END, 'Yes') AS [On Target?]
FROM            (SELECT        SUM(CASE WHEN a.[A1] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A2] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A3] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A4] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A5] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A6] IN ('T', 'X') THEN 1 ELSE 0 END) AS [Total Tardies]
                          FROM            ATT AS a INNER JOIN
                                                    STU AS s ON s.SN = a.SN
                          WHERE        (s.ID = 4057970) AND (a.DT BETWEEN 2013-9-2 AND 2013-11-18)) AS d

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-10-21 : 01:17:48

Can you send the result of the below query:


SELECT SUM(CASE WHEN a.[A1] IN ('T', 'X') THEN 1 ELSE 0 END) 
	, SUM(CASE WHEN a.[A2] IN ('T', 'X') THEN 1 ELSE 0 END) 
	, SUM(CASE WHEN a.[A3] IN ('T', 'X') THEN 1 ELSE 0 END) 
	, SUM(CASE WHEN a.[A4] IN ('T', 'X') THEN 1 ELSE 0 END) 
	, SUM(CASE WHEN a.[A5] IN ('T', 'X') THEN 1 ELSE 0 END) 
	, SUM(CASE WHEN a.[A6] IN ('T', 'X') THEN 1 ELSE 0 END)
FROM ATT AS a INNER JOIN
STU AS s ON s.SN = a.SN
WHERE (s.ID = 4057970) AND (a.DT BETWEEN 2013-9-2 AND 2013-11-18)

--
Chandu

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2013-10-21 : 02:20:38

Date values should be within single quotes

a.DT BETWEEN '2013-9-2' AND '2013-11-18'

Also to deal with time, you may need to rewrite the code by

a.DT >='20130902' AND a.DT< '20131119'

You may need to read this post to know how to use datetime values in WHERE clause
http://beyondrelational.com/modules/2/blogs/70/posts/10899/understanding-datetime-column-part-iii.aspx

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-21 : 08:23:40

see this to understand method for date rabnge comparison

http://visakhm.blogspot.com/2012/12/different-ways-to-implement-date-range.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 11:38:13

I think my issue is that my datetimes are dynamic parameters and when they are called the single quote is omitted.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-21 : 11:49:34

quote:
Originally posted by kristofour

I think my issue is that my datetimes are dynamic parameters and when they are called the single quote is omitted.

If they are parameters, you shouldn't have to use the quotes. For example:

WHERE (s.ID = 4057970) AND (a.DT >= @startDate AND a.DT < @endDate)

The thing that can trip you up here is if the parameters are character types. Then the format in which the @startDate and @endDate can cause problems. So ideally those parameters should be of DATETIME, DATE or SMALLDATETIME.

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 13:21:07

they are definitely DATETIME...i'm trying this but it still doesn't work


DECLARE @ID INT = 4054661;
DECLARE @Tardies INT = 6;
DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;

SELECT        COALESCE (CASE WHEN [Total Tardies] < @Tardies THEN 'Yes' ELSE 'No' END, 'Yes') AS [On Target?]
FROM            (SELECT        SUM(CASE WHEN a.[A1] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A2] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A3] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A4] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A5] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A6] IN ('T', 'X') THEN 1 ELSE 0 END) AS [Total Tardies]
                          FROM            ATT AS a INNER JOIN
                                                    STU AS s ON s.SN = a.SN
                          WHERE        (s.ID = @ID) AND (a.DT BETWEEN ''+@dt1+''  AND  ''+@dt2+'' )) AS d

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-21 : 13:23:39

You don't need the quotes.

...
WHERE        (s.ID = @ID) AND (a.DT BETWEEN @dt1 AND  @dt2 )) AS d

Also, as Madhivanan pointed out, it is better to use >= and < rather than between if the DT column in table ATT can have a time portion.

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 13:33:31

I don't know...I also tried it as suggested...still doesn't work...when I type in the date using single quotes it works??


DECLARE @ID INT = 4054661;
DECLARE @Tardies INT = 6;
DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;

SELECT        COALESCE (CASE WHEN [Total Tardies] < @Tardies THEN 'Yes' ELSE 'No' END, 'Yes') AS [On Target?]
FROM            (SELECT        SUM(CASE WHEN a.[A1] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A2] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A3] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A4] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A5] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A6] IN ('T', 'X') THEN 1 ELSE 0 END) AS [Total Tardies]
                          FROM            ATT AS a INNER JOIN
                                                    STU AS s ON s.SN = a.SN
                          WHERE        (s.ID = @ID) AND (a.DT >= @dt1  AND  a.DT < @dt2 )) AS d

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-21 : 13:39:33

If the data type of DT column in table ATT is DATE or DATETIME, then there should be no difference between typing in date literals (dates in single quotes such as '2013-11-18') and using the variable as you are using. IF the data type of DT is not date or datetime, cast it to date or datetime as in

...
WHERE        (s.ID = @ID) AND (CAST(a.DT AS DATETIME) >= @dt1  AND  a.DT < @dt2 )) AS d

If that does not give you the results that you are expecting, then look at a sampling of the data in the table that is returned in the inner query and see why in one case it passes the filter and in the other case it does not.

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2013-10-21 : 13:40:01

please provide sample data with sample tables with proper column data types?

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 14:18:07

CASTING did not work??? The end results either display "Yes" or "No", table ATT is using a foreign key that I need to join to the STU table to acquire their studentID (STU.ID) hence the join STU AS s ON s.SN = a.SN. Now the thing about this attendance table (ATT) blanks are considered present and on time, unexcused tardies are marked as "T" excused marked as "X" so fields A1-A6(period 1-6) can have no data but a datetime will still be recorded in "DT". I am trying to capture students who are on time hence the "Yes" value within a given time. when the query is run all students are returning a "no" value??, now I am using sample data on my end, so a lot of attendance data is not present the datetime records end on 2013-9-3

FROM ATT
DT column is DATETIME,
A1-A6 are all nvarchar(1)
FROM STU
SN is int
ID is int

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-21 : 14:27:27

Since I don't have access to your tables and data, you have to debug this yourself. This is how I would go about it. First, run the inner query with no aggregation and no date filter to see what that returns.

DECLARE @ID INT = 4054661;
DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;
            
SELECT  *
FROM    ATT AS a
        INNER JOIN STU AS s ON s.SN = a.SN
WHERE   ( s.ID = @ID )

That should give you the list of date ranges. Then apply one date filter and see how the result set changes

DECLARE @ID INT = 4054661;
DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;
            
SELECT  *
FROM    ATT AS a
        INNER JOIN STU AS s ON s.SN = a.SN
WHERE   ( s.ID = @ID ) AND a.DT >= @dt1;

If any rows have been filtered out, make sure that they are consistent with your understanding. Now, apply the second date filter

DECLARE @ID INT = 4054661;
DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;

SELECT  *
FROM    ATT AS a
        INNER JOIN STU AS s ON s.SN = a.SN
WHERE   ( s.ID = @ID ) AND ( a.DT >= @dt1  AND a.DT < @dt2 )

Now you should be able to see exactly what the inner query is using to generate the counts. Count them up manually and see if that matches your expectations.

Alternatively, post the DDL for the tables with sample data. Help on how to do that is here: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-21 : 14:31:38

quote:
Originally posted by kristofour

CASTING did not work??? The end results either display "Yes" or "No", table ATT is using a foreign key that I need to join to the STU table to acquire their studentID (STU.ID) hence the join STU AS s ON s.SN = a.SN. Now the thing about this attendance table (ATT) blanks are considered present and on time, unexcused tardies are marked as "T" excused marked as "X" so fields A1-A6(period 1-6) can have no data but a datetime will still be recorded in "DT". I am trying to capture students who are on time hence the "Yes" value within a given time. when the query is run all students are returning a "no" value??, now I am using sample data on my end, so a lot of attendance data is not present the datetime records end on 2013-9-3

FROM ATT
DT column is DATETIME,
A1-A6 are all nvarchar(1)
FROM STU
SN is int
ID is int

Nobody will be able to hlep you out unless you provide us some sample data from tables and then explain what you;re trying to achieve

See how to post data in below link

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 16:08:59

OK here it is I had to modify the data for privacy reasons


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[STU](
	[SC] [int] NULL,
	[SN] [int] NULL,
	[LN] [nvarchar](255) NULL,
	[FN] [nvarchar](255) NULL,
	[MN] [nvarchar](255) NULL,
	[ID] [int] NULL,
	[SX] [nvarchar](255) NULL,
	[GR] [int] NULL,
	[BD] [datetime] NULL,
	[PG] [nvarchar](255) NULL,
	[AD] [nvarchar](255) NULL,
	[CY] [nvarchar](255) NULL,
	[ST] [nvarchar](255) NULL,
	[ZC] [nvarchar](255) NULL,
	[ZX] [nvarchar](255) NULL,
	[TL] [nvarchar](255) NULL,
	[FW] [nvarchar](255) NULL,
	[FX] [nvarchar](255) NULL,
	[MW] [nvarchar](255) NULL,
	[MX] [nvarchar](255) NULL,
	[T1] [nvarchar](255) NULL,
	[T2] [nvarchar](255) NULL,
	[T3] [nvarchar](255) NULL,
	[T4] [nvarchar](255) NULL,
	[T5] [nvarchar](255) NULL,
	[U1] [nvarchar](255) NULL,
	[U2] [nvarchar](255) NULL,
	[U3] [nvarchar](255) NULL,
	[U4] [nvarchar](255) NULL,
	[U5] [nvarchar](255) NULL,
	[U6] [nvarchar](255) NULL,
	[U7] [nvarchar](255) NULL,
	[U8] [nvarchar](255) NULL,
	[ED] [datetime] NULL,
	[LD] [nvarchar](255) NULL,
	[GC] [nvarchar](255) NULL,
	[MC] [nvarchar](255) NULL,
	[EN] [nvarchar](255) NULL,
	[EC] [nvarchar](255) NULL,
	[SP] [nvarchar](255) NULL,
	[LS] [float] NULL,
	[GP] [float] NULL,
	[CR] [float] NULL,
	[CS] [float] NULL,
	[TP] [float] NULL,
	[CP] [float] NULL,
	[UR] [float] NULL,
	[CA] [float] NULL,
	[CC] [float] NULL,
	[CU] [float] NULL,
	[ON] [float] NULL,
	[QT] [nvarchar](255) NULL,
	[TT] [nvarchar](255) NULL,
	[PT] [nvarchar](255) NULL,
	[LK] [nvarchar](255) NULL,
	[LT] [float] NULL,
	[RE] [nvarchar](255) NULL,
	[PC] [nvarchar](255) NULL,
	[TR] [nvarchar](255) NULL,
	[LO] [float] NULL,
	[HI] [float] NULL,
	[TG] [nvarchar](255) NULL,
	[LG] [float] NULL,
	[LA] [float] NULL,
	[MR] [float] NULL,
	[LR] [nvarchar](255) NULL,
	[FK] [float] NULL,
	[GG] [float] NULL,
	[GT] [float] NULL,
	[GK] [float] NULL,
	[GS] [float] NULL,
	[BM] [nvarchar](255) NULL,
	[CO] [nvarchar](255) NULL,
	[HT] [float] NULL,
	[WT] [float] NULL,
	[EY] [nvarchar](255) NULL,
	[HC] [nvarchar](255) NULL,
	[L2] [float] NULL,
	[GA] [float] NULL,
	[GD] [float] NULL,
	[SD] [nvarchar](255) NULL,
	[DG] [nvarchar](255) NULL,
	[GPN] [float] NULL,
	[TPN] [float] NULL,
	[CPN] [float] NULL,
	[GGN] [float] NULL,
	[GTN] [float] NULL,
	[PTS] [float] NULL,
	[PUC] [float] NULL,
	[PCS] [float] NULL,
	[QUC] [nvarchar](255) NULL,
	[QCS] [nvarchar](255) NULL,
	[LF] [nvarchar](255) NULL,
	[HL] [nvarchar](255) NULL,
	[SQ] [float] NULL,
	[NS] [float] NULL,
	[HP] [nvarchar](255) NULL,
	[DE] [float] NULL,
	[DP] [float] NULL,
	[DA] [float] NULL,
	[CCG] [float] NULL,
	[GCG] [float] NULL,
	[NG] [float] NULL,
	[RAD] [nvarchar](255) NULL,
	[RCY] [nvarchar](255) NULL,
	[RST] [nvarchar](255) NULL,
	[RZC] [nvarchar](255) NULL,
	[RZX] [nvarchar](255) NULL,
	[NT] [float] NULL,
	[CRL] [nvarchar](255) NULL,
	[SM] [float] NULL,
	[DM] [float] NULL,
	[CID] [nvarchar](255) NULL,
	[SS] [nvarchar](255) NULL,
	[PED] [nvarchar](255) NULL,
	[SF] [nvarchar](255) NULL,
	[LNA] [nvarchar](255) NULL,
	[FNA] [nvarchar](255) NULL,
	[MNA] [nvarchar](255) NULL,
	[SFA] [nvarchar](255) NULL,
	[VDT] [datetime] NULL,
	[VBD] [nvarchar](255) NULL,
	[VBO] [nvarchar](255) NULL,
	[BCY] [nvarchar](255) NULL,
	[BST] [nvarchar](255) NULL,
	[BCU] [nvarchar](255) NULL,
	[CL] [nvarchar](255) NULL,
	[HLO] [nvarchar](255) NULL,
	[DO] [nvarchar](255) NULL,
	[HSG] [nvarchar](255) NULL,
	[IT] [nvarchar](255) NULL,
	[ITD] [nvarchar](255) NULL,
	[GRT] [nvarchar](255) NULL,
	[EC2] [nvarchar](255) NULL,
	[EC3] [nvarchar](255) NULL,
	[EC4] [nvarchar](255) NULL,
	[EC5] [nvarchar](255) NULL,
	[EC6] [nvarchar](255) NULL,
	[GPA] [float] NULL,
	[TPA] [float] NULL,
	[CPA] [float] NULL,
	[GGA] [float] NULL,
	[GTA] [float] NULL,
	[OCR] [float] NULL,
	[OGR] [float] NULL,
	[HS] [float] NULL,
	[NTR] [nvarchar](255) NULL,
	[CIC] [nvarchar](255) NULL,
	[AP1] [nvarchar](255) NULL,
	[AP2] [nvarchar](255) NULL,
	[SEM] [nvarchar](255) NULL,
	[PEM] [nvarchar](255) NULL,
	[U9] [nvarchar](255) NULL,
	[U10] [nvarchar](255) NULL,
	[DD] [datetime] NULL,
	[DNR] [nvarchar](255) NULL,
	[CUC] [nvarchar](255) NULL,
	[CCS] [nvarchar](255) NULL,
	[SES] [nvarchar](255) NULL,
	[SG] [nvarchar](255) NULL,
	[RN] [float] NULL,
	[VPC] [nvarchar](255) NULL,
	[EGD] [nvarchar](255) NULL,
	[CCO] [nvarchar](255) NULL,
	[BPS] [nvarchar](255) NULL,
	[SWR] [nvarchar](255) NULL,
	[EOY] [nvarchar](255) NULL,
	[CO2] [nvarchar](255) NULL,
	[RS] [float] NULL,
	[MPH] [nvarchar](255) NULL,
	[CO3] [nvarchar](255) NULL,
	[OID] [float] NULL,
	[NID] [nvarchar](255) NULL,
	[AV] [bit] NOT NULL,
	[ETH] [nvarchar](255) NULL,
	[RC1] [nvarchar](255) NULL,
	[RC2] [nvarchar](255) NULL,
	[RC3] [nvarchar](255) NULL,
	[RC4] [nvarchar](255) NULL,
	[RC5] [nvarchar](255) NULL,
	[U11] [nvarchar](255) NULL,
	[U12] [nvarchar](255) NULL,
	[U13] [nvarchar](255) NULL,
	[INE] [nvarchar](255) NULL,
	[TRU] [nvarchar](255) NULL,
	[OSI] [nvarchar](255) NULL,
	[RDT] [datetime] NULL,
	[ITE] [nvarchar](255) NULL,
	[ENS] [float] NULL,
	[SNS] [float] NULL,
	[SLD] [nvarchar](255) NULL,
	[NIT] [nvarchar](255) NULL,
	[NTD] [nvarchar](255) NULL,
	[NRS] [float] NULL,
	[RSY] [nvarchar](255) NULL,
	[RP] [float] NULL,
	[RC] [nvarchar](255) NULL,
	[DTS] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (8, 3005, NULL, N'Ximena', N'Nissimara', 4092300, N'F', 0, NULL, N'Ismael Soto & Carla Palomera', N'434 Josephine St', N'Lynwood', N'Ca', N'90262', NULL, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 994, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 18593, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'2', N'1', 0, 8, N'ASTHMA STUDENT', 158, 149, 9, 0, 0, 1, NULL, N'Lynwood', N'Ca', N'90262', NULL, 0, NULL, 0, 0, N'2553431488', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Torrance', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'6Y72X4594B', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (28, 4037, N'', N'Abigail', N'Anahi', 4057382, N'F', 8, NULL, N'Robertina Suarez/Santos Espi', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 21, 1.4667, 254, 302, 1.6667, 0, 1, 90, 75, 0, 5999, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 14770, 2.6667, 2.6667, 83, 302, N'4057382', NULL, 0, 0, NULL, NULL, 0, 15, 15, NULL, NULL, 1.4667, 1.6667, 0, 2.6667, 2.6667, 22, 0, 0, N'N', N'N', N'3', N'1', 0, 30, NULL, 108, 100, 8, 0, 0, 9, NULL, N'Lynwood', N'CA', N'90262', NULL, 0, N'7', 8, 0, N'7106422476', NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, N'Inglewood', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'N', N'N', NULL, NULL, 1901242, N'G69392KN5J', NULL, NULL, NULL, NULL, NULL, NULL, 21, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 21, N'AeriesCS', 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (8, 3091, N'', N'Jordhan', N'Felipe', 4071867, N'M', 6, NULL, N'Maria Luisa Ibarguen Delgado', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 800, 0, 0, 0, 0, 0, 0, 0, 0, 20, 10598, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 19599, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'3', N'1', 0, 20, NULL, 72, 71, 1, 0, 0, 7, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, N'5', 6, 6, N'5168027542', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Phoenix', N'AZ', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'5EW447G6RD', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, 0, NULL, 0, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 20, N'AeriesCS', 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (14, 1964, N'', N'Alexander', NULL, 4083941, N'M', 2, NULL, N'Graciela Jara Gustavo Soto', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 4188, 0, 0, 0, 0, N'4083941', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'4', N'1', 0, 14, NULL, 163, 161, 2, 0, 0, 3, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, NULL, 0, 0, N'5478697517', NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, N'Bellflower', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'9477F6P479', NULL, NULL, NULL, NULL, NULL, NULL, 14, NULL, NULL, 0, NULL, 0, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 14, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (14, 2004, N'', N'Yasmin', NULL, 4084044, N'F', 1, NULL, N'Graciela Jara Gustavo Soto', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 4188, 0, 0, 0, 0, N'4084044', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'3', N'1', 0, 14, NULL, 163, 161, 2, 0, 0, 2, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, NULL, 0, 18, N'1083542962', NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, N'Huntington Park', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'TFP986EXP7', NULL, NULL, NULL, NULL, NULL, NULL, 14, NULL, NULL, 0, NULL, 0, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (1, 2229, N'', N'Carlos', N'Javier', 4086301, N'M', 1, NULL, N'Javier Soto- Alelia Paleo', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', N'cell', N'', N'cell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 976, 0, NULL, NULL, NULL, NULL, 0, N'19', NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 3594, 0, 0, 0, 0, N'4086301', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'3', N'1', 0, 1, NULL, 163, 160, 3, 0, 0, 2, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 0, 18, N'5572094940', NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'MV79F36N6F', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (8, 3067, N'', N'Daniel', N'Enrique', 4092525, N'M', 18, NULL, N'Vilasack Soulivong & Selene Pacheco', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'P', 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 18823, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 8, NULL, 158, 158, 0, 0, 0, 0, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, NULL, 18, 18, NULL, NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'6E9773QR42', NULL, NULL, NULL, NULL, NULL, NULL, 38, NULL, NULL, 0, NULL, 1, N'Y', N'700', N'206', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 38, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (35, 11150, N'', N'Yamise', NULL, 4072460, N'F', 12, NULL, N'Debra Brown (Guardian)', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, N'', N'cell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 800, 1.5646, 51, 168, 1.4407, 1.65, 0, 183, 113, 0, 3497, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 19333, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 1.5646, 1.4407, 1.65, 0, 0, 46, 0, 0, NULL, NULL, N'1', N'0', 0, 0, NULL, 111, 111, 0, 0, 0, 13, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, N'7', 9, 0, N'9143098301', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Gardena', N'CA', N'US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 307241, N'78VMS3G95Y', NULL, NULL, NULL, NULL, NULL, NULL, 38, NULL, NULL, 0, NULL, 0, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'2010-2011', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 38, N'AeriesCS', 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (38, 7211, N'', N'Alika', NULL, 4074372, N'F', 10, NULL, N'Corendia Bryant-Johnny Stewart', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 21, 2.8125, 145, 526, 2.7222, 3.3333, 77, 90, 90, 467, 3831, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 11910, 3.3333, 3.3333, 72, 526, NULL, NULL, 0, 0, NULL, NULL, 0, 30, 30, NULL, NULL, 2.8125, 2.7222, 3.3333, 3.3333, 3.3333, 45, 3.2, 3.2, N'N', N'N', N'1', N'0', 0, 38, NULL, 167, 165, 2, 0, 0, 11, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, N'8', 9, 6, N'2053743805', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Bellflower', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, N'R', NULL, NULL, NULL, N'N', N'N', NULL, NULL, 19057, N'2R8P889WHR', NULL, NULL, NULL, NULL, NULL, NULL, 21, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'2011-2012', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 21, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (38, 8398, N'', N'Michelle', NULL, 4054916, N'F', 9, NULL, N'Douangchanh - Vannee  Vongphac', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'299', NULL, 20, 2, 239, 502, 2.1667, 0, 1, 30, 30, 0, 3514, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 374, 2, 2.1667, 237, 502, N'726', NULL, 0, 0, NULL, NULL, 0, 30, 30, NULL, NULL, 2, 2.1667, 0, 2, 2.1667, 10, 0, 0, N'N', N'N', N'3', N'10', 0, 38, NULL, 167, 165, 2, 0, 0, 10, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'7', 9, 0, N'9106394681', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'N', N'N', NULL, NULL, 1910848, N'74BJ54452D', NULL, NULL, NULL, NULL, NULL, NULL, 8, NULL, NULL, 0, NULL, 0, N'N', N'299', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'2012-2013', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 8, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (12, 3604, N'', N'Ayren', N'Fernanda', 4092717, N'F', 18, NULL, N'Ligia Giron', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'P', 0, 0, 0, 0, 0, 0, 0, 0, 0, 65, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 19005, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'5', N'0', 0, 12, NULL, 158, 158, 0, 0, 0, 0, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 18, 18, NULL, NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'E9VY72K876', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, NULL, 0, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (21, 5979, N'', N'Kimberly', NULL, 4054711, N'F', 8, NULL, N'Jorge Soyo-Soraida Solis', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 14, 1.8667, 0, 0, 2.1667, 0, 1, 90, 75, 998, 913, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 13176, 2, 2, 114, 485, N'4054711', NULL, 0, 0, NULL, NULL, 0, 10, 10, NULL, NULL, 1.8667, 2.1667, 0, 2, 2, 28, 0, 0, N'N', N'N', N'3', N'1', 0, 38, NULL, 163, 162, 1, 0, 0, 9, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 7, 0, N'6106499414', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, N'R', NULL, NULL, NULL, N'N', N'N', NULL, NULL, 664987, N'4CC76XPP42', NULL, NULL, NULL, NULL, NULL, NULL, 21, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 21, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (14, 1279, N'', N'Nataly', N'Jaylin', 4070492, N'F', 4, NULL, N'Soraida Solis', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 14, 0, 0, 0, 0, 0, 0, 0, 0, 63, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 13176, 0, 0, 0, 0, N'4070492', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'3', N'1', 0, 14, NULL, 163, 162, 1, 0, 0, 5, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, N'3', 0, 0, N'7166928306', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'FC743V8P93', NULL, NULL, NULL, NULL, NULL, NULL, 14, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 14, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (8, 1757, N'', N'Justin', NULL, 4069210, N'M', 6, NULL, N'Shirley Mickel', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, N'', N'cell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 8, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 2679, 0, 0, 0, 0, N'4069210', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 20, NULL, 163, 163, 0, 0, 0, 7, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'10', 0, 0, N'7154636106', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Long Beach', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'9F9SC89H57', NULL, NULL, NULL, NULL, NULL, NULL, 8, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 20, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (6, 3503, N'', N'Xavier', N'Elijah Eugene', 4089258, N'M', 18, NULL, N'Tiffany Starkey-Spann & Jonathan Span', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', N'wk', N'', N'cell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', N'P', 8, 0, 0, 0, 0, 0, 0, 0, 0, 202, 2823, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 5481, 0, 0, 0, 0, N'4089258', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 6, NULL, 160, 132, 28, 0, 0, 0, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, NULL, 0, 18, N'2332068693', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Downey', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, N'S', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'7X65V4JAXV', NULL, NULL, NULL, NULL, NULL, NULL, 38, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 10, N'AeriesCS', 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (1, 2546, N'', N'Jordan', N'Anthony', 4091242, N'M', 0, NULL, N'Erica Spears', N'', N'Compton', N'CA', N'90220', NULL, N'', N'', NULL, N'', N'home', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 930, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 17604, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 1, NULL, 163, 157, 6, 0, 0, 1, N'', N'Compton', N'CA', N'90220', NULL, 0, NULL, 0, 0, N'1720992611', NULL, N'3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Harbor City', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'T9P2W63K4Q', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, NULL, 0, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (5, 2413, N'', N'Timojene', N'Kiara', 4090287, N'F', 0, NULL, N'Kenneth Moore / Aleasha Brady', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 784, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 9466, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 5, NULL, 163, 147, 16, 0, 0, 1, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 0, 0, N'9420445956', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Los Angeles', N'CA', N'US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'9PFJ58TKWA', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 5, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (21, 7059, N'', N'Robert', N'Kevon', 4075395, N'M', 7, NULL, N'Sara-Kenneth Stallworth', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 3, 1.8, 329, 516, 2, 0, 1, 30, 30, 0, 2686, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 8694, 0.3333, 0.3333, 377, 508, N'4075395', NULL, 0, 0, NULL, NULL, 0, 15, 5, NULL, NULL, 1.8, 2, 0, 0.3333, 0.3333, 9, 0, 0, N'N', N'N', N'1', N'0', 0, 21, NULL, 163, 161, 2, 0, 0, 8, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, N'8', 7, 3, N'5116897552', NULL, N'3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'N', N'N', NULL, NULL, 778756, N'3842GTUJ88', NULL, NULL, NULL, NULL, NULL, NULL, 21, NULL, NULL, 0, NULL, 0, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, N'M', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 3, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (30, 10575, N'', N'Valerie', N'Nicole', 4041969, N'F', 12, NULL, N'Sara Stallworth', N'', N'Lynwood', N'Ca', N'90262', NULL, N'', N'', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 38, 2.0233, 329, 487, 2.0417, 1.9032, 358, 240, 215, 26, 4893, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 65, 0, NULL, 8694, 2.4, 2.4, 244, 487, NULL, NULL, 0, 0, NULL, NULL, 0, 25, 25, NULL, NULL, 2.0233, 2.0417, 1.9032, 2.4, 2.4, 87, 1.6522, 1.6923, N'N', N'N', N'1', N'0', 0, 0, NULL, 163, 163, 0, 0, 0, 13, N'', N'Lynwood', N'Ca', N'90262', NULL, 0, N'8', 10, 0, N'3055330517', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'N', N'N', NULL, NULL, 1523350, N'VCHU3T6ASA', NULL, NULL, NULL, NULL, NULL, NULL, 21, NULL, NULL, 0, NULL, 0, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'2009-2010', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 21, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (5, 1328, N'', N'Britney', NULL, 4072630, N'F', 4, NULL, N'Veronica or Curtis Staten', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 5, 0, 0, 0, 0, 0, 0, 0, 0, 436, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 3447, 0, 0, 0, 0, N'4072630', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 5, NULL, 163, 155, 8, 0, 0, 5, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'5', 0, 0, N'1170376683', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Los Angeles', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'WW483GV298', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 5, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (8, 1782, N'', N'Yasmine', N'Veronica', 4074043, N'F', 4, NULL, N'Catherine Sterling', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 950, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 13177, 0, 0, 0, 0, N'4074043', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 8, N'ASTHMA STUDENT', 163, 161, 2, 0, 0, 5, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'7', 0, 0, N'1184233263', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'D5UX56X238', NULL, NULL, NULL, NULL, NULL, NULL, 7, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 8, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (10, 2420, N'', N'Amajae', NULL, 4092851, N'M', 4, NULL, N'LeDaya Epps', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 19117, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 10, NULL, 133, 131, 2, 0, 0, 5, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 4, 4, N'7179897756', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Lynwood', N'CA', N'US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'6Y72X4594B', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, NULL, 0, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (10, 2031, N'', N'TraShaunna', NULL, 4087003, N'F', 4, NULL, N'Latrice Bradley', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 125, 0, NULL, NULL, N'X', NULL, 0, N'125', NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 4745, 0, 0, 0, 0, N'4087003', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 10, NULL, 163, 144, 19, 0, 0, 5, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 2, 2, N'8500310212', NULL, N'4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Inglewood', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, N'R', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'A82K6V5BJ5', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 10, NULL, NULL, N'0', 0, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (9, 2667, N'', N'Chey', N'Arrious', 4089064, N'M', 3, NULL, N'Florencetta Stewart', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 951, 0, NULL, NULL, N'X', NULL, 0, NULL, NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 7606, 0, 0, 0, 0, N'4089064', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'1', N'0', 0, 9, NULL, 163, 157, 6, 0, 0, 4, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'5', 2, 2, N'2196123895', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Los Angeles', N'CA', N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'4J3Q2TAK97', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 3, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (20, 5533, N'', N'Dezure', NULL, 4093527, N'F', 7, NULL, N'Latasha Blaylock', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1.2, 262, 361, 1.6667, 0, 1, 30, 20, 0, 0, NULL, NULL, N'X', NULL, 0, N'357', NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 19657, 0.4, 0.3333, 214, 361, NULL, NULL, 0, 0, NULL, NULL, 0, 30, 10, NULL, NULL, 1.2, 1.6667, 0, 0.4, 0.3333, 6, 0, 0, NULL, NULL, N'1', N'0', 0, 20, NULL, 62, 53, 9, 0, 0, 8, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 0, 0, N'9121006901', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'West Covina', NULL, N'US', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'F59A2B356H', NULL, NULL, NULL, NULL, NULL, NULL, 28, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 12, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (20, 5309, N'', N'Lanaya', N'Chantel', 4069172, N'F', 7, NULL, N'Cornelia Stewart', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'600', NULL, 6, 2.2, 229, 361, 2, 0, 1, 30, 30, 0, 1035, NULL, NULL, NULL, NULL, 0, N'226', NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 3821, 0.5, 0.3333, 214, 361, N'325', NULL, 0, 0, NULL, NULL, 0, 15, 5, NULL, NULL, 2.2, 2, 0, 0.5, 0.3333, 11, 0, 0, N'N', N'N', N'1', N'0', 0, 20, NULL, 163, 156, 7, 0, 0, 8, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'10', 7, 1, N'5154639502', NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, N'Madera', N'CA', N'US', N'0', NULL, NULL, NULL, N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'N', N'N', NULL, NULL, 1164106, N'A2Y287S58V', NULL, NULL, NULL, NULL, NULL, NULL, 20, NULL, NULL, 0, NULL, 1, N'N', N'600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 20, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (1, 1763, N'', N'Daniel', N'Alejandro', 4075627, N'M', 3, NULL, N'Joseph Stolz', N'', N'Lynwood', N'CA', N'90262', NULL, N'', N'', N'cell', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, NULL, NULL, NULL, NULL, 0, N'968', NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 4349, 0, 0, 0, 0, N'4075627', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'4', N'1', 0, 1, NULL, 163, 161, 2, 0, 0, 4, N'', N'Lynwood', N'CA', N'90262', NULL, 0, N'7', 0, 0, N'6187026914', NULL, N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Huntington Park', N'CA', N'US', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'BH6F8G5929', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, NULL, 1, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 1, NULL, 0, NULL, NULL)
INSERT [dbo].[STU] ([SC], [SN], [LN], [FN], [MN], [ID], [SX], [GR], [BD], [PG], [AD], [CY], [ST], [ZC], [ZX], [TL], [FW], [FX], [MW], [MX], [T1], [T2], [T3], [T4], [T5], [U1], [U2], [U3], [U4], [U5], [U6], [U7], [U8], [ED], [LD], [GC], [MC], [EN], [EC], [SP], [LS], [GP], [CR], [CS], [TP], [CP], [UR], [CA], [CC], [CU], [ON], [QT], [TT], [PT], [LK], [LT], [RE], [PC], [TR], [LO], [HI], [TG], [LG], [LA], [MR], [LR], [FK], [GG], [GT], [GK], [GS], [BM], [CO], [HT], [WT], [EY], [HC], [L2], [GA], [GD], [SD], [DG], [GPN], [TPN], [CPN], [GGN], [GTN], [PTS], [PUC], [PCS], [QUC], [QCS], [LF], [HL], [SQ], [NS], [HP], [DE], [DP], [DA], [CCG], [GCG], [NG], [RAD], [RCY], [RST], [RZC], [RZX], [NT], [CRL], [SM], [DM], [CID], [SS], [PED], [SF], [LNA], [FNA], [MNA], [SFA], [VDT], [VBD], [VBO], [BCY], [BST], [BCU], [CL], [HLO], [DO], [HSG], [IT], [ITD], [GRT], [EC2], [EC3], [EC4], [EC5], [EC6], [GPA], [TPA], [CPA], [GGA], [GTA], [OCR], [OGR], [HS], [NTR], [CIC], [AP1], [AP2], [SEM], [PEM], [U9], [U10], [DD], [DNR], [CUC], [CCS], [SES], [SG], [RN], [VPC], [EGD], [CCO], [BPS], [SWR], [EOY], [CO2], [RS], [MPH], [CO3], [OID], [NID], [AV], [ETH], [RC1], [RC2], [RC3], [RC4], [RC5], [U11], [U12], [U13], [INE], [TRU], [OSI], [RDT], [ITE], [ENS], [SNS], [SLD], [NIT], [NTD], [NRS], [RSY], [RP], [RC], [DTS]) VALUES (1, 2322, N'', N'Diego', NULL, 4088251, N'M', 1, NULL, N'Daniel Stolz & Juana Salcedo', N'', N'Lynwood', N'CA', N'90262', NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'500', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 939, 0, NULL, NULL, NULL, NULL, 0, N'19', NULL, NULL, 0, 9, NULL, 0, 0, 0, NULL, 4349, 0, 0, 0, 0, N'4088251', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, N'3', N'1', 0, 1, NULL, 163, 161, 2, 0, 0, 2, N'', N'Lynwood', N'CA', N'90262', NULL, 0, NULL, 0, 0, N'9054817200', NULL, N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Zapopan', N'JA', N'MX', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'6V9B8VSYWQ', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, NULL, 0, N'Y', N'700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, N'0', 1, NULL, 0, NULL, NULL)
/****** Object:  Table [dbo].[ATT]    Script Date: 10/21/2013 13:08:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ATT](
	[SC] [float] NULL,
	[SN] [float] NULL,
	[DY] [float] NULL,
	[CD] [nvarchar](255) NULL,
	[PR] [nvarchar](255) NULL,
	[GR] [float] NULL,
	[TR] [nvarchar](255) NULL,
	[TN] [float] NULL,
	[AL] [nvarchar](255) NULL,
	[A0] [nvarchar](255) NULL,
	[A1] [nvarchar](255) NULL,
	[A2] [nvarchar](255) NULL,
	[A3] [nvarchar](255) NULL,
	[A4] [nvarchar](255) NULL,
	[A5] [nvarchar](255) NULL,
	[A6] [nvarchar](255) NULL,
	[A7] [nvarchar](255) NULL,
	[A8] [nvarchar](255) NULL,
	[A9] [nvarchar](255) NULL,
	[DT] [datetime] NULL,
	[RS] [nvarchar](255) NULL,
	[NS] [float] NULL,
	[AP1] [nvarchar](255) NULL,
	[AP2] [nvarchar](255) NULL,
	[HS] [float] NULL,
	[IT] [nvarchar](255) NULL,
	[NPS] [nvarchar](255) NULL,
	[DEL] [float] NULL,
	[DTS] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 15, N' ', N' ', 0, N' ', 0, N'K', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A0CC00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A0D100000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 25, N' ', N' ', 0, N' ', 0, N'K', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A0DA00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A0DA00000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 49, N' ', N' ', 0, N' ', 0, N'I', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A0FC00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A10200000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 85, N' ', N' ', 0, N' ', 0, N'A', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A12E00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A12E00000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 105, N' ', N' ', 0, N' ', 0, N'I', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A14A00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A15600000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 110, N' ', N' ', 0, N' ', 0, N'K', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A15100000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A15400000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 120, N' ', N' ', 0, N' ', 0, N'I', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A15F00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A16200000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 163, N' ', N' ', 0, N' ', 0, N'K', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A19C00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A19C00000000 AS DateTime))
INSERT [dbo].[ATT] ([SC], [SN], [DY], [CD], [PR], [GR], [TR], [TN], [AL], [A0], [A1], [A2], [A3], [A4], [A5], [A6], [A7], [A8], [A9], [DT], [RS], [NS], [AP1], [AP2], [HS], [IT], [NPS], [DEL], [DTS]) VALUES (1, 1127, 198, N' ', N' ', 0, N' ', 0, N'I', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', CAST(0x0000A1CD00000000 AS DateTime), N'', 0, N'', N'', 0, N' ', N'', 0, CAST(0x0000A1D400000000 AS DateTime))

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-21 : 17:04:25

Change your SELECT (first line) to this:

SELECT        CASE WHEN COALESCE ([Total Tardies],0) < @Tardies THEN 'Yes' ELSE 'No' END AS [On Target?]

kristofour
Starting Member

9 Posts

Posted - 2013-10-21 : 17:44:32

thanks so much that did it...so it was the coalesce in the wrong place..

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2013-10-22 : 06:09:33

quote:

Originally posted by kristofour

they are definitely DATETIME...i'm trying this but it still doesn't work


DECLARE @ID INT = 4054661;
DECLARE @Tardies INT = 6;
DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;

SELECT        COALESCE (CASE WHEN [Total Tardies] < @Tardies THEN 'Yes' ELSE 'No' END, 'Yes') AS [On Target?]
FROM            (SELECT        SUM(CASE WHEN a.[A1] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A2] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A3] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A4] IN ('T', 'X') THEN 1 ELSE 0 END) 
                                                    + SUM(CASE WHEN a.[A5] IN ('T', 'X') THEN 1 ELSE 0 END) + SUM(CASE WHEN a.[A6] IN ('T', 'X') THEN 1 ELSE 0 END) AS [Total Tardies]
                          FROM            ATT AS a INNER JOIN
                                                    STU AS s ON s.SN = a.SN
                          WHERE        (s.ID = @ID) AND (a.DT BETWEEN ''+@dt1+''  AND  ''+@dt2+'' )) AS d

You have not read my reply properly. When you assign values to datetime variables use single quotes. So

DECLARE @dt1 DATETIME = 2013-9-3;
DECLARE @dt2 DATETIME = 2013-11-18;

should be

DECLARE @dt1 DATETIME = '2013-9-3';
DECLARE @dt2 DATETIME = '2013-11-18';

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources