Now you just need to figure out how to have the inner window be logged in to a different account. 😛

What is the question here? Is it the title of your post?

Remember that by their very definition tables have no order. Indexing is one of the ways we can...

Because I wanted to do a comparison on the aggregate values, in this...

You could make this a lot simpler and skip the cte entirely.

SELECT @Total = count(CAST(id AS VARCHAR(60))) FROM cat_transaction

EXCEPT

SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE

jmartincano (6/17/2014)

---

Hi all,

I need to get the object type (view, table ...etc) for a synonym base object inside a script. The only place where I...

ps_vbdev (6/16/2014)

---

Thanks for your reply

i guess in a business rules outlook then you could say

If Active=1 (forget about date) then set all the ID's that are linked by the...

Here is a complete shot in the dark.

update [SomeTable]

set ID = s.ID

from

(

select top 1 ID

from [SomeTable]

order by [Date] desc

)s

If that doesn't do it then you need to post ddl and...

Koen Verbeeck (6/16/2014)

---

Evil Kraig F (6/16/2014)

---

Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update the spam filters on the site...

ps_vbdev (6/16/2014)

---

Im a bit confused if

"I can come up with a number of ways to accomplish based on the sample data" IS true then how can also be "Unfortunately...

ps_vbdev (6/16/2014)

---

Hi there

im not sure how to do this as im not great with update statements. I have a table that get populated with related ids. basically i want...

It still isn't exactly clear what you want but I think it awfully close.

declare @SalesQuoteNumber varchar(20) = 'QUO-10566-0'

select * from

(

select *, ROW_NUMBER() over (partition by salesquotenumber, itemnumber, componentitemnumber order...

Luis Cazares (6/16/2014)

---

Is this a signal...

I really meant what is...

We seem to have totally our website to spammers with links to streaming. Hope there is somebody around who can stop this nonsense.

Thanks for the ddl and sample data. Based on the sample what do you expect as output? I am not quite sure what you are trying to do here.