ty so much , it worked

Its nvarchar(50)

Yes he answered, i got it. But the question is we cannot hardcode 9786 in select. because there are tons of records with different student keys. i Just took sample...

ID Grpkey StudentKey StudentLockKey StudentPeriodKey BeginDate EndDate Type SubType

5799 1234 1224567 8876535 1298777 2020-1-20 NULL HOLL SUX

5799 4355 1224567 8876535 1298785 2020-1-20 NULL HOLL SUX

5799 2677 1224567 8876535 1298789 2020-1-20...

Thank you Scott.

Suppose If i want to check type COLL and SUb type MOD, with associated row that has type QUAT and SUbtype BALANCE. If you see the below set...

how to pass folder name to for each loop container dynamically?

step 1 - using for each loop container with enumerator for each file enumerator

step 2- i used directory as folderpath...

Once i got all csv files from all the zip files into a folder. i will have to loop through again all csv files and loads the content in that...

Here is requirement

i have directory and i know the path where it creates folder

D:/Employees/

Under this employees folder we will have so many sub folders, and its not constant we dont...

Ty so much, It worked!!!

column name is Year and its data type is nvarchar(50).

Currenlty data is comming as

201702

201801

202013

Format of data should be like below

2017002

2018001

2020013

I have another question, I have data with space before square brackets and after sqaure brackets when i run below example 1 statement returning NULL.  But in example 2 We...

Thank you so much.

I Have created table along with trigger but the problem is its logging all system events. I want  only the users accounts who are logging into the database (DataMap)

Step -1

CREATE...

thank you for your comments, these reports are hosted on sharepoint project server. next thing i will check the aspx report viewer page first to see why the link is...

We are getridding of EXEC msdb.dbo.sp_send_dbmail.. to SMTP send mail task..