Actually we're only after the points. I hear the winner gets to choose from an xbox and a mountain bike.

Although this will cause an error if more than one row is updated. You could change

SET @Last_Login_Date = (SELECT Last_Login_Date FROM inserted);

to

SET @Last_Login_Date = (SELECT TOP 1 Last_Login_Date FROM...

Try this:

change

IF EXISTS

(SELECT 1

FROM inserted

WHERE user_id = 'bbsupport')

to

IF NOT EXISTS

(SELECT 1

...

This should help:

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

something i whipped up:

create table A (col1 int, col2 int, col3 int, col4 int)

create table B (col1 int, col2 int)

declare @field_list varchar(max)

--set @field_list = ''

;with cte as

(select column_name, data_type...

To me, looks like he wanted the "4" from the string. So, you...

Is it considered cheating that I went to the BOL before answering the question and read "If two or more rows tie for a rank, each tied rows receives the...

then lets make it a proc:

create procedure updatetable

@a varchar(10),

@b-2 varchar(10),

@C varchar(10)

as

update whoknows

set col1 = @a, col2 = @b-2, col3 =...

declare @a varchar(100)

set @a = 'Number of files=4'

select substring(@a, 17, len(@a))

according to your specs, this is what you need:

update whoknows

set col1 = 'MMADAS', col2 = 'HHFASD', col3 = 'HGGOI' where rowID in (1,2,3,4,5)

🙂

CELKO (12/29/2010)

---

sa.ordekci (12/29/2010)

---

Hi! i have two tables that are category and products. when i select a catageroy(on my asp.net project) i will list products associated with that category. and i...

Actually no. I had to go back in my files and look, but it's the one that uses the tally table.

You could also use the split function and get a list of all the folders:

SELECT * FROM dbo.fn_Split('/folder/folder1/folder2/12345-ABCD.txt','/')

WHERE IDX = 3

Some sample data and DDL please.

Thanks for the response.

Right-on about the schemas. Out of 607 total, 3 are used. I'm still suspect though, I don't want to removed unused schemas like db_owner, db_accessadmin, etc. I'll...