Viewing 15 posts - 1,036 through 1,050 (of 3,221 total)
Try Codeplex - it may have what you want
August 12, 2011 at 11:14 am
Have you attempted to use the MERGE statement? An example of its features, capabiliies, and use can be found at:
http://www.codeproject.com/KB/database/SQL-2008-Merge-Statement.aspx
August 12, 2011 at 11:06 am
Steve Jones - SSC Editor (8/12/2011)
Roy Ernest (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
Once again I feel like I've let too much time go without writing a book 🙁
Planning to write...
August 12, 2011 at 10:09 am
You might find this helpful
http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582
-- Author: Martin Grape
Be sure to read the comments posted by:
--Comment by Jeff Moden
----The only problem is that the code doesn't recognize missing "SysID"...
August 11, 2011 at 9:54 pm
Evil Kraig F
On the QOD:
http://www.sqlservercentral.com/Forums/Topic1157383-1222-5.aspx#bm1158891
Many thanks for your comments on the above. Hopefully even without SanDroid's endless rant, some people learned something about why not to Shrink a DB.
Again...
August 11, 2011 at 6:26 pm
Lynn Pettis (8/11/2011)
I was going to wait until tomorrow night, but it is close enough.
I am resigning...
August 11, 2011 at 6:18 pm
Hope this gives you a start:
CREATE TABLE #T(pjt_no VARCHAR(30),Street VARCHAR(100))
INSERT INTO #T
SELECT 'abcde','1 Main Street' UNION ALL
SELECT 'xyz','1 S.View Ave'
SELECT SUBSTRING(pjt_no + REPLICATE(' ',50)...
August 11, 2011 at 12:13 pm
C.K.Shaiju (8/11/2011)
August 11, 2011 at 7:02 am
Brandie Tarvin (8/10/2011)
This one is giving me heartburn. I almost ran something in Production that was supposed to...
August 10, 2011 at 5:05 pm
In order to help those who can help you with a tested T-SQL statement, please, please post the table definition(s), provide some sample data and the desired results from the...
August 9, 2011 at 9:41 pm
You might modify your code to include:
IF OBJECT_ID('tempdb.dbo.#Ts','U') IS NOT NULL
BEGIN
...
August 9, 2011 at 8:28 am
This will return the time indexes were last updated:
...
August 8, 2011 at 4:21 pm
sqlfriends (8/8/2011)
August 8, 2011 at 4:07 pm
Posted to incorrect forum .. sorry about that.
August 8, 2011 at 8:07 am
Jeff Moden (8/7/2011)
bitbucket-25253 (8/7/2011)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
Our production server will be enterprise version
For the license issue, can I...
August 8, 2011 at 7:46 am
Viewing 15 posts - 1,036 through 1,050 (of 3,221 total)