AIM

does not seem to be the same welsh as when i first started posting.

or is it

not a problem, i use to use a 1 base tally untill i read jeff's new 8k split then started running a 0 based tally. i should probably have...

dynamic sql for sure would solve this however this is not normally a good option. can you provide a little more detail on what you are trying to accomplish....

i should not try to solve problems real quick before lunch. empty stomach leads to face palm moments. no need to add N to 65 since thats the...

Sean Lange (7/17/2012)

---

capn.hector (7/17/2012)

---

Here is mine, slightly different way to calculate the bits

DECLARE @STR VARCHAR(8000)

SET @STR = 'Rang the client and agreed they would begin to pay off £x...

Here is mine, slightly different way to calculate the bits

DECLARE @STR VARCHAR(8000)

SET @STR = 'Rang the client and agreed they would begin to pay off £x off their current...

you have 3 levels of views, (the giant over view, the 11 sub views which are made up of both tables and views) and you are returning over 4.5...

Funky

i think this is your original query

SELECT o.OrderID, o2.OrderID, o.ItemID

FROM OrderItem o

INNER JOIN OrderItem o2

ON o.ItemID = o2.ItemID

AND...

can you post the query you are using to get the "Bad" result set

the question is how often do you upload? if its quicker than every month then getting the last month of data would increase the size not decrease it. ...

untill you run into a production system using sql 7 because its...

depending on how much accuracy you want to imply in your code would be which one i would choose. they are both the same once the implicit conversion occurs...

Security