Many thanks. I just didn't see it at first.

OK this seems to work:

SELECT IPAddress,

PARSENAME(ipaddress, 4) + '.' + PARSENAME(IPAddress, 3) + '.' + PARSENAME(IPAddress, 2) + '.0' AS SubnetList

...

Sorry, I should have provided more information. The IP Addresses could be any IP addresses.

I was trying to use REPLACE with RIGHT statement

Why do some people end their second etc. tempdb files with NDF and others with MDF?

The reason for asking is that I see NDF and MDF in various examples:

ALTER DATABASE [tempdb] ADD FILE (NAME = tempdb_2, FILEGROWTH = 10%, MAXSIZE = UNLIMITED, SIZE=300MB , FILENAME...

Hi cphite,

Can you explain/expand on this: "it's relatively easy to change the number of files that tempdb uses."

Thanks

There has been a lot of great feedback to my questions and I have a few more questions:

Would you recommend splitting TempDB into multiples files equal to the number of...

Thanks Shawn, sorry if I have a ton of questions

In the installation there is:

Shared Feature directory

Shared Feature directory (x86)

(I'm guessing that if the OS is on C:\, you...

Thanks Shawn.

I was wondering also how you would allocate space for each drive. Let's say there is 1 TB space available and you have 40 or 50 Gig Database.

How...

OK thanks, this is what I was thinking, but wanted confirmation on this.

Any other thoughts on this are appreciated

Yes this is straight forward, but what happens when a person doesn't have a group or a unit, but works just at the divisional level?

I am trying to imagine all...

UPDATE:

I changed my SQL query

SELECT cast(CarsDate as Datetime) as Mon

FROM CARS

Then in SSRS textbox

=ROUND(Datediff(Dateinterval.month,First(Fields!mon.value,"Dataset3"),Today() )/12,2)

Seems to work now

I am having trouble replicating this.

I have tried what you suggested

My Dataset3 query returns: 03/10/2010 9:58:24 PM

=DateDiff(DateInterval.Month, Today(), First(Fields!Date.Value,"Dataset3"))

I get: Conversion from type 'Integer' to type 'Date' is not valid

Even with the CAST as INT I still got errors in SSRS

What I was trying to accomplish was get the dates between TODAY and past average date. Then divide...

I also tried this:

=DATEDIFF(DateInterval.Month,FORMATDATETIME(Now(),2),FORMATDATETIME(Fields!Date.Value,2))

and

=DATEDIFF(DateInterval.Month,Format(Now(), "MM/dd/yyyy hh:mm:ss tt"),Fields!Date.Value)

I get this:

Overload resolution failed because no accessible 'DateDiff' can be called without a narrowing conversion: