Viewing 15 posts - 1 through 15 (of 16 total)
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%" ==...
October 19, 2016 at 8:28 am
I think the code is for SQL. I need it to be done in batch script as shown in my question.
Thanks.
October 19, 2016 at 7:13 am
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...
October 18, 2016 at 9:43 am
Okay! I will try it out.
Thanks.
October 13, 2016 at 6:07 am
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.
October 12, 2016 at 9:56 am
Thanks a lot! It does work.:-)
October 12, 2016 at 9:34 am
Thank You!! I will try it.
October 11, 2016 at 9:09 am
Okay Thanks.
October 11, 2016 at 6:05 am
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...
October 10, 2016 at 1:42 pm
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...
October 10, 2016 at 11:24 am
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...
September 13, 2016 at 12:17 pm
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.
September 13, 2016 at 12:10 pm
I am still a student and learning. Can you tell me the answer plz.
October 1, 2015 at 6:12 am
This statement also works. THANKS!
I also tried with the condition as : WHERE roofyearbuilt < year(getdate()) - 17. This works too.
September 30, 2015 at 11:52 am
Viewing 15 posts - 1 through 15 (of 16 total)