Like this:

declare @ADateTime smalldatetime;

set @ADateTime = '2009-07-05 09:00:00';

select @ADateTime, year(@ADateTime);

You may want to spend some time reading Books Online (BOL, the SQL Server Help System that may be accessed from...

This?

declare @TestInt int;

set @TestInt = 425699;

select cast(@TestInt/100.00 as decimal(10,2);

There really isn't enough information to provide a really good answer. Could you provide the DDL for the table(s) involved, sample data (in a readily consummable format that can...

It isn't a stupid question at all. the problem I see with it is that it is extremely broad and vague.

Perhaps you could provide more background information regrading what...

WayneS (7/6/2009)

---

Lynn Pettis (7/6/2009)

---

You may want to search this site a...

We also use a...

You may want to search this site a bit. You...

We haven't moved to a production environment yet, but what I am curious about is your comment about modifying meta-data in your packages. What meta-data did you have to...

GilaMonster (7/6/2009)

---

It's violating BCNF if I'm not mistaken. There's no inter-data dependency (so passed 3NF) but there is...

WayneS (7/5/2009)

---

Lowell (7/5/2009)

---

I slapped together a stored proc sp_GetDDL that returns the table DDL, complete with indexes ,defaults, everything...there's a function version as well; that would probably work just fine...

A little humor helps a bit...

With that, though, Jeff really wasn't kidding when he asked you to...

Hey, I could have said something at the beginning but...

Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛

Digs (7/5/2009)

---

Thanks the out put was

1A10

2B20

3C30

Where did the column 'ItemID' come from, have you made changes to the 'DelimitedSplit' function, by allowing and 'Identitiy field ' (increment at 1) ....

You have much to learn padawan.

Here:

declare @Str1 varchar(8000),

@Str2 varchar(8000),

@Str3 varchar(8000);

set @Str1 = '1,2,3';

set @Str2...