READTEXT is associated with the TEXT, NTEXT, and IMAGE data types. I believe what you need to do is migrate from those data types to the VARCHAR(MAX), NVARCHAR(MAX), and...

First, since you are new to ssc, I took the time to setup the data to work the problem. In this case I simply used a CTE (TestData) to...

SQL Guy 1 (3/25/2014)

---

That was rather simplified example. In reality I have a table with 150 mln records, and it is partitioned by integer column (it is some ID...

kaplan71 (3/25/2014)

---

Hello --

The rescheduling of the third-party backup job resulted in the native differential backup being successful. Even though the third-party backup include any of the database bak or trn...

SQL Guy 1 (3/24/2014)

---

I have a table which has a unique integer column. It's not contiguous, it has some gaps.

I need to find a count of records within...

Uripedes Pants (3/24/2014)

---

Brilliant!!

SELECT j.name, h.message, h.run_date, h.run_time, h.step_name

FROM sysjobs j

INNER JOIN sysjobhistory h

ON j.job_id = h.job_id

where h.step_name = '(Job outcome)'

AND msdb.dbo.agent_datetime(h.run_date,h.run_time) > (GETDATE() - 1)

is MUCH...

Try this:

declare @Date int = 20140314,

@Time int = 90000;

select msdb.dbo.agent_datetime(@Date,@Time);

I don't know why, but this sort of thing scares me.

mrupperman (3/24/2014)

---

No, I just created the plan and saved it....

You may want to look at DDL triggers, specifically LOGON triggers. Be careful when setting up a LOGON trigger as you could accidently block everyone from login into the...

No luck for me.

Also, it could just be me, but after downloading the estimated execution plan I was unable to open it.

mrupperman (3/24/2014)

---

Thanks for the quick replies guys! Sorry for confusion, I havent posted a question here before and wasnt entirely sure what you would though am not surprised to hear...

Not sure of the performance of this solution, but it is worth a try.

CREATE TABLE dbo.Table1 (DealerId INT, RepairId INT);

INSERT INTO dbo.Table1 VALUES

(1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),

...

May not be the answer you are looking for but hopefully it points you in the right direction:

with Groups as (

select 1 as GroupId,'Oracle' as GroupName,0 as IdParentGroup union all

select...