Select date period with Vb.net

Question

Post reply

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 1

Check your structure. I created a structure like this:

CREATE TABLE dbo.FileName



    (

     tipcon INT

    ,data DATETIME

    ,field1 VARCHAR(25)

)

And your query ran just fine. No syntax errors. Are you sure you ahve a column called Field1?

SELECT COUNT(*)



FROM    FILENAME

WHERE   SUBSTRING(FIELD1, 19, 4) > 2005

        AND TIPCON = '1'

AND DATA BETWEEN '2008-03-01' AND '2008-03-31'

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software