curious_sqldba (8/9/2016)

---

I am subscribed to these groups:

Current SubscriptionsNotification

Home » SQL Server 2008 » SQL Server 2008 Performance Tuning

Instant

Home » SQL Server 2014 » Administration - SQL Server 2014

Instant

Home » SQL...

Solomon Rutzky (8/9/2016)

---

Lynn Pettis (7/18/2016)

---

Still turns out there may be a limit to the number of replaces you can nest. Originally I was looking at 53 different characters, now...

Rob Reid-246754 (8/9/2016)

---

Well done that fixed that results page but I don't understand why as I just checked all the tables in the SELECT statement and the ONLY one with...

Just an FYI, since you are joining four tables together you really should use the table aliases to identify which table each of your columns come from in the SELECT...

Rob Reid-246754 (8/9/2016)

---

I know they shouldn't that's why I am so confused to what is going on. I will try and insert some screen captures so you can see.

If you...

Here are two options:

declare @Period char(6);

select @Period = dbo.calcperiod(value) from sys_registry where system_code = 'gbl' and name = 'reportdate';

select rev.sales_doc_no

period_rev =...

Hey,...

Using or not using the COVERT statement in the SELECT list should not change the sort order if you are not changing the ORDER BY clause.

The follow two SQL SELECT...

I see that the cheap kitchens in the UK are back again.

Rob Reid-246754 (8/9/2016)

---

I've been into IIS and changed the

.NETGlobalization - Culture and UI Culture to English (en). English (United Kingdom) en-gb

at both the server level and on the website levels...

Overly complex queries where the optimizer doesn't have time to properly evaluate plans.

From SSC?

I don't get any SPAM emails from this site.

Make it easier:

https://technet.microsoft.com/en-us/library/ms177443(v=sql.105).aspx

Just let me know, I am willing to play again.

sku370870 (8/8/2016)

---

drew.allen (8/5/2016)

---

sku370870 (8/5/2016)

---

drew.allen (8/5/2016)

---

sku370870 (8/5/2016)

---

Thanks for your reply. But when I am on any particular stage, all I have to hand is the StakeholderID for that stage - so...