This works as i need

SELECT resultnr,timeinfo

FROM (SELECT ROW_NUMBER() OVER (ORDER BY timeinfo ASC) AS Row,

...

I would need to see min and max date for these 50rows.

More:

requirement is to have any date range that can give me 50k records (these records should lie in this...

yes, i have tried using Pivot but I do not know what the status can be .. hence cannot hard code status in either Sum or Pivot..

any other way.

My...

I achieved this by writing the select statement is source in a way that it converts the date less than year 1753 to 9999 and then pass it to destination(SQL...

Hi,

I ran into same problem today morning. My package was logging everything configured to text file and suddenly it stopped logging. I tried everything, redoing the connection, task but no...

The real goal of having table synonyms is to allow it in DML statements and no other places.

Hence the above said will not be possible

However, if still this is...

Does this mean that only login which belong to sysadmin role can take backup.

If i would not want to give sa rights to other person but give backup/restore rights what...

declare @resnr int ,@res_seqnr int, @tot int

set @resnr=1144894

set @tot = @resnr + 1500

print @tot

declare results_cur cursor for

select sequencenr from sequenctbl where Inst = 8323

open results_cur

fetch next from...

missed in pasting query

END is right before closing the cursor:

WHILE...

...

...

end

CLOSE instrument

DEALLOCATE instrument

Thanks for the quick response.

I have added the server as linked server.

But my proc looks like

insert into server2.db2.dbo.tbl2

(select col1 from server1.db1.dbo.tbl1 )

here server2 is linked server.

Now in dev env...

Hi

Just cross checked and saw that table has identity column.

But in sp i have written

SET IDENTITY_INSERT DBNAME.DBO.TBL1 ON

Then

insert into ....

but it still passes me error saying

cannot perform...

it would be dynamic SQL statement but how will I map the db name to the parameter in SSIS.

can you also please give an example

There are some operation being performed like conversion of datetime, datatype, substring, trim , concatenation etc.

well.. this is not working 🙁

Moreever the parameter that i'm passing is coming from the select statement that sits in same task

like

Select @var1= col1 from my_table

select @PStatus = status,@message...

Just discovered.. that GO helps.

Thanks!