> Date

Hello, everybody,
Can somebody tell me how I can query a field that has a date >1/1/2000?
I don't want to be specific using a BETWEEN clause.
Thanks,
AntonioI used this:
WHERE (dbo.ContrInfo.Reqd BETWEEN CONVERT(DATETIME, '2000-01-01
00:00:00', 102) AND GETDATE())
Thanks
"Antonio" wrote:

> Hello, everybody,
> Can somebody tell me how I can query a field that has a date >1/1/2000?
> I don't want to be specific using a BETWEEN clause.
> Thanks,
>
> Antonio|||Select * from mytable where date = '1/1/2000'
"Antonio" wrote:

> Hello, everybody,
> Can somebody tell me how I can query a field that has a date >1/1/2000?
> I don't want to be specific using a BETWEEN clause.
> Thanks,
>
> Antonio|||Antonio wrote:

> Hello, everybody,
> Can somebody tell me how I can query a field that has a date
> I don't want to be specific using a BETWEEN clause.
> Thanks,
>
> Antonio
Like this:
Select * from Table where DateColumn > '2000-01-01'
HTH,
Stijn Verrept.|||Because of the Time portion of a DateTime column, you need to specify a
duration.
And... always use a date format that won't confuse the database.
declare @.dateSearched datetime
set @.dateSearched = '20000101'
...where yourColumn >= @.dateSearched and yourColumn < dateadd(d, 1,
@.dateSearched)
If you insist on converting the column: CONVERT(DATETIME, '2000-01-01
00:00:00', 102) AND GETDATE())
check the query plan of both your solution and mine.
SQL may not be able to use indexes on that column if you use Convert.
What I gave you is the "standard" way of doing this.
"Antonio" <Antonio@.discussions.microsoft.com> wrote in message
news:F637849A-A907-4EA8-8C56-C30C3625642E@.microsoft.com...
> Hello, everybody,
> Can somebody tell me how I can query a field that has a date >1/1/2000?
> I don't want to be specific using a BETWEEN clause.
> Thanks,
>
> Antonio

#Error on access to NON custom assembly

Hi!
I am trying to access the dll called Microsoft.SharePoint.dll and the the
specific class Microsoft.Sharepoint.Utilties.SPEncode but when deploying I
get the same error as everyone else in this newsgroup.
Since I am not using my own Dll I have a hard time adding some of the stuff
required. Does anybody have an idea of how to access these "common"
dll?(everything is fine in design mode)
Calling the function like this
=Microsoft.SharePoint.Utilties.SPEncode.HtmlDecode(fields...)
BR,
ErikI'm getting the same problem just using System.Web... In Visual Studio it
works fine (I'm using System.Web.UrlEncode) but I get #Error on the
webserver!?
System.Web should be in the GAC so I don't see why its causing a problem?
cheers,
Simon
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:47FE8F2D-5EA3-4DAA-A579-AF908B11D036@.microsoft.com...
> Hi!
> I am trying to access the dll called Microsoft.SharePoint.dll and the the
> specific class Microsoft.Sharepoint.Utilties.SPEncode but when deploying I
> get the same error as everyone else in this newsgroup.
> Since I am not using my own Dll I have a hard time adding some of the
stuff
> required. Does anybody have an idea of how to access these "common"
> dll?(everything is fine in design mode)
> Calling the function like this
> =Microsoft.SharePoint.Utilties.SPEncode.HtmlDecode(fields...)
> BR,
> Erik|||Found an answer -
Go to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
Edit web.config
Change
<trust level="RosettaSrv" originUrl="" />
to
<trust level="Full" originUrl="" />
"Anonymous Poster" <anon@.microsoft.com> wrote in message
news:uV9uVaFiFHA.3164@.TK2MSFTNGP15.phx.gbl...
> I'm getting the same problem just using System.Web... In Visual Studio it
> works fine (I'm using System.Web.UrlEncode) but I get #Error on the
> webserver!?
> System.Web should be in the GAC so I don't see why its causing a problem?
> cheers,
> Simon
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:47FE8F2D-5EA3-4DAA-A579-AF908B11D036@.microsoft.com...
> > Hi!
> > I am trying to access the dll called Microsoft.SharePoint.dll and the
the
> > specific class Microsoft.Sharepoint.Utilties.SPEncode but when deploying
I
> > get the same error as everyone else in this newsgroup.
> >
> > Since I am not using my own Dll I have a hard time adding some of the
> stuff
> > required. Does anybody have an idea of how to access these "common"
> > dll?(everything is fine in design mode)
> > Calling the function like this
> > =Microsoft.SharePoint.Utilties.SPEncode.HtmlDecode(fields...)
> >
> > BR,
> > Erik
>