You are good and you are fast....thanks 🙂

One alternative I found is to use Union All. Looking for more which makes use of sys.syscomments....

I actually searched it once Gila mentioned it and went through it 🙂

A long reading nicely put.

Thnk for your valuable inputs. After reading all this, doing it in one shot thru script has become a strict no-2 for me. So I am thinking of doing it...

Looks like every time you populate your temp table, you get fresh records which meets <> criteria and gets updated.

It could be of help if you can paste complete code(where...

Doobya

With no offence, let me put my understanding here:

When you do exec dbo.spTryTestA, you get

spTryTestA:1

Msg 50000, Level 16, State 1, Procedure spTryTestA, Line 5

spTryTestA:2

spTryTestA:3

This is because u raised high severity...

You can try using Proxy account. You 'll need to create credentials and then proxy account which just have permissions mentioned by you

Here is a link on how to do...

Basically what I am trying to get is open 99 sessions of SQL server and run some queries in each session.

But I dont want to open 99 connections manually.I am...

One way that comes to my mind is:

select a.Custid ,a.CustName,a.CustPhone,a.ContactPhone from (

select row_number() over (partition by a.Custid order by calldate desc ) rwnm,a.Custid ,a.CustName,a.CustPhone,b.CallDate,b.ContactPhone

from @CustMaster a LEFT JOIN @CustCalls b...

replication can be an alternative

See if you can do it this way:

CREATE TABLE tbParticionada

( id int identity(1,1) ,

[date] DATETIME NOT NULL,

mth as MONTH(date) PERSISTED

)

ON PS_MonthRange (mth) -- does not...

Well in this case, there is nothing which SQL Server can automatically generate for your customers and which they can understand as a layman.

Looks like they want some graphical representation...

Thanks for the reply..it makes me wonder why at times we dont have to supply a placeholder and it still works

yes, you can do that but you'll need to get into excel programming a bit where in you make a database connection and call your proc.

I didnt see that OPENQUERY is another way......thanks fo rthat too...