duplicate post.

There's no need to post the same question in multiple forums.

The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.

crossposting will wastes people's time...

duplicate post.

There's no need to post the same question in multiple forums.

The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.

crossposting will wastes people's time...

grab the trial version...

i don't think there is a hard and fast rule you can just say, it depends on the data and how often it gets accessed;

SQL will use all the RAM...

Lidou123 (6/25/2013)

---

Hi Lowell,

Thank u for your answer.

I tried to connect via linked server and that wooooorks !!!!!!!!!!!!!!! 🙂

Thank U.

So, now I can create a report and deploy it ??

Or I...

John Mitchell-245523 (6/25/2013)

---

Lowell (6/25/2013)

---

also, i see a scalar function in the selection, so that will substantially slow things down...it looks like it's just formatting the data as 6 chars, maybe...

also, i see a scalar function in the selection, so that will substantially slow things down...it looks like it's just formatting the data as 6 chars, maybe 201306?

lose the function...

you could easily add a linked server and connect to that.

since you specifically mentioned 2012, you are probably running 64 bit, and so you need 64 bit progress drivers...

does the proc insert potentially multiple rows?

is the proc generating a unique key value? a bad join in a SELECT statement could pass the not exists, but make...

Trainacomin (6/24/2013)

---

I'm new to the forum so I hope this is the right place to ask this question.

I have a production and an archive database. I want to create...

Matthew Darwin (6/24/2013)

---

Try this:

SELECT IDXMRN, Problem, Code FROM Diagnosis

WHERE Code = '305.1'

OR LEFT(Code, 3) = '491'

Or have I completely missed the point, and you want the IDXMRN where there is...

Jose do you mean object creation/modification, like what is available in sys.objects?

SELECT

name,

create_date,

modify_date

FROM sys.objects

ORDER BY

modify_date DESC

That's interesting; i bet with some enhancements, that could do the same thing my script was;

i see quite a few...

I can certainly help here; my example here, at least for me, works fine, except i cannot get 4 part statemetns to work; i only see to get openquery stuff...

maybe like this?

With PossibleValues(ID,Val)

AS

(

SELECT 1,'-1' UNION ALL

SELECT 2,'0' UNION ALL

SELECT 3,'a' UNION ALL

SELECT 4,'b' UNION ALL

SELECT 5,'c' UNION ALL

SELECT 6,'d' UNION ALL

SELECT 7,'e' UNION ALL

SELECT 8,'f'

),ColumnLimits(ID,ColumnName)

AS

(

SELECT 1,'Column1' UNION ALL

SELECT 2,'Column2'...