GBeezy (5/28/2014)

---

Gentleman,

I have done this and some rows return a 32 and return a 49. I do apologize as I am not sure what this is telling me, if...

Duck!

GBeezy (5/28/2014)

---

All,

I have a field in AX that is NVARCHAR(30). Sometimes the value has 5 extra characters at the end and sometimes, it does not. I have...

mighty

ronan.healy (5/28/2014)

---

anyone have ideas on how i can combibe data together.

this is how my table is as of right now

FundCodeACCOUNTPERIODClassNameNAVSharesOutstanding

IL0131/12/2013Class A GBP23704633.79

IL0131/12/2013Class A GBP20143018.57

IL0131/12/2013Class I2 GBP252178460.2

IL0131/12/2013Class I2 GBP210634139.7

IL0131/12/2013Class I2 EUR...

mattech06 (5/28/2014)

---

Hi, yes!

SELECT

b.TransDate, b.TransType, b.SortCode, b.AccNum, b.TransDesc,

(ISNULL(b.Debit, 0) + ISNULL (b.Credit, 0)) as Amount,

ISNULL(r.OrthoID, 999) as OrthoID

ISNULL(t.PatientID, 0) as PatientID

FROM

EPSBankTransactions b...

mattech06 (5/28/2014)

---

can you use those functions in the FROM section?

This is the working vers, not my sample from above and includes a ref table as well and there's a bit...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

nimalatissa (5/27/2014)

---

I'm very confused. These tables are normalized to 3rd normal form. There shouldn't be anything to do with that. the column in this table have comma separated values...

bee sting

You could this without needing a join and windowing functions. Since you have two queries that are both just an aggregate a cross apply will make this a lot simpler.

SELECT...

Or even simpler.

declare @dteTo Date

set @dteTo = GETDATE()

sachin.sakpal2009 26397 (5/28/2014)

---

SET NOCOUNT ON

CREATE TABLE #query (query NVARCHAR(MAX), id int)

DECLARE @STR_IP NVARCHAR(MAX)

DECLARE @T_NAME NVARCHAR(MAX)

DECLARE @T_NAME1 NVARCHAR(MAX)

DECLARE @C_NAME NVARCHAR(MAX)

DECLARE @T_CATALOG NVARCHAR(MAX)

DECLARE @T_SCHEMA NVARCHAR(MAX)

DECLARE @a NVARCHAR(MAX)

DECLARE @a_Copy NVARCHAR(MAX)

DECLARE @Cnt Int

DECLARE @Result...

Nice job posting ddl and consumable data. I just don't have a clue what you want to do with this. We have two tables of data (AppointmentForNextTwentyDays_InProcess and DoctorScheduleFortoday)....

SQL_ME_RICH (5/27/2014)

---

Hi Sean - Not sure what you mean by Vendor. As best I know it's Microsoft's product still, but do you perhaps mean reseller?

We do not deal with...