Viewing 15 posts - 211 through 225 (of 466 total)
Steve Jones - SSC Editor (6/5/2013)
He's very close, but it's possible he'll...
June 5, 2013 at 10:00 am
Steve Jones - SSC Editor (5/1/2013)
May 16, 2013 at 2:57 pm
By DDL and sample data, we mean you need to post something like this so people helping can have a table on their system to work with.
create table #test
(
mydatevarchar(6),
prj_idint,
amountnumeric(5)
)
insert #test
select...
May 3, 2013 at 10:12 am
Markus (4/29/2013)
April 29, 2013 at 11:26 am
calvo (4/29/2013)
We're 25 games in and Boston is looking good (we need a best-record-in-baseball emoticon!)
New York isn't doing so bad, not as bad as everyone thought they would with...
April 29, 2013 at 11:20 am
http://msdn.microsoft.com/en-us/library/ms182418.aspx
Smalldatetime has a max date of 2079-06-06. It looks like it is erroring out when you put in the 2222-02-22 as a date.
April 9, 2013 at 9:01 am
Steve Jones - SSC Editor (4/3/2013)
no idea. not my piece
Ya, I saw that, I just didn't want to login to another account to have to post a comment on the...
April 3, 2013 at 1:18 pm
Steve Jones - SSC Editor (4/3/2013)
http://www.sqlservercentral.com/blogs/everyday-sql/2013/04/02/merging-sql-server-and-softball-just-for-fun/
Why a decimal(5,3) for all the averages?
April 3, 2013 at 12:37 pm
Steve Jones - SSC Editor (3/29/2013)
The...
March 29, 2013 at 10:16 am
Markus (3/26/2013)
March 26, 2013 at 1:36 pm
calvo (3/26/2013)
With the off-season spending by Toronto and the post surgery recovery unit that is the New...
March 26, 2013 at 1:30 pm
Well I won't be of any help to you on the export since I've never dealt with ADABAS, but hopefully that little piece of code helps you.
February 5, 2013 at 1:59 pm
Well this seems like a really silly thing to do, so I want to ask, why?
But I guess if you really need to, this will work (note it will not...
February 5, 2013 at 1:47 pm
Ray K (2/5/2013)
Only a week until pitchers and catchers report!
Which has been the most exciting point of the season for Cubs fans of late.
February 5, 2013 at 8:33 am
If your companyID datatype is CHAR(2), it's pretty simple:
select companyID, companyname
where companyID like '[a-z][a-z]'
If it could potentially be longer than two characters and you want to find ones with exactly...
January 28, 2013 at 3:00 pm
Viewing 15 posts - 211 through 225 (of 466 total)