a CTE is available just for the next statement in the query, so if it really needed to exist twice, you'll need a temp table.

You're not really doing anything that...

rather than the AVG, i think you want the MIN([Sch Start]) for the earliest, or the MAX(([Sch Start]) for the latest date.

since you have a VPN, your machine is effectively on their network right?

what you'll want to do is fairly straightforward, the process is the same as you would do locally.

connect...

--snip edited wrong answer!--

Joe you cannot make the aliases for the columns dynamically(at least not directly) , so you have to revert to dynamic SQL to do it instead...building the command, then executing...

this happened to me as well; a partial install kept me from redoing or uninstalling.

i googled "completely uninstall sql2005" and found this link at microsoft that gave the annoying...

Jack I've got a minor article i contributed that...

it's in the comments of hte proc:

--#############################################################################

--if you are going to put this in MASTER, and want it to be able to query

--each database's sys.indexes, you MUST mark...

as usual, it depends....

an inline table value function should perform the same...a multi statement TVF often slows things down...

care tou show us the function to see if we can...

anish, it looks to me like you are truncating your value by at least a couple of characters..., so you would never be able to compare a hash to the...

boris with Profiler running agaisnt my 2008 machine, i'm running this command as a crappy example into a table, which i know will produce a pk violation:

CREATE TABLE [dbo].[MYADDRESS] (...

RENAME is a valid command in Oracle, but not SQL; you have to use the sp_rename procedure in this case.

parthi-1705 (10/27/2010)

---

Any other 3rd party tool can solve this.

Trigger or not good to used on all the tables in the DB

Server side trace may be good for one point of...

mashikoo (10/27/2010)

---

Hi Lowell,

That's exactly what I'm trying to do add a calculated column to create the desired version and leave the original integer data untouched but i don't to Alter...

you can add a calculated column to create the desired version and leave the original integer data untouched; you can do the same in the presentation layer as well.

ie

ALTER TABLE...