In SQL 2000, you can use a trick to order the contents of a view; In 2005, you cannot use the trick anymore, because logically, the select statement should contain...

I was in a similar thread a while back, where there were really three different measures that we discussed:

max defined rowsize of the table

the actual max rowsize of...

well, you could insert it into a table, but I'm not sure that would help much.

the report has 48 lines of header information, that may or may not be a...

Jeremy's method is better; your statement will not catch an error if a space ro multiple spaces are entered...only an empty string; Jeremy catches null, empty string, and spaces...

what you are missing is an UPDATE FROM statement.

you can say UPDATE [sometable]

from [someothertable]

where sometable.id=someothertable.id

in your case, you know where the data is...you were able to select it as...

Christopher Taylor (1/25/2008)

---

i've thrown a bit of error handling in (after 1st sp_OASetProperty) and this is the output:

ObjectID: NULL - looks like this is the problem!

hr: 0x80042727

Source: ODSOLE Extended Procedure

Description:...

Phil you just made me so happy;

I had previously bookmarked http://www.simple-talk.com/prettifier/default.php,

which is fine for formatting code for some things, but not for here at SSC.

the new link you posted at...

I would have changed the process to get the data myself. your proc is what my boss calls "putting wings and wheels on a horse"...that is, using one procedure to...

if the tablename is a parameter, then you must use dynamic sql.

here's an example:

--for users who are too lazy to type "SELECT * FROM"

CREATE procedure sp_show...

since YEAR() function returns an integer, you could use where Year() > 2003 instead:

select distinct CustNumber

from dbo.InvoicesView

where CustNumber in

( select distinct CustNumber

from dbo.InvoicesView

...

ok here's a script that creates the statements to delete or truncate where appropriate, and creates the statements in Foreign Key Hierarchy Order.

now remember there are always tables you...

try this and look at the results:

SELECT *

FROM GRADSTUDENTS G

FULL OUTER JOIN TA T ON G.LOGINID = T.LOGINID

--WHERE G.LOGINID IS NULL

--WHERE T.LOGINID IS NULL

the first rows in...

it has to do with mix mode being allowed or not. on express, it's turned off by default, but usually on for production servers.

1) Open up SQL Server Management Studio...

when you get a problem where it say find data that is NOT [whatever]

you typically need to use a LEFT OUTER JOIN, instead of an INNER JOIN

the word "join" in...

I'm just guessing, but it might be the size of the variable being passed; I'm also assuming your not using the fnParseRTF, since that doesnt need CLR or OLE.

add this...