Thanks for your reply.

I've searched for a summary.txt file but I cant find it.

A "%programfiles%\Microsoft SQL Server\"... folder isnt even being created.

I've also tried installing SQLEXPR_x64_ENU with the same results.

Is...

Thank you for your suggestions.

Changing the Contsupp table is not an option.

While the following script doesnt work as I would like.

I am able to update the Contsupp.Notes column.

UPDATE CS

Set...

djj (12/9/2014)

---

First is there a reason you are using TEXT? Why not VARCHAR(MAX)? From BOL

ntext, text, and image data types will be removed in a future version of...

Hi Guys,

I've been testing and there must be a problem with the update application.

As mentioned earlier the scripts run fine when run through SQL.

Thanks again for your help.

Hi Eirikur,

That looks really promising. 🙂

Let me test.

Hi GilaMonster,

Thanks for the quick reply.

The reason the quotes are escaped is because they're in an EXEC string.

The script works fine when run on its own.

The problem is...

Luis Cazares (6/12/2013)

---

Don. (6/12/2013)

---

Thanks for the reply Luis.

This script seems to do what I want with the demo data.

Select top 100 *

From CONTSUPP

Where RECTYPE = 'C'

AND...

Thanks for the reply Luis.

This script seems to do what I want with the demo data.

Select top 100 *

From CONTSUPP

Where RECTYPE = 'C'

AND ( CONTSUPREF =...

Hi Guys,

Any suggestions as to what Im doing wrong?

The script below isnt returning any results:

Select top 100 *

From CONTSUPP

Where RECTYPE = 'C'

AND CONTSUPREF like '%[...

Luis Cazares (6/11/2013)

---

You might miss some desired results if you have other delimiters such as tabs or slashes.

Be sure to add them between the brackets[] or to replace them with...

Luis Cazares (6/11/2013)

---

You have the right idea, but you're not completely correct.

This query isn't SARGable, meaning that it won't let you use indexes to obtain the best performance, but it...

Thanks for the reply

If only it were that...

Hi Guys,

Thanks for the replies.

Adding the where clause below returned the correct results.

WHERE Client_Accountno is not null

Select * from Contact1

Where Company <> 'Z_CANDIDATE'

And Accountno not in (Select...

Hi Koen,

Thanks for the reply.

I took another look at grouping in SQL Reporting...

Hi Vivek,

I was going to point you to the SQL Reporting stairway series

http://www.sqlservercentral.com/stairway/72382/

Unfortunately I've just noticed its SQL Reporting 2008