Viewing 15 posts - 1 through 15 (of 162 total)
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...
June 8, 2022 at 12:38 pm
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...
June 3, 2022 at 6:10 pm
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...
May 25, 2022 at 7:53 pm
Ty so much, It worked!!!
April 20, 2022 at 12:20 pm
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
January 9, 2022 at 1:27 am
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...
December 10, 2021 at 7:05 pm
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...
September 20, 2021 at 7:23 pm
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...
February 23, 2021 at 6:42 pm
We are getridding of EXEC msdb.dbo.sp_send_dbmail.. to SMTP send mail task..
July 10, 2020 at 3:35 pm
Still duplicates.
My requirement is to check if single ID has 2 rows in A table and if Name is ('AUSN','MAN') and code will be different for AUSN and MAN.
if that's...
April 9, 2020 at 12:42 pm
I am getting this error
Msg 4104, Level 16, State 1, Line 31
The multi-part identifier "updated.Id" could not be bound.
Msg 4104, Level 16, State 1, Line 31
The multi-part identifier "updated.Date" could...
February 21, 2020 at 9:14 pm
Is this correct?
DECLARE @tableVar TABLE (MergeAction VARCHAR(20), InsertedId NVARCHAR(50), UpdatedId NVARCHAR(50),InsertedDate date, UpdatedDate date)
MERGE dbo.Student as Target
USING temp.student as Source
ON Target.Id = Source.Id
AND Target.Date = Source.Date
WHEN MATCHED AND (ISNULL(Target.StudentLocation,'') <>...
February 21, 2020 at 6:57 pm
ty, it worked
November 27, 2019 at 6:19 pm
tried, giving invalid token errors
November 27, 2019 at 4:59 pm
Viewing 15 posts - 1 through 15 (of 162 total)