spaghettidba (10/22/2014)

---

Your query can be rewritten like this:

SELECT A.activityCode

,A.ActivityName + ISNULL(A.description, '') AS ActivityName

,A.displayOrder

,A.activityStartDate

FROM Activities AS A

LEFT JOIN...

-- Get all dates from two years ago (rolled back to the first of the month)

-- up to and including today. Include the day name and the relative number

-- of...

-- You could try breaking up the query. Here's one way, there are a few possibilities:

SELECT

[wck.wck_id] = wck.wck_id,

[pd.mode_id] = pd.mode_id,

...

SELECT * FROM orders WHERE CAST(orderdate AS DATE) BETWEEN @begindate AND @enddate

http://sqlblog.com/blogs/rob_farley/archive/2010/01/22/sargable-functions-in-sql-server.aspx

Wouldn't it be easier and more natural to refactor this as a function?

"However the last few years I find myself crunched to get work done in my work week".

Only the last few years? I've often wondered how you manage to get so...

compufreak (10/20/2014)

---

okay so i had a look at some other tables and the field is linked to another table.

so basically if the table contains prj(8345) then i am sure it...

You could use an inline tally table too:

CREATE TABLE #MyTable (OrderID INT IDENTITY(1,1), ItemName VARCHAR(20), UnitPrice INT, Quanity INT)

INSERT INTO #MyTable (ItemName, UnitPrice, Quanity)

VALUES ('car', 10, 2), ('Train', 20, 1),...

Thanks! Try this...

-- Sample data

CREATE TABLE #ADMTABLE (CLASS1 VARCHAR(15), IQREGIONID VARCHAR(10), USERTYPES1 TEXT)

INSERT INTO #ADMTABLE (CLASS1, IQREGIONID, USERTYPES1)

SELECT 'criteria', 'ID No', 'USERTEXT1, Source currency , USERTEXT2, Description for accounts ,...

Also, the name of the stored procedure.

Can you share the syntax error?

We're not mindreaders around here - did the procedure fail to create, run with an error, run but fail to generate results...?

1) You're calling a different stored procedure (SP_Task1) from the one you've just created (GetBooksbyBorrowerID).

Edit: must learn to read.

Not really. The code you've posted so far indicates that you may be a novice...

Gosh that's horrible! Have a play with this:

SELECT x1.UserTypes, x2.pos

FROM ADMTABLE AT

CROSS APPLY (SELECT UserTypes = CAST(AT.USERTYPES1 AS VARCHAR(MAX))) x1

CROSS APPLY (SELECT pos = CHARINDEX('Working Paper',x1.UserTypes)) x2

WHERE AT.CLASS1 = 'criteria'

AND...