Try these

http://www.youtube.com/watch?v=Rd8l8X9aWh0

http://codesamplez.com/source-control/team-foundation-server-2010-version-control-tutorial

http://www.asp.net/web-forms/tutorials/deployment/configuring-team-foundation-server-for-web-deployment/adding-content-to-source-control

No problrem with

SELECT left(ageatdeath,(len(ageatdeath)-5)) as [AGE_VAL], left(ageatdeath,2) AS [AGE_Units] FROM #DEATH

Yours:

SELECT left(ageatdeath,(len(ageatdeath)-5) as [AGE_VAL], left(ageatdeath,2) AS [AGE_Units] FROM DEATH

(len(ageatdeath)-5) -- yours

(len(ageatdeath)-5)) -- correct code

Here is a start to obtain some if not most of what you require

http://sqlblogcasts.com/blogs/davidwimbush/archive/2009/07/28/how-to-get-the-logical-and-physical-file-names-for-a-database.aspx

Is this what you want / need ?

SELECT SUBSTRING(@x,28+CHARINDEX ('CustomerFornm: Changed from ',@x),CHARINDEX('CustomerDOB',@X,1)-77) AS 'Is this really what you

want?'

Result:

Is this really what you want?

Harry to Ben

Duplicate question see

http://www.sqlservercentral.com/Forums/Topic1365565-3077-1.aspx

There are many formats for EDI files ... generally set by the partners (sender & receiver). So like many things in SQL the phrase "It depends" applies to your...

sanjay .... look at the following link and determine if you can alter the table definition to use on delete cascade

http://www.techrepublic.com/blog/datacenter/defining-cascading-referential-integrity-constraints-in-sql-server/128

For example:

ALTER TABLE SalesHistory

ADD CONSTRAINT fk_SalesHistoryProductID FOREIGN KEY (ProductID)...

I wonder who is responsible for checking the checkers .... what if the rogue individual works for the security firm. He/she becomes aware of a fault in the system...

Unpleasantly surprised at the high number of incorrect answers:

Correct answers: 49% (196)

Incorrect answers: 51% (207)

Total attempts: ...

Nice question for the middle of the week - thank you

Using the code from Jeff Moden's article:

DECLARE @OriginalString VARCHAR(70)

SET @OriginalString = 'karthik keyan ...

karthikeyan-444867 (9/24/2012)

---

bitbucket-25253 (9/24/2012)

---

Your request concerned removing a single space, while Jeff's arcticle's objective was:

This article explains the "puzzle solving" behind a common set based method to replace unknown numbers of...

Nice easy question - thanks

Your request concerned removing a single space, while Jeff's arcticle's objective was:

This article explains the "puzzle solving" behind a common set based method to replace unknown numbers of adjacent spaces...

Here is an individual looking for guidance on taking a certification exam. I above all or maybe that should be below all is the least qualified to give the...