Tom.Thomson (1/12/2011)

---

Ah, but the writer was an Argentinian who died in Spain,...

No. But...

SELECT substring(f_output, charindex('ABCD', f_output) + 4, 4)

FROM @bk

WHERE f_output LIKE '%ABCD[0-9][0-9][0-9][0-9].doc'

OR f_output LIKE '%ABCD[0-9][0-9][0-9][0-9]ZX.doc';

Here's what I came up with:

DECLARE @Cmd VARCHAR(MAX);

SELECT @Cmd = 'select ' + STUFF((SELECT ',(select [name] '

+ ' from RELATIONSHIP where Record_Num = ' + CAST(Record_Num AS VARCHAR(10)) + ')...

CREATE TRIGGER LastLoginDate ON dbo.users AFTER update

AS -- first error fixed here

--//ColumnName

DECLARE @Last_Login_Date datetime, @msg varchar(500);

IF EXISTS

(SELECT 1

FROM inserted

...

On a table that size, and an index with the number of columns you indicate, I'd generally expect it to take a LONG time to complete, especially if the table...

Wouldn't it be easier to query the inserted dataset to see if the user name is the one you want, and then procede from there?

Duplicate post. Already answered in another thread on this site.

Add the command as a string to the select statement, and then execute it dynamically. Or change the select to a cursor and execute the procedure once per value...

jay holovacs (1/12/2011)

---

GSquared (1/12/2011)

---

...Keep your data in two places if it matters. Three if it's important. Four or more if it's critical. E.g.: RAID-10 is 2 places,...

Also, I can't tell what this is meant to do: IF @last_login_date from dbo.users where (user_id = 'bbsupport');

Can't suggest a handling for it, since I don't know the desired end...

You're missing "AS" between the create statement and the first line of code in it.

I love that the comment starts out with "the late..." and is about how to achieve immortality. 🙂

Try this:

SELECT substring(f_output, charindex('ABCD', f_output) + 4, 4)

FROM @bk

WHERE f_output LIKE '%ABCD[0-9][0-9][0-9][0-9].doc';

SQL Server tends to take memory and keep it.

If the only things running on there are the OS and SQL Server, does the low amount of available RAM actually matter?...