Thank you very much Kevin for your support.

Thanks

Arun

So what changes i need to do.Please Help me out.

Hi Kevin

Thank you for your valuable time.

I have solve this issue by below query.

IF EXISTS (SELECT SegmentId,SubjectId,StaffId FROM [dbo].[StaffSubjects] WHERE SegmentId = @SegmentId and SubjectId=@SubjectId and...

Daily Attendance

Guid Uniqueidentifer Number

AcademyId Uniqueidentifer Number

StudentId Uniqueidentifer Number

Guid, AcademyId , StudentId ,Date, Status,Reason

- - - 2015-06-24 P -

- - - 2015-06-25 A Health Problem

Student Details

Guid Uniqueidentifer Number

Guid FullName...

I have a table with

StudentClassLink = With columns [Guid](PK), [StudentId](FK of Student table),[ClassId](FK of Class Table).

THis Link is not working .

Actually i have data in master table.

I need to poplulate those data in to respective parent and child table.

For Example,

Master table name is Customer_car details

Columns like

1:FIletype

2:AcdealerID

3:ClientID

4:Type

5:Stocknumber

6:Stock type

7:Invoice price

8:Salescost

9:Customer address

10:Vehicle...

HI,

Thank you for your reply !

No it must be NULL only .

I know very well we can use it in Stored Procedure as well as when we can create this...

I know that Mr.Phil,If u dont have time please tell sorry having some work.

Any way thank u giving me some ideas till now in your busy Schedule.

Hi Phil ,

Please reply

No The problem has not solved

Here are the Sample File Names

''ACTEST00001_20141111_0408_INV.TXT''

''ACTEST00001_20141111_0408_SL.TXT''

''ACTEST00001_20141111_0408_SV.TXT''

''ACTEST00001_20141111_0408_SV_APPT.TXT''

Like this i have 100 files in my local path

I please u to tell the procedure from the...

Column Name --> FtpDate

Datatype --> Date Not Null

C:\Clients\BlackBook\BlackBookMarketing\SQLScripts\AuthenticomDailyProject\Samplefiles

In this path i have the files and the filename is

ACTEST00001_20141111_0408_INV.TXT

How to use this Expression

(DT_DBDATE)(SUBSTRING(myFileName,13,4) + "-" + SUBSTRING(myFileName,17,2) + "-" SUBSTRING(myFileName,19,2))

to pull the above file...

This Expression i have already used and we cannot uss the SUBSTRING in date datatype.

THis is Comming Error.

Please suggest some other Expressions.

Which Extract only the date

I nend only the date present in that file name.