Hi,

You’re in the 2008 Forums, but you need for 2000!!!

Select count (*) from sys.databases -- above 2000 version

select count (*) from master..sysdatabases -- in 2000

Repeated post, discussion already started in

http://www.sqlservercentral.com/Forums/Topic851707-392-1.aspx?Update=1

Hi,

From your sample data, we can do it by min,max class

create table #T( GPName varchar(10),Year int,Qtr int,Total_Doses int)

insert into #T

select 'XYZ',2008,1,20 union all

select 'XYZ',2008,2,300 union all

select 'XYZ',2009,4,500 union all

select 'BNG',2007,2,440...

or

SELECT title, REPLACE(title, '_', '/') AS NewTitle

FROM #TSRECORD

WHERE title...

Hi,

You’re divided the Integer values, so you get the integer value of the zero (int are the round values, not the decimal)

You convert the int value to decimals then divide...

Aaron Gonzalez-394690 (1/20/2010)

---

I train tae kwon do 3 times a week. I've found that kicking other people and being kicked by them in a controlled environment relieves all the stress...

Hi,

A news from new co-worker in the lunch, they have the server in one location and another sister office access the application by the 2mbps RF connection just 40 kms...

Hi,

Refer the below link, see RBarryYoung approach on this.

http://www.sqlservercentral.com/Forums/Topic473301-169-1.aspx

Hi,

In fact it’s a fun, I asked, why you put the len(drivers)>2 in your select statement, but you says the normal group by/ select is enough. However thanks!!!

bhakti-795560 (1/19/2010)

---

distinct vehicle_name from table ABC into Table PQR and value of MAX length drivers from PQR to ABC for appropritevehicle

Current Query

Select distinct(vehicle_name),drivers from (SELECT...

Hi,

You’re existing trace file contains the start date/ end date in the display column in the trace then its easy to capture/see the trace between these dates,

By just open...

Hi,

What you have written in the statement is correct, but you should convert the date time type by convert (varchar (15), tet.dteTravelDate, 103)

(case when pt.intPointTypeID = 1 then convert (varchar...

Hi,

There is no direct commends in the SQL to call the system event log file, you export the event log files to the local drive as a text file...

Hi ram,

This may also another way you to go by coalesces. However you got the mean to archive.

Hi,

select datediff(second, '01/15/2010 10:35:51', '01/15/2010 11:05:51') /3600.00

select datediff(second, '01/15/2010 10:35:51', '01/15/2010 12:05:51')/3600.00