Hmm... maybe your Name column (in table A) has the char datatype (I expected it to be varchar). In this case, try:

SELECT b.*, a.code FROM a 
INNER JOIN b ON b.text...

You could try something like this:

SELECT b.*, a.code FROM a

INNER JOIN b ON b.text LIKE '%'+a.name+'%'

Warning: this may give you some duplicates...

Razvan

If you want to call a UDF with a parameter whose value is taken directly from a query (that may return more than one row), I'm afraid that it's not...

Here is an article by Erland Sommarskog, SQL Server MVP, that shows several solutions to this problem, comparing performance, ease of use and other aspects:

http://www.sommarskog.se/arrays-in-sql.html

Razvan

See the following thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=138953

Maybe it will help...

Razvan

Although your DDL suggests that you are using Oracle, I will give you two T-SQL solutions (because this is a MS SQL Server site). Neither of them provides exactly the requested result, but...

Assuming that horizon is your database name, the backup statement should work.

The LOG word can play two roles: a clause of the BACKUP statement or a function (logarithm); Query...

The trigger will not be fired again, unless the RECURSIVE_TRIGGERS database option is set (by default it's not). There is no updated pseudo-table, there are only the inserted and deleted...

If a login is already created for that user, you can use:

SELECT name, sid FROM master..sysxlogins WHERE (xstatus & 4) = 4

The tricky part would be now to convert...

You wrote:

You can use a temporary table (not a table variable) or a delimited string.

Razvan

You should do something like this:

INSERT INTO dbo.SUS_Numbers (Number, Total)
SELECT col1, (SELECT count(*) FROM dbo.sus_data
 WHERE ItemInfo LIKE dbo.Import.col2
 AND Activity='Download' AND Status='Succeeded') as Total
FROM dbo.Import

Razvan

If you are interested to read why others think that multiple instances can be a good thing, read:

http://www.winnetmag.com/SQLServer/Article/ArticleID/8686/8686.html

Razvan

This means that you can run up to 50 instances of SQL Server on the same machine; This way, up to 50 separate servers are fighting for the same CPU...

It seems that there is no INFORMATION_SCHEMA view for routine privileges. Other ways to retrieve this information are: using the sysprotects table or using the sp_helprotect stored procedure.

Razvan