Viewing 15 posts - 22,216 through 22,230 (of 26,484 total)
Let's up the numbers. I'm curious as to why you need to do this as well.
March 2, 2009 at 1:38 pm
I noticed this is cross posted here.
Is this a SQL Server 2005 or SQL Server 2000 problem?
Edit: Additional info has been posted on the other thread. Please direct...
March 2, 2009 at 1:35 pm
Mani (3/2/2009)
SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')); and its showing output as DISABLED.What this mean? we have sql server 2000 standard edition with SP4
I don't really know. I get the...
March 2, 2009 at 1:23 pm
Just noticed that this is double posted here.
Is this a SQL Server 2000 or SQL Server 2005 question?
March 2, 2009 at 1:17 pm
GSquared (3/2/2009)
declare @Date datetime;
select @Date = '3/5/09';
select
case datepart(weekday, @Date)
when 2 then dateadd(week, -1, @Date)
else dateadd(day, -1 * datepart(weekday, @Date), @Date) + 2
end as SDate,
case datepart(weekday, @Date)
when 2...
March 2, 2009 at 1:06 pm
What is the value returned by the following query on your system?
select @@datefirst
March 2, 2009 at 12:46 pm
More laws aren't the answer, unfortunately. It seems we have a hard enough time enforcing the ones we already have on the books.
What is needed is more people with...
March 2, 2009 at 12:42 pm
karthikeyan (3/2/2009)
Hi All,I have one senario.
if i give like
3/5/09, then need to get 3/2 through 3/5.
if i give like
3/2/09 then i need to get 02/23/2009 through 02/27/2009
Inputs are welcome!
I'm...
March 2, 2009 at 12:37 pm
Give this a try:
select serverproperty('LicenseType')
March 2, 2009 at 12:29 pm
John Erdovegi (3/2/2009)
I always trust computers more then stupid humans.Computers listen to me and don't take bribes.
Even good governments can go bad or get worse.
Unfortunately, computers are programmed by humans,...
March 2, 2009 at 12:14 pm
You're welcome and thanks for the feedback.
March 2, 2009 at 11:51 am
What they are saying is that it takes planning and design work up front in your application to achieve. I don't think it is something that is easily done...
March 2, 2009 at 10:22 am
Not really sure. I understood the question well enough to answer it and get it right.
March 2, 2009 at 10:17 am
Viewing 15 posts - 22,216 through 22,230 (of 26,484 total)