|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
sql/vb statement help
Heres my vb code
Dim sql As String = "SELECT P_Name, C_PeriodTo from PROPOSER, POLICY where DATEDIFF(DD, GETDATE(), C_PeriodTo)>1 AND DATEDIFF(DD, GETDATE(), C_PeriodTo)<28 AND P_RegnNo=C_RegnNo" However, the result is different from what I get using Sql Query Analyzser. May I know if there is any special characters in the code that might be causing the difference? |
|
#2
|
|||
|
|||
|
I originally wrote a bunch more, but now that I'm looking:
====================== AND P_RegnNo=C_RegnNo" ====================== These are not in the select statement. So the numbers are not going to match I believe. There will never be an equals? Do you not have to select these to be able to parse them? Hope it helps! Last edited by emladris : October 1st, 2003 at 09:54 AM. |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > .Net Development > sql/vb statement help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|