What is the error message you are receiving?

Kurt

Hummm... If I knew this was 2012 specific then I would have probably not attempt to run it. Here is my result when running it in SS2K8R2

--run this in...

Sean Lange (1/21/2014)

---

Another option is to store the images in a varbinary(max) column. There are advantages and disadvantages to any of these options.

Kurt mentioned something about storage. Honestly, the storage...

Although I've never had the opportunity to store .JPGs in a database the construct you are looking for is FILESTREAM. I'd suggest you read up on it in BOL.

One...

Back before we had all of these fancy functions I used this method:

DECLARE @number AS NUMERIC(4,2) ; SELECT @number = 2.99;

print @number;

if cast(@number as int) = @number

begin

Print 'whole number'

end

else

print 'has...

Lynn Pettis (1/10/2014)

---

If you are routinely using cursors in your production code you are more than likely doing things wrong. Cursors should be avoided for most database activity. ...

I agree with you Gail. Sprocs that...

What code do you have so far? Maybe I can assist your issues.

Kurt

dead-man

What do you have so far? It may be easier to see what you are developing and to see your issue.

Kurt

Your first post indicated you wanted a 2 digit year. Your solution provides you a 4 digit year. Just saying.

Kurt

I came up with something like this:

declare @SSDate datetime = '01/22/2001'

declare @CharSSDate varchar(10)

set @CharSSDate = right('0' + cast(MONTH(@SSDate) as varchar(2)),2) + '/' + right('0' + cast(DAY(@SSDate) as varchar(2)),2) +...

jiffy

Data

Is this something you are looking for?

declare @InDate datetime = getdate()

declare @sInDate varchar(20)

set @sInDate = cast(YEAR(@InDate)as varchar) + '-' + left(CONVERT(varchar(20),@indate, 100),3)