the LIKE operator can be used in a join, as well as CHARINDEx or PATINDEX to try and find matching criteria.

see how i provided copy-and-pasteable CREATE TABLE and sample data...

not bad to, good job posting your work. since you put some effort into the homework problem , let me try to offer some constructive advice.

i think i see two...

Thanks everyone;

I've attached it successfully as a user database and will now make a huge mess of things.

Thanks!

what you want to do is all the case logic inside the SELECT, without using that extra variable.

something like this is syntactically correct...let me know if it is logically correct:

select...

at our shop, we have to do both SQL and Oracle;

as a result, to make our scripting a little easier, we added this package a long time ago;

this makes the...

Nice, Jason, i like that...

I think she has data that is not in 4 part naming conventions tho...version 10.45 compares to 8.34.53.2234 for example....i'm adding a CTE to my...

yeah, you should test drive mine first before you say it won't work....

whaty would you expect to be greater if you compare Version "10" to version '1.4.56.2344'?

if everytthing is 4...

Joy the only way i thought to do this right was with a case statement...i ended up dumping it into a scalr function;

you can use this as an example and...

based on this ms doc, where changing the server collation requires a rebuild:

http://msdn.microsoft.com/en-us/library/ms179254.aspx,

i'm guessing that the server collation is actually the collation of the resource database, regardless of whatever...

is your instance an "Express" instance?

by default, an express isntance does not allow remote connections...meaning you can work just fiine locally, but nothing can connect to your machine until you...

In addition to what Eugene said, i usually create the replacement proc under a new, temporary name,a dn test them side by side, comparing execution plans;

yoiu know exec pr_myproc @param...

Riskworks (7/26/2011)

---

I have a SP that returns a table variable. It compiles and runs with no issues.

When I call it from another Proc I get an error saying that...

not directly like that...you could use a scalar function instead...but before i demo that...lets review what you are trying to do...there might be a better way.

if the email address is...

i was playing witht eh event notifications for that for a while; on a certians erver, i was trying to create a suite of roles in any database that was...

also, you can use a server wide DDL trigger for CREATE_DATABASE, but if the database is created new from a restore, it's not detected, for whatever reason that;s not a...