Problem in installing SQLSERVER2000 Developer Edition

Dear friends,
I tried to install my SQLServer2000 Developer
Edition in my server machine, which is running on the OS
Windows Server 2000.
I am getting the following errors
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
SQL Server configuration failed.
What is the problem?
Also, i herewith attached the error log file.
Kindly give me the solution and it is very urgent.
with regards,
T.Thirumalairajan B.E
begin 666 sqlstp.log
M,3@.Z,#0Z-# @.0F5G:6X@.4V5T=7 -"C$X.C T.C0P(#@.N,# N,3DT#0HQ.#HP
M-#HT,"!-;V1E(#T@.3F]R;6%L#0HQ.#HP-#HT,"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,3@.Z,#0Z-# @.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'AF,# P,# -"C$X.C T.C0P(%9A;'5E1E13(')E='5R;F5D.B Q
M#0HQ.#HP-#HT,"!686QU95!)1"!R971U<FYE9#H@.,0T*,3@.Z,#0Z-# @.5F%L
M=65,:6,@.<F5T=7)N960Z(# -"C$X.C T.C0P(%-Y<W1E;3H@.5VEN9&]W<R!.
M5"!497)M:6YA;"!397)V97(-"C$X.C T.C0P(%-13"!397)V97(@.4')O9'5C
M=%1Y<&4Z($1E=F5L;W!E<B!%9&ET:6]N(%LP>#-=#0HQ.#HP-#HT,"!"96=I
M;B!!8W1I;VXZ(%-E='5P26YI=&EA;&EZ92 -"C$X.C T.C0P($5N9"!!8W1I
M;VX@.4V5T=7!);FET:6%L:7IE#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3
M971U<$EN<W1A;&P-"C$X.C T.C0P(%)E861I;F<@.4V]F='=A<F5<36EC<F]S
M;V9T7%=I;F1O=W-<0W5R<F5N=%9E<G-I;VY<0V]M;6]N1FEL97-$:7(@.+BXN
M#0HQ.#HP-#HT,"!#;VUM;VY&:6QE<T1I<CU#.EQ0<F]G<F%M($9I;&5S7$-O
M;6UO;B!&:6QE<PT*,3@.Z,#0Z-# @.5VEN9&]W<R!$:7)E8W1O<GD]0SI<5TE.
M3E1<#0HQ.#HP-#HT,"!0<F]G<F%M($9I;&5S/4,Z7%!R;V=R86T@.1FEL97-<
M#0HQ.#HP-#HT,"!414U01$E2/4,Z7$1/0U5-17XQ7$%$34E.27XQ7$Q/0T%,
M4WXQ7%1E;7!<#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3971U<$EN<W1A
M;&P-"C$X.C T.C0P(&1I9W!I9"!S:7IE(#H@.,C4V#0HQ.#HP-#HT,"!D:6=P
M:60@.<VEZ92 Z(#$V- T*,3@.Z,#0Z-# @.0F5G:6X@.06-T:6]N.B @.0VAE8VM&
M:7AE9%)E<75I<F5M96YT<PT*,3@.Z,#0Z-# @.4&QA=&9O<FT@.240Z(#!X9C P
M#0HQ.#HP-#HT,"!697)S:6]N.B U+C N,C$Y-0T*,3@.Z,#0Z-# @.1FEL92!6
M97)S:6]N("T@.0SI<5TE.3E1<<WES=&5M,S)<<VAD;V-V=RYD;&PZ(#4N,"XS
M-3(V+C@.P, T*,3@.Z,#0Z-# @.16YD($%C=&EO;CH@.($-H96-K1FEX961297%U
M:7)E;65N=',-"C$X.C T.C0P($)E9VEN($%C=&EO;CH@.(%-H;W=$:6%L;V=S
M#0HQ.#HP-#HT,"!);FET:6%L($1I86QO9R!-87-K.B P>#@.S,# P9C<L($1I
M<V%B;&4@.0F%C:STP>#$-"C$X.C T.C0Q($)E9VEN($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(Z(#!X,0T*,3@.Z,#0Z-#$@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G
M4VAO=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.16YD($%C=&EO;B @.1&EA;&]G4VAO
M=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.1&EA;&]G(#!X,2!R971U<FYE9#H@.,0T*
M,3@.Z,#0Z-#(@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C T.C0R
M(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#(L
M:6YD97@.],0T*,3@.Z,#0Z-#(@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP
M<CH@.,'@.R#0HQ.#HP-#HT,B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1-
M86-H:6YE3F%M90T*,3@.Z,#0Z-#0@.4VAO=T1L9TUA8VAI;F4@.<F5T=7)N960Z
M(#$-"C$X.C T.C0T($YA;64@./2!#4U!,+"!4>7!E(#T@.,'@.Q#0HQ.#HP-#HT
M-"!"96=I;B!!8W1I;VXZ("!#:&5C:U)E<75I<F5M96YT<PT*,3@. Z,#0Z-#0@.
M4')O8V5S<V]R($%R8VAI=&5C='5R93H@.>#@.V("A096YT:75M*0T*,3@.Z,#0Z
M-#0@.4V5R=FEC92!086-K.B @.-S8X#0HQ.#HP-#HT-"!#;VUP=71E<DYA;64Z
M($-34$P-"C$X.C T.C0T(%5S97(@.3F%M93H@.061M:6YI<W1R871O<@.T*,3@.Z
M,#0Z-#0@.27-!;&Q!8V-E<W-!;&QO=V5D(')E='5R;F5D.B Q#0HQ.#HP-#HT
M-"!/4R!,86YG=6%G93H@.,'@.T,#D-"C$X.C T.C0T($5N9"!!8W1I;VX@.0VAE
M8VM297%U:7)E;65N=',-"C$X.C T.C0T($-R96%T95-E='5P5&]P;VQO9WDH
M0U-03"DL($AA;F1L92 Z(#!X,3@.Y-#$T,"P@.<F5T=7)N960@..B P#0HQ.#HP
M-#HT-"!#<F5A=&53971U<%1O<&]L;V=Y(')E='5R;F5D(#H@.,"P@.2&%N9&QE
M(#H@.,'@.Q.#DT,30P#0HQ.#HP-#HT-"!4;W!O;&]G>2!4>7!E(#H@.,2P@.4F5T
M=7)N(%9A;'5E(#H@., T*,3@.Z,#0Z-#0@.4U1?1V5T4&AY<VEC86Q.;V1E(')E
M='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$X.30Q-C@.-"C$X.C T.C0T(%!.
M7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,3@.Z,#0Z-#0@.4$Y?1V5T4U%,
M4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S(#H@.,'@.R, C<-"C$X.C T
M.C0T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z(# -"C$X
M.C T.C0T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,3@.Z,#0Z-#0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$X.C T.C0T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ.#HP
M-#HT-"!.86UE9"!I;G-T86YC92!L:6UI=#H@.,3 P+"!Q=6]T83H@., T*,3@.Z
M,#0Z-#0@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$X
M.C T.C0T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#0Z-#0@.
M;D9U;&Q-87-K(#T@.,'@.X,S P,&8W+"!N0W5R<F5N=" ](#!X,BP@.;D1I<F5C
M=&EO;B ](# -"C$X.C T.C0T(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X8F8P
M,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-#HT-"!$:6%L;V<@.,'@.R
M(')E='5R;F5D.B P#0HQ.#HP-#HT-"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,3@.Z,#0Z-#0@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X-"QI;F1E>#TR#0HQ.#HP-#HT-"!"96=I;B!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R.B P>#0-"C$X.C T.C0T($)E9VEN($%C=&EO;CH@.
M($1I86QO9U-H;W=39$EN<W1A;&Q-;V1E#0HQ.#HP-#HU-2!3:&]W1&QG26YS
M=&%L;$UO9&4@.<F5T=7)N960Z(#$-"C$X.C T.C4U($EN<W1A;&Q-;V1E(#H@.
M,'@.Q#0HQ.#HP-#HU-2!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86QL
M36]D90T*,3@.Z,#0Z-34@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-#HU-2!N1G5L;$UA<VL@./2 P>&)F,# P,S<L(&Y#=7)R96YT(#T@.,'@.T
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#0Z-34@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9C0P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C T.C4U($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$X.C T.C4U($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ.#HP-#HU-2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z,#0Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z
M,#0Z-38@.1&EA;&]G(#!X,3 @.<F5T=7)N960Z(#$-"C$X.C T.C4V($5N9"!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ.#HP-#HU-B!3:&]W1&EA;&]G<T=E
M=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.R,"QI;F1E>#TU#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#(P#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ.#HP
M-#HU.2!%;F0@.06-T:6]N($1I86QO9U-H;W=39$QI8V5N<V4-"C$X.C T.C4Y
M($1I86QO9R P>#(P(')E='5R;F5D.B Q#0HQ.#HP-#HU.2!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#0Z-3D@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X-# P,# L:6YD97@.],3@.-"C$X.C T
M.C4Y($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$X
M.C T.C4Y($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,3@.Z
M,#0Z-3D@.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,3@.Z,#4Z,#,@.4VAO=T1L9T-L
M:65N=%-E<G9E<E-E;&5C="!R971U<FYE9#H@.,0T*,3@.Z,#4Z,#,@.5'EP92 Z
M(#!X,@.T*,3@.Z,#4Z,#,@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R
M#0HQ.#HP-3HP,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$X.C U
M.C S(&Y&=6QL36%S:R ](#!X8F8T,# S-RP@.;D-U<G)E;G0@./2 P>#0P,# P
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#4Z,#,@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9F,P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C U.C S($1I
M86QO9R P>#0P,# P(')E='5R;F5D.B Q#0HQ.#HP-3HP,R!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#4Z,#,@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# L:6YD97@.],3D-"C$X.C U
M.C S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X.# P,# -"C$X
M.C U.C S($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$EN<W1A;F-E3F%M
M90T*,3@.Z,#4Z,#,@.0F5G:6X@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE
M#0HQ.#HP-3HP."!%;F0@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE#0HQ
M.#HP-3HP."!3:&]W1&QG26YS=&%N8V5.86UE(')E='5R;F5D(#H@.,0T*,3@.Z
M,#4Z,#@.@.26YS=&%N8V5.86UE(#H@.0U-03#)+#0HQ.#HP-3HP."!%;F0@.06-T
M:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$X.C U.C X(&)E9VEN
M(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z,#@.@.;D9U;&Q-87-K(#T@.
M,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X.# P,# L(&Y$:7)E8W1I;VX@./2 Q
M#0HQ.#HP-3HP."!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F8S P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z,#@.@.1&EA;&]G(#!X.# P,# @.<F5T
M=7)N960Z(#$-"C$X.C U.C X($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ.#HP-3HP."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C$X.C U.C X($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P#0HQ.#HP-3HP."!"96=I;B!!
M8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U.C X($)E9VEN
M($%C=&EO;CH@.4V5T=7 @.5'EP90T*,3@.Z,#4Z-3(@.4U%,('!R;V=R86T@.9F]L
M9&5R.B!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ
M.#HP-3HU,B!344P@.9&%T82!F;VQD97(Z($0Z7%!R;V=R86T@.1FEL97-<36EC
M<F]S;V9T(%-13"!397)V97(-"C$X.C U.C4R(%=I;F1O=W,@.<WES=&5M(&9O
M;&1E<CH@.0SI<5TE.3E1<<WES=&5M,S)<#0HQ.#HP-3HU,B!0<F]G(')E<3H@.
M,S0W.#DL($1A=&$@.<F5Q.B S-#0S,BP@.4WES(')E<3H@.,3,R,38X#0HQ.#HP
M-3HU,B!0<F]G(&%V86EL.B Q-30S.3$R+"!$871A(&%V86EL.B Q-30S.3$R
M+"!3>7,@.879A:6PZ(#4U,C<S,S8-"C$X.C U.C4R(%!R;V<@.<F5Q('9S+B!A
M=F%I;"P@.-CDR,C$L(#$U-#,Y,3(-"C$X.C U.C4R($1A=&$@.<F5Q('9S+B!A
M=F%I;"P@.,S0T,S(L(#$U-#,Y,3(-"C$X.C U.C4R(%-Y<R!R97$@.=G,N(&%V
M86EL+" Q,S(Q-C@.L(#4U,C<S,S8-"C$X.C U.C4R($1I<W!L87E3>7-T96U0
M<F5297$-"C$X.C U.C4R(%M3971U<%1Y<&5344Q=#0HQ.#HP-3HU,B!S>D1I
M<B ]($0Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$X
M.C U.C4R('-Z1&ER(#T@.1#I<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,
M(%-E<G9E<@.T*,3@.Z,#4Z-3(@.4F5S=6QT(#T@.,S Q#0HQ.#HP-3HU,B!S>D1A
M=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R
M#0HQ.#HP-3HU,B!S>D1A=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HQ.#HP-3HU,B!%;F0@.06-T:6]N.B!3971U<"!4
M>7!E#0HQ.#HP-3HU,B!3971U<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HQ.#HP
M-3HU,B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U
M.C4R(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z-3(@.;D9U
M;&Q-87-K(#T@.,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER
M96-T:6]N(#T@.,S Q#0HQ.#HP-3HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P
M>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z-3,@.1&EA;&]G
M(#!X,3 P,# P(')E='5R;F5D.B S,#$-"C$X.C U.C4S($5N9"!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R#0HQ.#HP-3HU,R!3:&]W1&EA;&]G<T=E=$1I86QO
M9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.T,# P,# L:6YD97@.],C(-"C$X.C U
M.C4S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# P#0HQ
M.#HP-3HU,R!"96=I;B!!8W1I;VXZ("!$;&=397)V:6-E<PT*,3@.Z,#8Z,#$@.
M4VAO=T1L9U-E<G9I8V5S(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!;1&QG4V5R
M=FEC97-=#0HQ.#HP-CHP,2!,;V-A;"U$;VUA:6X)/2 V,38X, T*,3@.Z,#8Z
M,#$@.075T;U-T87)T"0D](#$U#0HQ.#HP-CHP,2!344Q$;VUA:6X)"3T@.0TA%
M3%-/1E0-"C$X.C V.C Q(%-13$1O;6%I;D%C8W0)/2!!9&UI;FES=')A=&]R
M#0HQ.#HP-CHP,2!344Q$;VUA:6Y0=V0-"C$X.C V.C Q($%G=$1O;6%I;@.D)
M/2!#2$5,4T]&5 T*,3@.Z,#8Z,#$@.06=T1&]M86EN06-C= D]($%D;6EN:7-T
M<F%T;W(-"C$X.C V.C Q($%G=$1O;6%I;E!W9 T*,3@.Z,#8Z,#$@.4F5S=6QT
M"3T@.,0T*,3@.Z,#8Z,#$@.16YD($%C=&EO;B!$;&=397)V:6 -E<PT*,3@.Z,#8Z
M,#$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ.#HP-CHP,2!N1G5L
M;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ.#HP-CHP,2!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D
M8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,#$@.1&EA;&]G(#!X
M-# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,3@.Z,#8Z,#$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X.# P,# P+&EN9&5X/3(S#0HQ.#HP-CHP,2!"
M96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#@.P,# P, T*,3@.Z,#8Z
M,#$@.0F5G:6X@.06-T:6]N.B @.1&QG4U%,4V5C=7)I='D-"C$X.C V.C,S(%-H
M;W=$;&=344Q396-U<FET>2!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S,@.3&]G:6Y-
M;V1E(#T@.,BQS>E!W9 T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!$;&=344Q396-U
M<FET>0T*,3@.Z,#8Z,S,@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-CHS,R!N1G5L;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS,R!5<&1A=&5D($1I86QO
M9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z
M,S,@.1&EA;&]G(#!X.# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR
M- T*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-
M"C$X.C V.C,S(%-H;W=$;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$X.C V
M.C,S(&-O;&QA=&EO;E]N86UE(#T@.4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#
M25]!4RQL;V-A;&5?;F%M92 ]($QA=&EN,5]'96YE<F%L+&QC:60@./2 P>#0P
M.2Q3;W)T260@./2 U,BQD=T-O;7!&;&%G<R ](#!X,S P,#$-"C$X.C V.C,S
M($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ.#HP-CHS,R!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C$X.C V.C,S(&Y&=6QL36%S:R ](#!X8F1C
M,# S-RP@.;D-U<G)E;G0@./2 P>#$P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M.#HP-CHS,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,S,@.1&EA;&]G(#!X,3 P,# P,"!R971U
M<FYE9#H@.,0T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$X.C V.C,S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C$X.C V.C,S($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,3@.Z,#8Z,S,@.0F5G:6X@.
M06-T:6]N.B @.1&QG3F5T=V]R:PT*,3@.Z,#8Z,S,@.4VAO=T1L9TYE='=O<FL@.
M<F5T=7)N960Z(#$-"C$X.C V.C,S(%M$;&=397)V97).971W;W)K70T*,3@.Z
M,#8Z,S,@.3F5T=V]R:TQI8G,@./2 R-34-"C$X.C V.C,S(%1#4%!O<G0@./2 P
M#0HQ.#HP-CHS,R!40U!0<GAY(#T@.1&5F875L= T*,3@.Z,#8Z,S,@.3DU04&EP
M94YA;64@./2!<7"Y<<&EP95Q-4U-13"1#4U!,,DM<<W%L7'%U97)Y#0HQ.#HP
M-CHS,R!297-U;'0@./2 Q#0HQ.#HP-CHS,R!%;F0@.06-T:6]N($1L9TYE='=O
M<FL-"C$X.C V.C,S(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z
M,#8Z,S,@.;D9U;&Q-87-K(#T@.,'AB9&,P,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C$X.C V.C,S(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X8F1C,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-CHS
M,R!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P,"QI;F1E>#TR
M-PT*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13
M=&%R=$-O<'D-"C$X.C V.C,T($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4W1A
M<G1#;W!Y#0HQ.#HP-CHS-"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-
M"C$X.C V.C,T(&Y&=6QL36%S:R ](#!X8F1C,# S-RP@.;D-U<G)E;G0@./2 P
M>#@.P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS-"!5<&1A=&5D($1I
M86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z
M,#8Z,S0@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S0@.
M16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C V.C,T(%-H;W=$:6%L
M;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP># L:6YD97@.], T*
M,3@.Z,#8Z,S0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<PT*,3@.Z,#8Z,S0@.0F5G
M:6X@.06-T:6]N(%!R;V-E<W-"969O<F5$871A36]V93H-"C$X.C V.C,T($1E
M:6YS=&%L;%-T87)T(')E='5R;F5D("A$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R7$U34U%,)$-34$PR2RDZ(# -"C$X.C V.C,T($5N
M9"!!8W1I;VX@.("!0<F]C97-S0F5F;W)E1&%T84UO=F4Z#0HQ.#HP-CHS-"!"
M96=I;B!!8W1I;VX@.4V5T5&]O;'-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP
M-CHS-"!#<F5A=&53971U<%1O<&]L;V=Y*$-34$PI+"!(86YD;&4@..B P>#$X
M.30Q-# L(')E='5R;F5D(#H@., T*,3@.Z,#8Z,S0@.0W)E871E4V5T=7!4;W!O
M;&]G>2!R971U<FYE9" Z(# L($AA;F1L92 Z(#!X,3@.Y-#$T, T*,3@.Z,#8Z
M,S0@.5&]P;VQO9WD@.5'EP92 Z(#$L(%)E='5R;B!686QU92 Z(# -"C$X.C V
M.C,T(%-47T=E=%!H>7-I8V%L3F]D92!R971U<FYE9" Z(# L(%!.2&%N9&QE
M(#H@.,'@.Q.#DT,38X#0HQ.#HP-CHS-"!03E]%;G5M97)A=&5%>"!R971U<FYE
M9" Z(# -"C$X.C V.C,T(%!.7T=E=%-13%-T871E<R!R971U<FYE9" Z(# L
M(%-Q;%-T871E<R Z(#!X,C(W#0HQ.#HP-CHS-"!03E]3=&%R=%-C86X@.6S!X
M,3@.Y-#$V.%T@.<F5T=7)N960@..B P#0HQ.#HP-CHS-"!03E]'971.97AT(%LP
M>#$X.30Q-CA=(')E='5R;F5D(#H@.,"P@.2&%N9&QE.B!;,'@.Q.#DU,#@.P70T *
M,3@.Z,#8Z,S0@.4U%,25]'9714>7!E(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.
M,"P@.;E1Y<&4Z(#!X,PT*,3@.Z,#8Z,S0@.4U%,25]'971);G-T86QL4&%T:"!;
M,'@.Q.#DU,#@.P72!R971U<FYE9" Z(# L(%!A=&@.@./2!$.EQ0<F]G<F%M($9I
M;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971$871A4&%T:"!;,'@.Q.#DU
M,#@.P72!R971U<FYE9" Z(# L($1A=&%0871H(#T@.1#I<4')O9W)A;2!&:6QE
M<UQ-4U-13#<-"C$X.C V.C,T(%-13$E?1V5T5F5R<VEO;B!;,'@.Q.#DU,#@.P
M72!R971U<FYE9" Z(# L(%9E<G-I;VX@./2 W+C P+C8R,PT*,3@.Z,#8Z,S0@.
M4U%,25]'971296=+97E2;V]T(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.,"P@.
M4F5G2V5Y4F]O=" ](%-O9G1W87)E7$UI8W)O<V]F=%Q-4U-13%-E<G9E<@.T*
M,3@.Z,#8Z,S0@.5&]O;',@.4&%T:#H@.(" @.($0Z7%!R;V=R86T@.1FEL97-<35-3
M44PW#0HQ.#HP-CHS-"!4;V]L<R!697)S:6]N.B @.-RXP,"XV,C,-"C$X.C V
M.C,T(%1O;VQS(%)E9VES=')Y.B!3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q3
M97)V97(-"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N
M960@..B Q."P@.2&%N9&QE.B!;,'@.P70T*,3@.Z,#8Z,S0@.1F]R8V4@.4'5R9V4-
M"C$X.C V.C,T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z
M(# -"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@.
M.B P+"!(86YD;&4Z(%LP>#$X.30V9CA=#0HQ.#HP-CHS-"!344Q)7T=E=$EN
M<W1A;&Q0871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.4 &%T:" ]($0Z
M7%!R;V=R86T@.1FEL97-<35-344PW#0HQ.#HP-CHS-"!344Q)7T=E=$1A=&%0
M871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.1&%T85!A= &@.@./2!$.EQ0
M<F]G<F%M($9I;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971697)S:6]N
M(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.5F5R<VEO;B ](#<N,# N-C(S
M#0HQ.#HP-CHS-"!344Q)7T=E=%)E9TME>5)O;W0@.6S!X,3@.Y-#9F.%T@.<F5T
M=7)N960@..B P+"!296=+97E2;V]T(#T@.4V]F='=A<F5<36EC<F]S;V9T7$U3
M4U%,4V5R=F5R#0HQ.#HP-CHS-"!03E]'971.97AT(%LP>#$X.30Q-CA=(')E
M='5R;F5D(#H@.,3@.L($AA;F1L93H@.6S!X,%T-"C$X.C V.C,T(%)E;&5A<V53
M971U<%1O<&]L;V=Y#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%-E=%1O;VQS0V]M
M<&]N96YT4V5L96-T:6]N.@.T*,3@.Z,#8Z,S0@.0F5G:6X@.06-T:6]N(%!R;V-E
M<W-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%!R
M;V-E<W-#;VUP;VYE;G1396QE8W1I;VX-"C$X.C V.C,T($)E9VEN($%C=&EO
M;B!,;V=396QE8W1E9$-O;7!O;F5N=',Z#0HQ.#HP-CHS-"!344Q0<F]G#0HQ
M.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R#0HQ.#HP-CHS-"!344Q0<F]G7%-1
M3%-E<G9R7$AE;' -"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<4T--1&5V
M#0HQ.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TUH#0HQ.#HP
M-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TU8.#9,8@.T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ344Q397)V<EQ30TU$979<4T--04QB#0HQ.#HP-CHS-"!3
M44Q0<F]G7%-13%-E<G9R7%)S,3 S,PT*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q3
M97)V<EQ2<TEN=&P-"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<06-T:79E
M6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q397)V<EQ3>7-T96T-"C$X.C V.C,T
M(%-13%!R;V=<4F5P;%-U<' -"C$X.C V.C,T(%-13%!R;V=<4F5P;%-U<'!<
M4F5P;$1A= T*,3@.Z,#8Z,S0@.4U%,4')O9UQ297!L4W5P<%Q297!#;VUM#0HQ
M.#HP-CHS-"!344Q0<F]G7%)E<&Q3=7!P7%)E<$YO1&L-"C$X.C V.C,T(%-1
M3%!R;V=<4F5P;%-U<'!<06-T:79E6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ);G-T
M86QL#0HQ.#HP-CHS-"!344Q0<F]G7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O
M9UQ3=G)%>'0-"C$X.C V.C,T(%-13%!R;V=<4W9R17AT7$AE;' -"C$X.C V
M.C,T(%-13%!R;V=<4W9R17AT7%-V<D5X=%)S#0HQ.#HP-CHS-"!344Q0<F]G
M7%-V<D5X=%Q297-);G1L#0HQ.#HP-CHS-"!344Q0<F]G7$1A= T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ$8713;7!L#0HQ.#HP-CHS-"!344Q0<F]G7$)A<V53>7,-
M"C$X.C V.C,T(%-13%!R;V=<0F%S94)I;FX-"C$X.C V.C,T(%-13%!R;V=<
M35-396%R8V@.-"C$X.C V.C,T(%-13%!R;V=<35-396%R8VA<2&5L< T*,3@.Z
M,#8Z,S0@.4U%,4')O9UQ-4U-E87)C:%Q!8W1I=F58#0HQ.#HP-CHS-"!344Q0
M<F]G7$)A<V5);G-T#0HQ.#HP-CHS-"!344Q0<F]G7%-Y;6)O;',-"C$X.C V
M.C,T(%-13%!R;V=<4WEM8F]L<UQ%6$4-"C$X.C V.C,T(%-13%!R;V=<4WEM
M8F]L<UQ$3$P-"C$X.C V.C,T(%-13%!R;V=<4&5R9FUO;@.T*,3@.Z,#8Z,S0@.
M4U%,4')O9UQ097)F;6]N7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O9UQ2;V]T
M#0HQ.#HP-CHS-"!-9W14;V]L#0HQ.#HP-CHS-"!-9W14;V]L7%-%30T*,3@.Z
M,#8Z,S0@.36=T5&]O;%Q314U<2%1-3 T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3@.-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4UE3#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q-4T0Y.%)E<PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3A(;' -"C$X.C V.C,T($UG=%1O;VQ<4T5-7$AE;' -"C$X.C V.C,T
M($UG=%1O;VQ<4T5-7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7%)E
M<TEN=&P-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4G-)#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q!8W1I=F58#0HQ.#HP-CHS-"!-9W14;V]L7%-%35Q!
M8W1I=F587%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$%C=&EV95A<
M4F5S26YT; T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<4V-R:7!T<PT*,3@.Z,#8Z
M,S0@.36=T5&]O;%Q314U<3TQ%1$(-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],
M141"7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],141"7%)E<TEN
M=&P-"C$X.C V.C,T($UG=%1O;VQ<4')O9FEL97(-"C$X.C V.C,T($UG=%1O
M;VQ<4')O9FEL97)<2&5L< T*,3@.Z,#8Z,S0@.36=T5&]O;%Q0<F]F:6QE<EQ2
M97,Q,#,S#0HQ.#HP-CHS-"!-9W14;V]L7%!R;V9I;&5R7%)E<TEN=&P-"C$X
M.C V.C,T($UG=%1O;VQ<47)Y86YL>@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q1<GEA
M;FQZ7$AE;' -"C$X.C V.C,T($UG=%1O;VQ<47)Y86YL>EQ297,Q,#,S#0HQ
M.#HP-CHS-"!-9W14;V]L7%%R>6%N;'I<4F5S26YT; T*,3@.Z,#8Z,S0@.36=T
M5&]O;%Q$5$-#3&D-"C$X.C V.C,T($UG=%1O;VQ<5WIC;F9L8W0-"C$X.C V
M.C,T($UG=%1O;VQ<5WIC;F9L8W1<5WIC;DAL< T*,3@.Z,#8Z,S0@.36=T5&]O
M;%Q7>F-N9FQC=%Q7>F-N,3 S,PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC
M=%Q7>F-N3W1H<@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC=%Q7>F-N0VUN
M#0HQ.#HP-CHS-"!-9W14;V]L7%5T:6Q3>7,-"C$X.C V.C,T($UG=%1O;VQ<
M571I;$)I;FX-"C$X.C V.C,T($-O;FYE8W0-"C$X.C V.C,T($-O;FYE8W1<
M0V]N;E-Y<PT*,3@.Z,#8Z,S0@.0F]O:W,-"C$X.C V.C,T($)O;VMS7$)O;VMS
M;PT*,3@.Z,#8Z,S0@.0F]O:W-<0F]O:W-O7%5T:6QS#0HQ.#HP-CHS-"!$9794
M;V]L<PT*,3@.Z,#8Z,S0@.1&5V5&]O;'-<1&)G($EN= T*,3@.Z,#8Z,S0@.1&5V
M5&]O;'-<1&)G($EN=%Q$8F<@.26YT($-O;6UO;@.T*,3@.Z,#8Z,S0@.1&5V5&]O
M;'-<1&)G($EN=%Q%6$4-"C$X.C V.C,T($-O<F5297!L#0HQ.#HP-CHS-"!#
M;W)E4F5P;%Q297,Q,#,S#0HQ.#HP-CHS-"!#;W)E4F5P;%Q297-);G1L#0HQ
M.#HP-CHS-"!#;W)E#0HQ.#HP-CHS-"!#;W)E7%)E<S$P,S,-"C$X.C V.C,T
M($-O<F5<4F5S3W1H97(-"C$X.C V.C,T(%)E<&]S=')Y#0HQ.#HP-CHS-"!2
M97!O<W1R>5Q297!S=%-Y<PT*,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R94UI<V,-
M"C$X.C V.C,T($-O<F5-:7-C7$%C=&EV95@.-"C$X.C V.C,T($-O<F5-:7-C
M7$%C=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.0V]R94UI<V-<06-T:79E6%Q2
M97-);G1L#0HQ.#HP-CHS-"!#;W)E36ES8UQ297,Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H#0HQ.#HP-CHS-"!-;VYA<F-H7$UO;G(Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H7$UO;G));G1L#0HQ.#HP-CHS-"!*970-"C$X.C V.C,T($-O<F5)
M;G-T#0HQ.#HP-CHS-"!#;W)E0T]-#0HQ.#HP-CHS-"!#;W)E0T]-7%)E<S$P
M,S,-"C$X.C V.C,T($-O<F5#3TU<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R951O
M;VP-"C$X.C V.C,T($-O<F54;V]L7%)E<S$P,S,-"C$X.C V.C,T($-O<F54
M;V]L7%)E<T]T:&5R#0HQ.#HP-CHS-"!$0DQI8D-L:0T*,3@.Z,#8Z,S0@.4T9%
M>'0-"C$X.C V.C,T(%-&17AT7$%C=&EV95@.-"C$X.C V.C,T(%-&17AT7$%C
M=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.4T9%>'1<06-T:79E6%Q297-);G1L
M#0HQ.#HP-CHS-"!31D5X=%Q297,Q,#,S#0HQ.#HP-CHS-"!31D5X=%Q297-)
M;G1L#0HQ.#HP-CHS-"!4<F%C90T*,3@.Z,#8Z,S0@.5')A8V5<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.5')A8V5<4F5S3W1H97(-"C$X.C V.C,T($UI<V-#;W)E#0HQ
M.#HP-CHS-"!-0PT*,3@.Z,#8Z,S0@.34-<34,Q,#,S#0HQ.#HP-CHS-"!-0UQ-
M0TEN=&P-"C$X.C V.C,T($U#7$AE;' -"C$X.C V.C,T(%-13$UG<@.T*,3@.Z
M,#8Z,S0@.4U%,36=R7%)E<S$P,S,-"C$X.C V.C,T(%-13$UG<EQ297-);G1L
M#0HQ.#HP-CHS-"!3=G)4;V]L#0HQ.#HP-CHS-"!3=G)4;V]L7%)E<S$P,S,-
M"C$X.C V.C,T(%-V<E1O;VQ<4F5S26YT; T*,3@.Z,#8Z,S0@.1%1354D-"C$X
M.C V.C,T($144U5)7%)E<S$P,S,-"C$X.C V.C,T($144U5)7%)E<TEN=&P-
M"C$X.C V.C,T($U33VQA< T*,3@.Z,#8Z,S0@.35-/;&%P7%)E<S$P,S,-"C$X
M.C V.C,T($U33VQA<%Q297-);G1L#0HQ.#HP-CHS-"!!5$P-"C$X.C V.C,T
M($%43%QW:6YN= T*,3@.Z,#8Z,S0@.051,7'=I;CEX#0HQ.#HP-CHS-"!-1D,T
M,E4-"C$X.C V.C,T(%9##0HQ.#HP-CHS-"!60@.T*,3@.Z,#8Z,S0@.4U%,061(
M;' -"C$X.C V.C,T(%-13$%D2&QP7%)E<S$P,S,-"C$X.C V.C,T(%-13$%D
M2&QP7%)E<T]T:&5R#0HQ.#HP-CHS-"![13 W1D1$0D4M-4$R,2TQ,60R+3E$
M040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.>T4P-T9$1$,W+35!,C$M,3%D
M,BTY1$%$+3 P0S T1C<Y1#0S-'T-"C$X.C V.C,T('M%,#=&1$1#,"TU03(Q
M+3$Q9#(M.41!1"TP,$,P-$8W.40T,S1]#0HQ.#HP-CHS-"![13 W1D1$0D8M
M-4$R,2TQ,60R+3E$040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.16YD($%C
M=&EO;B!,;V=396QE8W1E9$-O;7!O;F5N=',-"C$X.C V.C,T($)E9VEN($%C
M=&EO;B!);G-T86QL4&MG<SH-"C$X.C V.C,T($)E9VEN($%C=&EO;CH@.3&]C
M:V5D($-O;FYE8W1I=FET>2!&:6QE<R!#:&5C:PT*,3@.Z,#8Z,S8@.0V]N;F5C
M=&EV:71Y3&]C:V5D(')E='5R;F5D.B P#0HQ.#HP-CHS-B!4:&4@.;W!E<F%T
M:6]N(&-O;7!L971E9"!S=6-C97-S9G5L;'DN#0H-"C$X.C V.C,V($5N9"!!
M8W1I;VXZ($QO8VME9"!#;VYN96-T:79I='D@.1FEL97,@.0VAE8VL-"C$X.C V
M.C,V(%-E='5P(&ES(&EN<W1A;&QI;F<@.36EC<F]S;V9T($1A=&$@.06-C97-S
M($-O;7!O;F5N=',@.*$U$04,I("XN+@.T*,3@.Z,#8Z,S8@.7%Q#4U!,7 %-O9G1W
M87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<<W%L<F5D
M:7,N97AE("]Q.F$@.+T,Z(G-E='5P<F4N97AE(%=!4DX],2 M<R M4TU3(@.T*
M,3@.Z,#<Z,C @.17AI=$-O9&4Z(# -"C$X.C W.C(P(%-E='5P(&ES(&EN<W1A
M;&QI;F<@.36EC<F]S;V9T($1I<W1R:6)U=&5D(%1R86YS86-T:6]N($-O;W)D
M:6YA=&]R("A-4T140RD@.+BXN#0HQ.#HP-SHR," @.0SI<1$]#54U%?C%<041-
M24Y)?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<8VQD=&-S=' N97AE
M("U3=7!P;W)T1&ER(")#.EQ$3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q4
M96UP7%-Q;%-E='5P7$)I;B(@.+4140U!K9R B7%Q#4U!,7%-O9G1W87)E7$]T
M:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<9'1C<V5T=7 N97AE
M(B M3&]G1FEL92 B0SI<5TE.3E1<<W%L<W1P+FQO9R(-"C$X.C W.C(P(%!R
M;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ.#HP-SHR,"!);G-T86QL35-396%R
M8V@.@.:6YS=&%N8V4Z($-34$PR2PT*,3@.Z,#<Z,C @.4V]F='=A<F5<36EC<F]S
M;V9T7%-E87)C:%Q);G-T86QL.E9E<G-I;VX@.;F]T('!R97-E;G0-"C$X.C W
M.C(P($U34V5A<F-H(#(N,"!O<B!G<F5A=&5R('9E<G-I;VX@.8VAE8VL@.<F5T
M=7)N960@.+3$-"C$X.C W.C(Q(%-E='5P(&ES(&EN<W1A;&QI;F<@.=&AE($UI
M8W)O<V]F="!&=6QL+51E>'0@.4V5A<F-H($5N9VEN92 N+BX-"C$X.C W.C(Q
M(" B7%Q#4U!,7%-O9G1W87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8
M.#9<1G5L;%1E>'1<35-396%R8VA<4V5A<F-H7%-E87)C:%-T<"YE>&4B("]S
M("]A.E-13%-E<G9E<B1#4U!,,DL-"C$X.C W.C0U(%!R;V-E<W,@.17AI="!#
M;V1E.B H,"D@.#0HQ.#HP-SHT-2 @.+U$Z02 O5#I#.EQ$3T-5345^,5Q!1$U)
M3DE^,5Q,3T-!3%-^,5Q496UP7&EX<# P,2YT;7 -"C$X.C W.C0U(%-E='5P
M(&ES(&EN<W1A;&QI;F<@.2%1-3"!(96QP("XN+@.T*,3@.Z,#<Z-#8@.2%1-3"!(
M96QP(&EN<W1A;&QE<B!E>&ET(&-O9&4Z(# -"C$X.C X.C X($5N9"!!8W1I
M;VX@.26YS=&%L;%!K9W,-"C$X.C X.C X($)E9VEN($%C=&EO;B!-;W9E1FEL
M941A=&$Z#0HQ.#HP.#HP."!%;F%B;&5D(%-%3$9214=)4U1%4D)!5$-(#0HQ
M.#HP.#HP."!%;F%B;&5D($-/4D5#3TU03TY%3E1(04Y$3$E.1PT*,3@.Z,#DZ
M,# @.0F5G:6X@.06-T:6]N.B @.36]V949I;&5$871A4W!E8VEA; T*,3@.Z,#DZ
M,#$@.16YD($%C=&EO;CH@.($UO=F5&:6QE1&%T85-P96-I86P-"C$X.C Y.C Q
M($5N9"!!8W1I;VX@.("!-;W9E1FEL941A=&$-"C$X.C Y.C Q(%-E=%)E9D-O
M=6YT.B!#.EQ724Y.5%QS>7-T96TS,EQN='=D8FQI8BYD;&P@.*#4I#0HQ.#HP
M.3HP,2!"96=I;B!!8W1I;VX@.4')O8V5S<T%F=&5R1&%T84UO= F4Z#0HQ.#HP
M.3HP,2!<7$-34$Q<4V]F='=A<F5<3W1H97)S7%-13#(P,#!<1$5614Q/?C%<
M6#@.V7$)I;FY<:&AC;VPN97AE($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97)<.#!<5&]O;'-<0F]O:W,-"C$X.C Y.C R($5N9"!!8W1I
M;VX@.("!0<F]C97-S069T97)$871A36]V90T*,3@.Z,#DZ,#(@.0F5G:6X@.06-T
M:6]N($)U:6QD4V5R=F5R.@.T*,3@.Z,#DZ,#(@.0SI<1$]#54U%?C%<041-24Y)
M?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<<V-M+F5X92 @.+5-I;&5N
M=" Q("U!8W1I;VX@.-2 M17AE4&%T:" B1#I<4')O9W)A;2!&:6QE<UQ-:6-R
M;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DM<8FEN;EQS<6QS97)V<BYE
M>&4B("U397)V:6-E(")-4U-13"1#4U!,,DLB#0HQ.#HP.3HP,R!0<F]C97-S
M($5X:70@.0V]D93H@.*# I( T*,3@.Z,#DZ,#,@.0F5G:6X@.06-T:6]N.B!#<F5A
M=&5296=I<W1R>5-E=%-13 T*,3@.Z,#DZ,#,@.16YD($%C=&EO;CH@.0W)E871E
M4F5G:7-T<GE3971344P-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.4F5G5W)I
M=&53971U<$5N=')Y#0HQ.#HP.3HP,R!%;F0@.06-T:6]N.B!296=7<FET95-E
M='5P16YT<GD-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.0W)E871E4V5R#0HQ
M.#HP.3HP,R!%;F0@.06-T:6]N.B!#<F5A=&5397(-"C$X.C Y.C S($)E9VEN
M($%C=&EO;CH@.4VMU270-"C$X.C Y.C S($5N9"!!8W1I;VXZ(%-K=4ET#0HQ
M.#HP.3HP-"!3971&:6QE4V5C=7)I='E344Q!;F1!9&UI;B!F;W(@.1#I<4') O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DL@.
M<F5T=7)N960Z(# L(# -"C$X.C Y.C T(%-E=%)E9U-E8W5R:71Y4U%,06YD
M061M:6X@.9F]R(%-O9G1W87)E7$UI8W)O<V]F=%Q-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ#4U!,,DL@.<F5T=7)N960Z(# L(# -"C$X.C Y.C T($)E9VEN($%C
M=&EO;CH@.57!D871E4WES=&5M4&%T: T*,3@.Z,#DZ,#0@.4&%T:"!S=6-C97-S
M9G5L;'D@.=7!D871E9"X-"C$X.C Y.C T("5724XS,D1-25!!5$@.E7$))3CLE
M4WES=&5M4F]O="5<<WES=&5M,S([)5-Y<W1E;5)O;W0E.R53>7-T96U2;V]T
M)5Q3>7-T96TS,EQ78F5M.T0Z7%!R;V=R86T@.1FEL97-<35-344PW7$))3DX[
M0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L
M<UQ"24Y.#0HQ.#HP.3HP-"!%;F0@.06-T:6]N.B!5<&1A=&53>7-T96U0871H
M#0HQ.#HP.3HP-"!'<F%N="!2:6=H="!F;W(@.0TA%3%-/1E1<061M:6YI<W1R
M871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C T($=R86YT(%)I9VAT(&9O
M<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R;F5D(#H@.,2P@., T*,3@.Z
M,#DZ,#4@.1W)A;G0@.4FEG:'0@.9F]R($-(14Q33T947$%D;6EN:7-T<F%T;W(@.
M<F5T=7)N960@..B Q+" P#0HQ.#HP.3HP-2!'<F%N="!2:6=H="!F;W(@.0TA%
M3%-/1E1<061M:6YI<W1R871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C U
M($=R86YT(%)I9VAT(&9O<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R
M;F5D(#H@.,2P@., T*,3@.Z,#DZ,#8@.0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O
M9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L<UQ":6YN7&-N9F=S=G(N97AE(" M1B B
M0SI<5TE.3E1<<W%L<W1P+FQO9R(@.+4D@.0U-03#)+("U6(#$@.+4T@.," M42 B
M4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#25]!4R(@.+4@.@.,3DW,3(T("U5('-A
M("U0( T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C (R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(PT*#0H-
M"E-T87)T:6YG(%-E<G9I8V4@.+BXN#0H-"E-13%],871I;C%?1V5N97)A;%]#
M4#%?0TE?05,-"@.T*+6T@.+5$@.+50T,#(R("U4,S8U.0T*#0I#;VYN96-T:6YG
M('1O(%-E<G9E<B N+BX-"@.T*9')I=F5R/7MS<6P@.<V5R=F5R?3MS97)V97(]
M0U-03%Q#4U!,,DL[54E$/7-A.U!71#T[9&%T86)A<V4];6%S=&5R#0H-"EM-
M:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E<B!$<FEV97)=6U1#4"])4"!3;V-K
M971S74=E;F5R86P@.;F5T=V]R:R!E<G)O<BX@.0VAE8VL@.>6]U<B!N971W;W)K
M(&1O8W5M96YT871I;VXN#0H-"EM-:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E
M<B!$<FEV97)=6U1#4"])4"!3;V-K971S74-O;FYE8W1I;VY296%D("AR96-V
M*"DI+@.T*#0ID<FEV97(]>W-Q;"!S97)V97)].W-E<G9E<CU#4U!,7$-34$PR
M2SM5240]<V$[4%=$/3MD871A8F%S93UM87-T97(-"@.T*6TUI8W)O<V]F=%U;
M3T1"0R!344P@.4V5R=F5R($1R:79E<EU;5$-0+TE0(%-O8VME='-=1V5N97)A
M;"!N971W;W)K(&5R<F]R+B!#:&5C:R!Y;W5R(&YE='=O<FL@.9&]C=6UE;G1A
M=&EO;BX-"@.T*6TUI8W)O<V]F=%U;3T1"0R!344P@.4V5R=F5R($1R:79E<EU;
M5$-0+TE0(%-O8VME='-=0V]N;F5C=&EO;E)E860@.*')E8W8H*2DN#0H-"F1R
M:79E<CU[<W%L('-E<G9E<GT[<V5R=F5R/4-34$Q<0U-03#)+.U5)1#US83M0
M5T0].V1A=&%B87-E/6UA<W1E<@.T*#0I;36EC<F]S;V9T75M/1$)#(%-13"!3
M97)V97(@.1')I=F5R75M40U O25 @.4V]C:V5T<UU'96YE<F%L(&YE='=O<FL@.
M97)R;W(N($-H96-K('EO=7(@.;F5T=V]R:R!D;V-U;65N=&%T:6]N+@.T*#0I;
M36EC<F]S;V9T75M/1$)#(%-13"!397)V97(@.1')I=F5R75M40U O25 @.4V]C
M:V5T<UU#;VYN96-T:6]N4F5A9" H<F5C=B@.I*2X-"@.T*4U%,(%-E<G9E<B!C
M;VYF:6=U<F%T:6]N(&9A:6QE9"X-"@.T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(PT*#0HQ.#HP.3HS,R!0<F]C97-S($5X:70@.0V]D93H@.
M*"TQ*2 -"C$X.C$X.C(Y(%-E='5P(&9A:6QE9"!T;R!C;VYF:6=U<F4@.=&AE
M('-E<G9E<BX@.("!2969E<B!T;R!T:&4@.<V5R=F5R(&5R<F]R(&QO9W,@.86YD
M($,Z7%=)3DY47'-Q;'-T<"YL;V<@.9F]R(&UO<F4@.:6YF;W)M871I;VXN#0HQ
M.#HQ.#HR.2!!8W1I;VX@.0VQE86Y5<$EN<W1A;&PZ#0HQ.#HQ. #HR.2!#.EQ$
M3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q496UP7%-Q;%-E='5P7$)I;EQS
M8VTN97AE(" M4VEL96YT(#$@.+4%C=&EO;B T("U397)V:6-E(%-13$%G96YT
M)$-34$PR2PT*,3@.Z,3@.Z,CD@.4')O8V5S<R!%>&ET($-O9&4Z("@.Q,#8P*2!4
M:&4@.<W!E8VEF:65D('-E<G9I8V4@.9&]E<R!N;W0@.97AI<W0@.87,@.86X@.:6YS
M=&%L;&5D('-E<G9I8V4N#0H-"C$X.C$X.C(Y($,Z7$1/0U5-17XQ7$%$34E.
M27XQ7$Q/0T%,4WXQ7%1E;7!<4W%L4V5T=7!<0FEN7'-C;2YE>&4@.("U3:6QE
M;G0@.,2 M06-T:6]N(#0@.+5-E<G9I8V4@.35-344PD0U-03#)+#0HQ.#HQ.#HR
M.2!0<F]C97-S($5X:70@.0V]D93H@.*# I( T*,3@.Z,3@.Z,CD@.4W1A='-'96YE
M<F%T92!R971U<FYE9#H@.,@.T*,3@.Z,3@.Z,CD@.4W1A='-'96YE<F%T92 H,'@.R
M,C<L,'@.Q+#!X9C P+#!X,S P+#$P,S,L,S S+#!X,"PP>#$L,"PP+# -"C$X
M.C$X.C(Y(%-T871S1V5N97)A=&4@.+3$L061M:6YI<W1R871O<BD-"C$X.C$X
:.C(Y($EN<W1A;&QA=&EO;B!&86EL960N#0H`
`
end
You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand!
You the man! I was about to have a heart attack when i had uninstalled
our SQL Developer server and could not install Standard edition. Your
suggestion worked like a charm! Your advice is excellent even 6 months
later.
Blackened
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message537287.html

Problem in Insert in Table

Dear Friends
I have a table Which is giving problem for the Insert.
Insert ERROR:
Column Name or number of supplied values does not match table Definations
The same table is in replication. I have updated our Servicepack to 4 in
last w.
Please suggest how i can solve the problem.
Thanks and best regards
ShaileshYou have given less number of columns but included values for all the
columns
Post the query you used
Madhivanan|||hi sailesh
there might be difference between the columns and values passed in the
insert query..
eg:
INSERT INTO <TABLE>(ID, Name) VALUES (1, 'Chandra', 28)
please post the query so that we can give a better solution
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***

Problem in Insert

Dear Friends,
I am having one table which is giving problem while inserting the records
which is as follows:oops! u missed to explain ut problem
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***

Problem in form Authentication

Dear All,
I have problem while calling my report from report server using URL METHOD.
we have config'red our reporting service using forms Authentication.
(so we have login page)
My problem is i have to call the report, using URL METHOD, by supressing
that login page
why becos, some Credentials i will get it from my aplication.
Pls guide me how to supress and call the report from codebehind using URL
METHOD.
Million of Thanx in advance
Gopal PrabhakaranYou need to Logon to the Report Server using the LogonUser() WebService
method

Problem in Adding column in table

Dear Friends
I am getting the following problem while adding a column
in the replication table.
Please suggest.
Problem:
Code:
sp_repladdcolumn [ @.source_object = ] 'OTHALLOCATION'
, [ @.column = ] 'CCICAPPNUM' ]
[ , [ @.typetext = ] 'NVARCHAR(50)' ]
[ , [ @.publication_to_add = ] 'GEMREPLGNETINFOTECH' ]
[ , [ @.schema_change_script = ] 'NVARCHAR(1000)' ]
[ , [ @.force_invalidate_snapshot = ]
force_invalidate_snapshot ]
[ , [ @.force_reinit_subscription = ]
force_reinit_subscription ]
Your earlier reply would be a great help.
Best regards
Sharad
Did you forget to paste the error message?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Sharad" <niitmalad@.yahoo.co.in> wrote in message
news:06dd01c48b52$703f6b00$a501280a@.phx.gbl...
Dear Friends
I am getting the following problem while adding a column
in the replication table.
Please suggest.
Problem:
Code:
sp_repladdcolumn [ @.source_object = ] 'OTHALLOCATION'
, [ @.column = ] 'CCICAPPNUM' ]
[ , [ @.typetext = ] 'NVARCHAR(50)' ]
[ , [ @.publication_to_add = ] 'GEMREPLGNETINFOTECH' ]
[ , [ @.schema_change_script = ] 'NVARCHAR(1000)' ]
[ , [ @.force_invalidate_snapshot = ]
force_invalidate_snapshot ]
[ , [ @.force_reinit_subscription = ]
force_reinit_subscription ]
Your earlier reply would be a great help.
Best regards
Sharad
sql

Problem in a derived column

Dear Friends,

I have an derived column in an ETL, that use the DateDiff function.

The experssion of the derived column is:

DATEDIFF("d",RKData,MaturityDate) / 365

The problem is that the result always come as an integer, and in fact the result of the expression usually has decimal numbers.. :-(

I defined the new colum of derived column as doube-precison float [DT_R8]....

Someone help me?

Thanks!

PedroCGD wrote:

Dear Friends,

I have an derived column in an ETL, that use the DateDiff function.

The experssion of the derived column is:

DATEDIFF("d",RKData,MaturityDate) / 365

The problem is that the result always come as an integer, and in fact the result of the expression usually has decimal numbers.. :-(

I defined the new colum of derived column as doube-precison float [DT_R8]....

Someone help me?

Thanks!

Try:
(DT_NUMERIC,7,4)DATEDIFF("d",RKData,MaturityDate) / (DT_NUMERIC,7,4)365

That should give you 4 decimal places. Adjust the precision and scale accordingly, if you need.|||

THANKS!!

I changed to (DT_NUMERIC,7,2)DATEDIFF("dd",RKData,MaturityDate) / (DT_NUMERIC,7,2)365 and it works!!

Thanks!!!!!!

Problem in a CROSS to SQL

Dear friends;

I have a CROSS table in ACCESS that I want to export to SQL 2005. The query is:

TRANSFORM Count(GD_PROFILE.cnRow) AS CountOfcnRow

SELECT GD_PROFILE.ID

FROM GD_PROFILE

GROUP BY GD_PROFILE.ID

PIVOT GD_PROFILE.ID_APLIC;

The RESULT is:

ID

20

22

77

122

141

179

211

327

334

370

388

405

524

584

645

687

826

865

914

CN1

1

1

1

1

1

CN2

1

1

1

1

CN3

1

1

1

1

CN4

1

1

1

1

1

CN5

1

1

1

1

CN8

1

1

1

1

1

1

1

1

1

1

1

CN14

1

1

1

1

1

1

1

1

CN15

1

1

1

1

1

1

1

1

1

1

CN22

1

1

1

1

1

1

1

1

CN29

1

1

1

1

1

1

1

CN36

1

1

1

I want to create a query in SQL Server that give me rows from the cross query that are equal. For example, the row 1 and 4 are equal. Has the same values in each row. How can I make it programatically?

The Cross is a simple cross query, and the goal is return this final result:

Profile 1 - ID CN1, ID CN4

Profile 2 - ID CN2, ID CN3, ID CN5

Profile 3 - ID CN8

Profile 4 - ID CN14

Profile 5 - ID CN15

Profile 6 - ID CN22

Profile 7 - ID CN29

Profile 8 - ID CN36

Could you HELP me?
THANKS!!!!

HELP me please!!!!

I need it soon!!

Thanks!!!!!!!

|||

--For SQL Server 2005:

SELECT ROW_Number() OVER(ORDER BY (pvt.[1] + coalesce(', ' + pvt.[2], '') + coalesce(', ' + pvt.[3], ''))) AS Profile,

pvt.[1] + coalesce(', ' + pvt.[2], '') + coalesce(', ' + pvt.[3], '') as merged

FROM(SELECT ID, ROW_Number() OVER (PARTITION BY coalesce (',' + [F2] , '-') + + coalesce(',' + [F3], '-') + coalesce(',' + [F4], '-' ) + coalesce(',' + [F5], '-') + coalesce(',' + [F6], '-' ) + + coalesce (',' + [F7] , '-') + coalesce(',' + [F8], '-') +coalesce(',' + [F9], '-') + coalesce(',' + [F10], '-' ) + + coalesce (',' + [F11] , '-') + coalesce(',' + [F12], '-') + coalesce(',' + [F13], '-') + coalesce(',' + [F14], '-' ) + + coalesce (',' + [F15] , '-') + coalesce(',' + [F16], '-') +coalesce(',' + [F17], '-') + coalesce(',' + [F18], '-') + + coalesce( ',' + [F19], '-') + coalesce (',' + [F20] , '-') ORDER BY ID) AS rowNum_ID,

coalesce(',' + [F2], '-') + + coalesce( ',' + [F3], '-') + coalesce (',' + [F4] , '-') + coalesce(',' + [F5], '-') + coalesce(',' + [F6], '-' ) + + coalesce (',' + [F7] , '-') + coalesce(',' + [F8], '-') + coalesce(',' + [F9], '-') + coalesce(',' + [F10], '-' ) + + coalesce (',' + [F11] , '-') + coalesce(',' + [F12], '-') + coalesce(',' + [F13], '-') + coalesce(',' + [F14], '-' ) + + coalesce (',' + [F15] , '-') + coalesce(',' + [F16], '-') + coalesce(',' + [F17], '-') + coalesce(',' + [F18], '-') + + coalesce( ',' + [F19], '-') + coalesce (',' + [F20] , '-') AS newlabel

FROM yourTable) as t1

pivot (min(ID) for rowNum_ID in ([1], [2], [3]))AS pvt

ORDER BY pvt.[1] + coalesce(', ' + pvt.[2], '') + coalesce(', ' + pvt.[3], '')

CREATE TABLE yourTable(

[ID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F4] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F5] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F6] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F7] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F8] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F9] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F10] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F11] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F12] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F13] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F14] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F15] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F16] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F17] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F18] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F19] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[F20] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN2',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN3',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN4',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN5',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN8','1','1',NULL,'1','1',NULL,NULL,NULL,NULL,'1','1',NULL,NULL,'1','1','1','1','1',NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN14','1','1',NULL,'1','1',NULL,NULL,NULL,NULL,'1','1',NULL,NULL,'1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN15','1','1','1','1','1',NULL,'1',NULL,NULL,'1','1',NULL,NULL,'1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN22',NULL,'1',NULL,NULL,NULL,'1',NULL,NULL,'1','1',NULL,'1','1','1',NULL,NULL,'1',NULL,NULL)

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN29','1','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'1',NULL,'1',NULL,NULL,'1',NULL,'1')

INSERT INTO [yourTable] ([ID],[F2],[F3],[F4],[F5],[F6],[F7],[F8],[F9],[F10],[F11],[F12],[F13],[F14],[F15],[F16],[F17],[F18],[F19],[F20])VALUES('CN36',NULL,NULL,NULL,'1',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL)

|||

Dear Friend!

First of all I want to thank your help.

The Grid above is a result of a CROSS query based in this table:

ID

ID_APLIC

CN1

826

CN1

584

CN1

524

CN1

370

CN1

22

CN2

826

CN2

584

CN2

370

CN2

22

CN3

826

CN3

584

CN3

370

CN3

22

CN4

826

CN4

584

CN4

524

CN4

370

CN4

22

CN5

826

CN5

584

CN5

370

CN5

22

CN8

865

CN8

826

CN8

687

CN8

645

CN8

584

CN8

388

CN8

370

CN8

141

CN8

122

CN8

22

CN8

20

CN14

826

CN14

584

CN14

388

CN14

370

CN14

141

CN14

122

CN14

22

CN14

20

CN15

826

CN15

584

CN15

388

CN15

370

CN15

211

CN15

141

CN15

122

CN15

77

CN15

22

CN15

20

CN22

826

CN22

584

CN22

524

CN22

405

CN22

370

CN22

334

CN22

179

CN22

22

CN29

914

CN29

826

CN29

584

CN29

405

CN29

370

CN29

22

CN29

20

CN36

584

CN36

327

CN36

122

What I want is to check the CN (Computernames) that have the same profile. Example, I know that CN1 and CN4 has the same aplications, the profile one.

For each CN I need to know if the profile for this CN already exists, if true insert the reference in Computername Table, and if false, create new Profile in table Profile and the aplicationIDs in Profile_AplicID Table.

Profile

ID_Profile

Nome

1

Profile 1

2

Profile 2

3

Profile 3

4

Profile 4

Profile_AplicID

AplicID_Profile

ID_Profile

22

1

370

1

524

1

584

1

826

1

Computername

CN_ID

ID_Profile

CN1

1

CN4

1

…

…

COULD YOU HELP ME?!!
THANKS FRIEND!!!

|||

Anyone need more help to understand my problem?
Thanks!!!

|||Anyonne there?