Didn't realize you could select two answers.

Age Function F_AGE_YYYY_MM_DD

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62729

This function calculates age in years, months and days from @START_DATE through @END_DATE and returns the age in format YYYY MM DD.

Years is the number of full years...

Have they stated why they believe it should be done?

If each of the schemas is completely independent from the others and are used by completely different applications, then I would...

Evil Kraig F (1/19/2012)

---

Michael Valentine Jones (1/19/2012)

---

Evil Kraig F (1/19/2012)

---

Heh, really just a nitpick but it's annoying. Can you put in a timezone for Arizona and Hawaii that doesn't...

Evil Kraig F (1/19/2012)

---

Heh, really just a nitpick but it's annoying. Can you put in a timezone for Arizona and Hawaii that doesn't move around with daylight savings? ...

A lot depends on your network speed.

I recently moved a 400GB database (120 GB compressed Litespeed backup) by copying the full backup files over the network to the new location...

You should check to see if there are any triggers on the table, and if those triggers are new or have been changed.

And as has been suggested, get the identity...

Maybe some tips from the old master:

"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a...

I have a dream that I will be judged not by the points in my reputation, but by the content of my posts.

[font="Arial Narrow"]Apologies to Martin Luther King, Jr.[/font]

Couple of points.

This dimension seems to have no customer information except location. Wouldn't you at least want a name?

DimCustomer

- Customer Key

- Customer City

- Customer State

- Customer Zip

- Customer Country

One...

The "select *" might load all the data pages into memory, but the index pages might not all be there.

An index rebuild on all tables would probably do the job,...

That is something I fixed in the version...

It depends on the setting of DATEFORMAT

set dateformat mdy

select mdy =datepart(mm, cast('2012-09-01 05:20:02.917' as datetime))

set dateformat dmy

select dmy =datepart(mm, cast('2012-09-01 05:20:02.917' as datetime))

Results:

mdy

-----------

9

dmy

-----------

1

I simplified my original code to eliminate three DATEADD function calls and one NULLIF function call, so it might run a bit faster.

select

next_run_date ,

next_run_time ,

NEXT_RUN_DATETIME =

dateadd(mm,((next_run_date)/100%100)-1,

dateadd(yy,(nullif(next_run_date,0)/10000)-1900,

dateadd(ss,

-- Seconds

(next_run_time%100)+

-- Minutes

(((next_run_time/100)%100)*60)+

-- Hours

((next_run_time/10000)*3600)+

-- Days

(((next_run_date)%100)-1)*86400

,0)))

from

msdb.dbo.sysjobschedules...

Jeff Moden (1/7/2012)

---

Michael Valentine Jones (1/7/2012)

---

Police abuse of this is so common that it is more like robbery than police work, especially because police departments are often allowed to keep...