You'd be really amazed what could be done if you provided the DDL of the tables, sample data, expected results based on the sample data. The more information provided,...

-- Yes; but only in THIS PARTICULAR CASE.

And how to rename ....is it the same as right click the...

If the database is using the Full RecoverY model, you need to run a transaction log backup to remove log records, thereby allowing you to then shrink the transaction log...

First problem with your query is mixing join styles. You use the ANSI Standard for the LEFT OUTER JOIN, but keep the old style join for your INNER JOIN....

I am going to give you the standard answer, "It Depends". Some will tell you to move them to their own set of drives, others won't. On our...

If you are going to move the files from I to M and J to N, delete I and J, then rename M to I and N to J, the...

I'd check the attributes on your E-Drive and the sub-directories. Sounds like compression is turned on at the file-system level.

😎

I'd have to agree with Jeff. I did take your code, and after some adjustments (my system at home is case sensitive) I have the following working, except I...

A couple of things. One, is the interval time for the averaging fixed (ie 6:00 - 6:29, 6:30 - 6:59) or is it dynamic (one time it may be...

In addition to what Jeff said, it would also be nice to see what you have already tried to solve this problem. We don't want to start down the...

use [YourDatabase]

go

select count(*) from sys.tables

go

Looks like Jack beat me, but here is my code anyways.

declare @SQLCmd nvarchar(4000),

@TableNameOrig sysname,

@TableNameCopy...

tim.pinder (6/6/2008)

---

I posted...

K. Brian Kelley (6/6/2008)

---

blandry (6/6/2008)

---

I have never forgotten a guy I worked for who used to ask a good question - Is he/she an "expert" or "eckspurt" - the latter...

You also stated that [arrival date] and [arrival time] are both datetime fields, what does this data look like (sample values would be nice to see)?

😎