Querry time on upsized SQL Server Database "Mark Jarzebowski" <bms[ at ]bms.com.au> 29.09.2006 04:25:50 Hi All, Just wanted to share a problem I had to solve recently. Access 2000 database that had the backend upsized to SQL Server 2000. A query that was looking for a specified time in a date time field with the parameter [TranTime] = #06/06/2006# This query found the time correctly in access but would return nothing after conversion to SQL Server. The solution: change the parameter to [TranTime] = TimeValue('06/06/2006') Regards ...Mark Mark Jarzebowski Jnr. Vice President Coordinator Skills Development Coordinator Business Development Victoria.NET www.victoriadotnet.com.au mark[ at ]vdnug.org Mark Jarzebowski - Director, Software Engineering Business Model Systems (Vic) Pty Ltd Kew VIC Australia Email: bms[ at ]bms.com.au Web: www.bms.com.au Software Development for Windows and the Web Visual Basic, C#, ASP, SQL Server, Access, MS Office Quality Software fast, inexpensive and guaranteed. begin 666 image001.gif M1TE&.#EA"[ at ]%7`-4``/___Q)6B"0[ at ](?S[_/[^_^OP]?S]_OO\_?CY^[ at ]!+B0Y2 MBP!/C!%5B1Q=C29DDD!YH\/5XP!4CP=8D[ at ]U=E!1AEQ-7B!99B1UGG"UNG52) MKW.=NY&TS;'&U=+[ at ]ZM_I\/7X^O'U]_G[_#=H>OW^_EZ88/S]_/K]^('#1)7- M8:34=[;<DLCEK=;KPN7SV.SVXOW^_/+XZOG\]??[\/S]^O[^_?G56?[IOOK0 MD=W<VU),1_*::IJ8F'1S<]+1T>?GY____R'Y! $``#\`+ `````*`5<```;_ M0(!P2"P:C\BD<LEL.I_0J'1*K5JOV*QVR^UZO^"P>$PNF\_HM'K-;KO?\+A\ M3J_;[_B\?L_O^_^ [ at ]8*#A(6&AXB)BHN,C8Z/D)&2DY25EI>811 ;F9V5'!J> M32PI*"DLHE8N*BDI*C)CH$P[.T*T/3U2'#PX/GTJ)\'!*H$$;BW"P2[ at ]P8K)+ M/ ([ at ]( *\/0,[' ,].SZT`-T<!-T]/CFT/!RY>2S)PJAX(9L:&?3T&AP>:3$H M[2<IS:&6[,C![ at ]8,Y#K1VH#/'0Z%#7[ at ]US]""H,)V>%/U.$+,#08.#"[ at ]%"BA39 MX,&&`F;8960&QIF2<PW1*12"[ at ]P> '-\88K.9L,"V_STO^/7[1P="AI%(DP9P MH $$&97]6H1QF83'1'0-%6Z;:757NI[ at ]^L/KHP<.8[ at ]0*^[ [ at ]=NL+%C#<?-"B= MBQ0#!S$N,&9T,36[ at ]$[ at ]X^TN'8[ at ]8LLCVX`#'?C<=BA[ at ]1T%"J#+F6. G1495ZQ0 M[ at ]0*%BA4LTW1X0+?T2 W&N,!840I8/Q0O^GZQO,2'`)QV8N[ at ]51A1 C!:L3*U[ at ] M$<,,! >FDX?T>V5UJ10KBD,5)E4V% ,[ at ]$ [ at ]IK,0'CN_[ at ]O_>X'1ZEG!B<3WA^ M:P0&"\["6[#_`J&!\OL:1E1Q_YQ%:"&D=)9"==8][ at ]8,Y!>0[ at ]P((YI#4$`[ at ],M M*.&$%)I3"QTFN&!"$RVP9O^*"OYUX0%RIE5[ at ]04[ at ]G!F!!BDDQYX0,`4+'5Q(P MP$(&54V,QX.".8C H%-"# `--3LRF,.1"A*Y`PBT&3)#A\^!N.$1$'"P[ at ]08: M0*!$"$>99M<F&Y#X0)=*W=6$"3&V10>.3(RW8 98:K"[ at ]F0! TZ 0"-BIPYXZ MW!8)C,%!1R `!=[ at ]G$IU';% :![ at ]XX8!X`'8CT``1T.:H$FIS)> >;2[AIT[ at ]:[ at ] M^GBA;0*H(P2I.MQP0Y^53?*""QYZYA\$"RC 0 `-Y(.$!X8JU50'B)*V' `: M](J4BT+$\)YP,^+!J1)N[ at ]BHM-!?NX&<1"NY[ at ][ at ]PTWW-8D);_%2H((%BC[ at ][ at ]!)R M*67_`2=4>A2 F60BE>L0)[ at ]#7V0J#YO%L$N,15! '$% KQ)!((KG[ at ]#C+ [ at ](.W MBB [ at ]C79,%) !"22<0+$+L1E1Z%P9+.&!!N8IJA0#&I1[ at ]KV?Y%G% =EV$\,$' M(>B";*>W06 S!!U8>R'!!2.I3[ at ]$,>Q$GEEH.\7&<2%PY]*-([ at ]()!`PU[ at ]D&42 M'M#3[ at ] (!B$"Q>B#^)W)2#NCJ1 <8C.Q 9RKDVU&<=W'P0 .($J$TEAM 3/4& M&3S0* 89;" V$_LBT:\''13N[ at ]<X#WU9##3=L&X,/34[3JA=EB\1<N[ at ]',/$+E M(3D`Y!$2SZ7!`50BQ8 ""E[ at ][ at ]0G"RRA!O`%)#P+03(& ^_Q(#'$Q91+SWB%1T M$1M+JA\2!Q0[EP-Q)Q$X$1#W^X$T((2 . #6YK!XXS:\[ at ] ,1MDW>A>T/&"!$ M`22&?<2((SV0! C"BI[H7 PX(+Y[\#5P*ZX[ at ]6P&"L98?,4+[F3/4O(P``19E M+[ at ]G%,TT#.M"$Y5&F%OTJ`[ at ]>HD; )"N!ZVY+!D=+2O=1T[ at ]0,C:4#(^E>ZTR3! M=B$QE[ at ]7^)[ at ]2/&*L"C<J ^(C `:RIZ'=6V #_`I"!X1&!?"*Q`(E[ at ]]X$C[ at ]' D M['K?2/H&P `D\2\S*\*0!/"=:PW!6CS0S IXQ+AM50](I'(0%W[ at ]U$[ at ]9^H'(# M-,(11?)$(G3 [ at ] [ &0#;" `#C/\[ at ]7A[ at ]XP PE**DMH)"(1O `BT#2QR.[ at ]$(<2 MG(<#UB6$#Q[ at ]KBHEDPA1[L##<7/$V%"-!DJ[ at ]1H5(-80`\HL7VN#!'`*P1DH=$ M`[ at ]K9)3('8(".`#CC$I/PM3AJX0--K,#L3)D4DP`,"?%:(1,^`+""Z-"$[ at ](/D M$-Q4E[ at ][ at ]2P5H4BJ9$BG [ at ]"27O"K8+A;#2:(1X<9,(`!2A$#S [ at ]0X4H(CG,Q8L M6YB^+:Q1)+O\6D[ at ]>$#,E< YVGSM"!S2[ at ]-[JL,Y),\(XQ$$!)X!7FH <=I1$( MBHM\9N&=DR(D) ]P3PR[ at ]LPC[2Q_IG$"ID2"2"+;[IQ0R.I)=ONZ:/S16!CQ8 MA!%H[ at ])#_I?FH$95I"#)VKGT,W)5*=3K+)\C3`CDU)#*SL#FDS.Y_([&4$B ` MTP.J4E[W\"8+FT;30A0U*1U+`E.'"KR="L%*$' H2),JUB'(4WU:$.1(+# [ M(!92"?)T(A(B-1(,Y#1>#F"I\JI:B#\&0*9F10I*"3#$I:#$I[ at ][(JA'"V8&S M&#&$4R6"7N%:EXL*H0--K6HJE<C&<7HUF9%X9T[ at ]4^]0RGA I#W 7"1>+% >D MMH2',[ at ](Q-_ `DT2VI4U<*1^1R(1XZ3)IJ"5<$_EJ2N(.PJ8AJ0![ at ]AQ#.70[A MC:51:C=]!;HAF[ at ]\`J8' /9=REZ"JL45&V"P"*UK/[R+%[ at ])UM_Z!Q!8$``)+6 M?X5][ at ]-TXFY0&+%>T(;DF`<B$`0[ at ]0``)CTL!VYXDW)(2[ at ]B>^:;A!O.X0"-/6] M1#BP4C+05)2JL:H[ at ]B(R&-\SA#FNXK$<`L17BM=S+([ at ]7":ASP`[QKQ'LN$+AU MW>%YH2;3CB;5L[ at ]`(06$]MP31*M,#`'3 !FR<7R<X, ,42+*2E\SD)B?9HI+U M``N![ 4/W P"/D0""*X,`0;_$!1TPW(3MGPS![ at ]?O/BFL`%J+\$=D'8#++ 8= ME[T<2S#C`P!DOIES9]K;"/CYSX .M*#]G( G4O0!+-7 !5*Q!+_>)QRQ% +[ MY$5G/AQYT)C&] *[ at ]+(0#[ at ]&J/!: `!O\8K03DHCF%<&)*!AK05*<:XM*9CC6[ at ] M$] V1($*`!M(P*A)3<M3GUJZA8"UK&6]Z?V25[ at ],;^, %-LWK)$C8UW5U+?\L M# AA#SO6M(Z,$#8AA%Q'8-?-KBZT)56 `P!PO7JP]K4UO68`(" ?(%CVM\.= MA X4UM?XZ%4/%:'N=0]Z`45[7K<3X&=PTYN ]T9S`X:8[ at ]?D>HM_^#O0".E: MVAX[ at ]!/*>]\'GBF!?H]O25<U Q(<-[ at ]0_0[ at ]P#>+OC&UZ<!]-['+HZ ^,C_G(". MD4[9"_BSP5=.P->9ABE[?GC(9R[KG*9<Y3Q?JFKI8I*[ at ](^+2!/_S`J:>\Y$G M(!0AP$#5D9[_="448!/TJ.V8\N:!+"/A/2H`$1& \QD:) 'M:8][VE>[ at ].R*[ at ] M1^YX7\%\U-O;"V1[ at ]`G[>] ,P\("MTUS6$B[ at ]`!Z*N\ZY?IYY GNP1=G."X[ at ]C! M-2A0`N7;[ at ]8(2' $9&5&&VY]PY%%G[ at ]."T!A4$&.]G"FA UC4O?*!W[O[ at ]G8*#2 M-%C+"58P!+ULY [ at ]ET'T[>E.$Z0PE"D>F-0>F?[ at ]$/4. "A5^ !"[ at ]P[ at ]9H7`/ Y MI_[6)2"!"% [ at ]`M/_OL9K'X4,E#A9G"^."83">R3 (!FMB/\ISMX9W=?_':0/ M^:8/<(&KYWH#BY<!4M8!%Z E$# !$X /!9!KYG<TR]=EY"1JY"<%_\C&!*"7 M#+SW?L&0,D-P[ at ]2?P!"5[ at ]`B4P'2U0`GMG9$,'<+E&-H4&`1=[ at ]<J+F>A[0?P4A M:B `)P<V`4.V:<]W[ at ][0W[ at ]3V&8L7W&[ at ]!P[ at ]39R!%"!`BW[ at ]`DS8+$J &<IP[ at ]OG7 M9S7W,8M7:*#0`0DP=56X`!2 2PG0[ at ]O<0AD-V=55B<C\(A,J36%.#!)BW%BP` MA2A0=T7[ at ]&AEA>9HG#)E'!<+F`6"(A1J[ at ]A1&P`%U(`>Q#B !X#XC(`1E0`![ at ][ at ] M`563AFH87B-1`>OD>U#H#ZY!?$:P>7J8,4F0>\+P>S+39Q%P=1Y :$-V`?NU M:7YW?1-0)0MP`1*CB(#H`;-X`!D[ at ]B9,X!/_X]5=&L'[!$!T908I%$!2AQXE' M( -KT7Y3`&NSF $YMP``B(I2A[ at ]$4(&4/0 %=U[ at ]&YAFQ3!RH44#[ at ]VLXN]J 3[ M-6%&( /4`0!V* S.: 0ND PLT +VV +_[ at ]00>R($H:(J"AH"#*&H7T'J/F',8 M(&\`&0$(*'T8, '<QXN]*$N]9 07R P:F S\" !)* 73D8]0X$"%$Y)<9C/D M.))7%I(=<#,BJ9+GF 0&T'$0)H>6]XZ5EP29B ):I$5.> 1V.(=5X$ ``"8` M6 0A8"7>6&^J]UQ#V9)-$%<A04>;. 3SJ(>CQY.A%PSXAP2[H8P?R5=N`R>3 M`BG=E5IC`BP>H'CJA,,!!M 1OI0/\W![*6EV3$D$DY8^. 8`OD<$=LB5O7>5 M)^"11""*PV %0$DL`$-X`D8!?L,W]L"8R(:-H6 48/D!M/5*%Z"#<YD$!>!" M0&<$^S",:P>/22",H>>3--*,A$E<]P`*&T!X``AD'0!D8#EJ'' !0PE[ at ]ZG-[ MR*8!$_!*U):9!= !(/8J]HB'0N "]GB$1D #]]B<][B31O D]TB'R$=<`"B4 M]( /'?,Q>8,EJ34/G !FJ34">),!C&B>F9F>ZKF>[-F>[OF>\!F?\CF?]%F? 7]GF?^)F?^KF?_-F?_OF?`!J[ at ]D1 $`#L` ` end