I just finished a 5 day SQL2k8 administration class from New Horizons.

I liked it. My preference was in-person training with an instructor but that's hard to...

Says the password is incorrect. I tried copy and paste from your post as well as typing it in using both lower and upper case.

Makr

It depends on how you pulled the record.

Right-click your table, select the option to edit records (can't recall the exact name of this option) and attempt to edit the record....

Replace the field and table name with your own and this should get you close:

select

(case LEFT([Value], 1)

when '-' then substring([Value], 2, LEN([Value])-1) + '0'

else Value

end) as ValueNew

from dbo.[Values]

order...

Author,

See if this article helps:

http://www.drdev.net/article10.asp

Mark

mister magoo,

Odd, I tried clearing my cache numerous times yet didn't see any changes to that style sheet but I tried once more and it worked.

Thanks for the help!

Regards,

Mark

Looks a lot like a homework assignment 😉

You have the field names, database and table. Did you attempt to write the sproc? If so, what were the results?...

It's hard to say without knowing more about the tables. Unless you can post the schema, you may have to take this and run with it.

First, move you select...

If that's a field in one of your tables, yes, like this:

select @Now = lastmodified <or whatever it's called>

from <table>

where <fill in your where clause here>

set @NowPlus10Minutes = dateadd(MI, 10,...

Joe,

Try this:

declare

@Nowsmalldatetime,

@NowPlus10Minssmalldatetime

set @Now = getdate()

set @NowPlus10Mins = DATEADD(MI, 10, getdate())

update your first table using @Now

Update your second table using @NowPlus10Mins

Mark

Jeff - thanks, I'll keep this in mind in case I have to do something similar in the future.

The advantage to making it a UDF is for code re-use. ...

Sorry about that.

UDF = User Defined Function

Execute this in your database:

create function [dbo].[udf_ReverseNames](@Input varchar(20),@Delimiter varchar(5))

returns varchar(100)

as

begin

declare

@Output varchar(150)

WHILE LEN(@Input) > 0

BEGIN

IF CHARINDEX(@Delimiter, @Input) > 0

BEGIN

SET @Output = SUBSTRING(@Input,0,CHARINDEX(@Delimiter, @Input)) + @Delimiter...

Try this. If it works fine, make it a UDF and call it passing in your name field.

declare

@Input varchar(200)

,@Delimiter varchar(5)

,@Output varchar(150)

set @Input = 'Doe, John'

set @Delimiter = ','

WHILE LEN(@Input)...

Andy,

Due to a major project at work, most of my own time has been working from home and I haven't had time to take the exam. But the project...

Old Hand,

I've seen size issues when the data in the excel spreadsheet it too large but never too small.

How are you creating the file and how are you opening it?

Mark