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'...

the theoretical limit is 32767, but i think it has more to do with disk space and memory capacity.

http://msdn.microsoft.com/en-us/library/ms143432.aspx#Engine

i think you could fix it easier with a design change;

each attempt to contact, whether successful or not, inserts into a new table; a view gets added that shows the...

tnnelzo (6/20/2013)

---

It is always from the first day of the current month....to the current day

and b.date_entered >=cast('2013-06-01 00:00:00.000' as datetime)

and b.date_entered < cast('2013-06-20 00:00:00.000'as datetime)

and when the month ends...

tnnelzo (6/20/2013)

---

Hello lowell,

Here is the querry i run everyday,

Select day(b.date_entered)Day_D, sum(a.despatched_qty), sum(a.val) from scheme.dgtable1 a, scheme.dntable3 b

where a.order_no = b.order_no

and a.product like 'Machines%'

and b.date_entered >=cast('2011-05-01 00:00:00.000' as datetime)

and b.date_entered...

well, it depends.

have you set...