out of curiostity...having got the character count before spaces.....what are you intending to do with the results?

In a similar vein .....

what's the current UK market like?

ForumUser3 (6/11/2014)

---

Please find attached script files to create tables and data.

dbo.Cust_Encounters.Table.sql is the data to start with. dbo.Cust_Encounters_Sets.Table.sql shows what it will look like after creating sets.

Thank you for you...

create table and insert data scripts for your example will be highly appreciated.......this will help us help you

http://blog.sqlauthority.com/2010/11/03/sql-server-fix-error-ms-jet-oledb-4-0-cannot-be-used-for-distributed-queries-because-the-provider-is-used-to-run-in-apartment-mode/

maybe will help you

http://www.sqlsentry.com/products/plan-explorer/sql-server-query-view

this is a free tool and you can "anonymise|"

bearing in mind Grant's comments about the differences between the two RDBMS....probably best to follow his advice me thinks.....

please clarify what results you are expecting for this example

account_number acex_id expense_group effective_date expense_group_line_id process_description...

centerman99 (6/5/2014)

---

Hi I am trying to build a query which will be used in an automated report to calculate failure rates of systems based on cases opened through support. ...

here is one way ...though I would normally use a calendar table and also expect to have a user table (rather than build the cte's below)....maybe give you...

akirajt (6/8/2014)

---

Purpose:

The purpose is to learn and increase my knowledge. Today, I'am junior business intelligence developer. I do not have enough with knowledge from a business controller's perspective. Some...

Welsh Corgi (6/8/2014)

---

Lynn Pettis (6/7/2014)

---

Divide twice...

suggest you read this and then post back again.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

autoexcrement (6/7/2014)

---

Thanks for the reply! The problem is we still need the "other columns". Again, it's my bad for not getting the DDL together for this one first. I will...

autoexcrement (6/6/2014)

---

maybe an idea?

INSERT INTO [dbo].[live]

...