Thank You,

I will also try it out.

But I tried this .. and got the output.

**********************************************************************************

set naic=1261110

set tnpath=C:\tnvintrailerset year=%date:~-4,4%

echo year=%year%

set month=%date:~-10,2%

if "%month:~0,1%" == " " set month=0%month:~1,1%

echo month=%month%

set day=%date:~-7,2%

if "%day:~0,1%" ==...

I think the code is for SQL. I need it to be done in batch script as shown in my question.

Thanks.

Hi ,

I have this batch file as below. I need to update this to get the date without setting it as I have done in the second line of my...

Okay! I will try it out.

Thanks.

Yes I checked it. I changed the Naic code spaces since I needed to enter different code there. It gave me correct record count excluding the trailer record row.

Thanks a lot! It does work.:-)

Thank You!! I will try it.

Okay Thanks.

USE [St]

GO

/****** Object: StoredProcedure [dbo].[P_tnvin] Script Date: 10/10/2016 13:35:45 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create PROCEDURE [dbo].[P_tnvin]

AS

BEGIN

SET NOCOUNT ON;

Create Table TmpTNVINInfo

(

VINRecord char(300)

)

INSERT...

I want to display this trailer record using sql query at the end of the row in a text file. and this text file I am displaying using batch(.bat) file.

Its...

Actually I want to write a sql script rather than use SSIS package. And the requirement is to output a text file with the give specs.

I just gave a...

Actually I want to write a sql script rather than use SSIS package. And the requirement is to output a text file with the give specs.

Thanks a Lot!!

I am still a student and learning. Can you tell me the answer plz.

This statement also works. THANKS!

I also tried with the condition as : WHERE roofyearbuilt < year(getdate()) - 17. This works too.