Hi Steve,

It's ADF pipeline.

Source is a table in Sql server having 10 million records appx. Source Table is truncated each day and fresh data is loaded into it. We have...

Thank for your reply.

I was in the same confusion. You removed my confusion

Thanks
Amit

I am sorry for the same. I placed the wrong Storage account name. It was a typo error.

Hi,

All these are generating random values but It's not working for any select statement.

Like

In the select these are generating same random value in the select row for all...

Nice one. Really, We don't need to run one by one...........

Thanks

Hi Adi,

Really you solved my problem in a very short time.

Thanks a lot.

Hi

i just completed the task using For each Loop and sql task. I created 2 tables.

Create Table ServerNames

(ServerName varchar(20))

Insert ServerNames

values('ProdServer'), ('StagingServer'),('TempServer')

Create Table Table1(

ServerName varchar(20),

Path varchar(50)

)

Insert into Table1 values('ProdServer',''),...

I also tried something similar..............:-P

select ROW_NUMBER() over(order by id) , name From Table1

union

select ROW_NUMBER() over(order by id) +3, name From Table2

I hope this is you are expecting........

DECLARE @dbs TABLE ( DBname NVARCHAR(100) )

DECLARE @database varchar(100)

DECLARE @database1 varchar(100)=''

INSERT INTO @dbs

VALUES ( 'A' ),

...

It should work I think. Please let me know if need some more changes..

DECLARE @a varchar(20) = 'INV CRT IS15000467 1'

DECLARE @b-2 varchar(20) = 'INV CSH...

Hope this should work.

DECLARE @a varchar(20) = 'INV CRT IS15000467 1'

DECLARE @b-2 varchar(20) = 'INV CSH IS15000442 10'

select substring(stuff(@a, 1,Charindex(' ',@a, Charindex(' ',@a,0)+1),''),0, Charindex(' ',...

It shows the below error.

[

The log scan number (61:328:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file...

Thanks for your reply on the services.

I checked the services "SQL Server(MSSQLSERVER) is not running. When I am trying run the same and refresh the settings it again gets stopped...