Viewing 15 posts - 1 through 15 (of 42 total)
The other advantage of using datename for days of the week, is that you don't have to remember if 0 is Sun or Mon etc ! (or set it at...
July 19, 2013 at 5:40 am
what's wrong with just using the datename function ?
i.e. select datename(mm,getdate()) --retuns a value of January
and then if you just want the 1st 3 letters add a left...
January 24, 2012 at 2:57 am
I use the method of using the 1st line of an address.
It contains letters and numbers and can easily have a symbol added to the end.
Then my list contains a...
November 15, 2010 at 2:59 am
Another way of doing this is
select start_date as [Date], *
order by [Date] desc
March 31, 2008 at 2:14 am
I like the new proposed layout. It's clean, tidy and easy to read.
Does "question of the day" still remain ?
I am also one of the people who never reads the...
September 27, 2007 at 2:18 am
Be careful when using tab delimited and columns (like postcodes) that could start with a zero.
Excel automatically drops the zeros when you import the data.
A better solution is to use...
January 30, 2006 at 1:12 am
select XXX from YYY where SpecifiedDate between @startdate and @enddate.
I also have a script that runs the same task over and over with a different input parameter.
Set the counter to...
September 27, 2005 at 4:12 am
Or maybe the BETWEEN function would be of use here
September 27, 2005 at 2:27 am
Looks like I stumbled across a RED Herring. The file I was using as a comparison, had a very similar name but was not generated by ISQL.
Sorry to waste...
March 22, 2005 at 7:37 am
Both sp's are structured like this
SELECT Column1 as [xxx],
Column2 as [bbb],
Column3 as [ccc]
March 22, 2005 at 7:22 am
The first column in both reports is a varchar (other columns are calculated).
March 22, 2005 at 7:21 am
I'll check out the code
March 22, 2005 at 7:09 am
We store all our phone numbers as varchar fields in the international number.
So British numbers would be (44) 1234 567890 and
Mexico would be (52) 1234567890
If u need to see...
November 10, 2004 at 2:18 am
Does your table contain some kind of ID field ?
If so you could try something like
case when ID = 1 then RuleID else NULL end as RuleID1...
October 21, 2004 at 1:35 am
Yes - u can register by both machine name and IP address
December 18, 2003 at 2:26 am