Yes, i already know that handling with bit logic but thought was if anything OR any setting already available to control such behaviour.

Anyways, thanks for your response.

Cheers 🙂

So there is no setting OR option available to avoid these messages???

Actual procedure logic is quite complex and messages gives detail of each row in the results table. so i...

HI,

Please check this simple logic

CREATE proc dbo.test

as

begin

SET NOCOUNT ON

if 1=1

begin

print 'counting objects'

select count(1) from sys.objects

print 'printed successfully'

end

else

print 'Invalid request'

select count(1) from information_schema.routines

end

----DROP PROC dbo.test

And its printing following in messages

counting...

Hi,

Its easier with Common table Expression. Hopefully, this will work for you.

USE tempdb

GO

SET LANGUAGE us_english

DECLARE @s-2 datetime

DECLARE @e datetime

SELECT @s-2 = '2011-05-20', @e =...

Hmmm...

1: I have tested this with network paths and on local and works fine with me. May be you dont have necessary permission to read the file from network locations.

2:...

Hi,

I have used the example metioned above. Hopefully, this will give you some idea to solve your problem. Ofcourse we can change/extend this simple logic further.

USE tempdb

GO

IF OBJECT_ID('#main_table') is not...

Hi,

which version of SQL server you have?

Do you know xp_cmdshell and sp_ListFiles ?

You may find following article helpful

Cheers

Cleanliness (and Silence) is narrow minded...

Music is Multi-tasking...Might not easy for every human like computers

So it all depends you belong to which class and more specially what is your job...

Only lesson, i got from this question is to read the comments more carefully (run twice...) and thats why its just another dodge question.

Hello,

I hope you are fine.

Can you continue replying to this? as i believe no one else will touch this anymore.

Thanks and Cheers.

Kindly try the following. In future, try putting sample script will help you get the answer back more quickly. thanks.

create table #tmp1

(

col1 varchar(4),

col2 varchar(4),

col3 varchar(4),

col4 varchar(4),

ColDate datetime default getdate()

)

INSERT INTO...

I think NTILE could fix things. Try the following please.

;

WITH cteRank AS (

SELECT Col4,

NTILE() OVER ( ...

Do you want to schedule/run different SQL server agent job on different or same time ?

Kindly explain a bit more your scenario.

thanks Elliott,

I am getting a lot from your experience.

First thing, in replication, can we really stop just deletion without effecting replication overall? is there any specific property/method to handle this...

Again thanks Elliott,

Well first thing in my scenario, as i said keep the most required records in Live. So steps i want to perform here are

1. Prepare a staging table...