Viewing 15 posts - 91 through 105 (of 3,221 total)
To help those who will attempt to help you ... can / will you provide the table definition (or those fields pertinent to your question), some sample data and the...
May 30, 2013 at 1:28 pm
Might I suggest using the UPGRADE ADVISOR and carefully reviewing the results
upgrade advisor is available at;
http://www.microsoft.com/en-us/download/details.aspx?id=11455
May 3, 2013 at 6:11 am
NOTE Sean Lange's comments should / must be given every consideration...
although the following will do the task you require You might want to modify your T-SQL statement to:
...
April 26, 2013 at 8:09 am
ChrisM@Work (4/25/2013)
-- This query should return the rows you want to keep
SELECT MemberId, [Event], [Event Date]
FROM (
SELECT MemberId, [Event],...
April 25, 2013 at 6:27 am
If I understand your question correctly... try this link
http://msdn.microsoft.com/en-us/library/ms175019(v=sql.105).aspx
April 24, 2013 at 8:56 am
This might be what you need.
SELECT CHARINDEX('SN',os,1) AS 'Starting position'
,CHARINDEX(';',os,CHARINDEX('SN',os,1)) AS 'Ending position'
,SUBSTRING(os,CHARINDEX('SN',os,1)+ 3 ,7) FROM #TempAD
Results:
Starting positionEnding position (No column...
April 21, 2013 at 6:10 pm
Steve, thanks a great read particularly if one follows your link to
It has me wondering if someone will create software equal for our private homes ... and if...
April 21, 2013 at 8:08 am
Nice question - learned something from it ... Again thanks
April 17, 2013 at 8:30 pm
andrewalex.r (4/10/2013)
K, I need to change the format of the Date
You can change the format for displaying the date using the convert function. For example:
SELECT id,CONVERT(VARCHAR(10), DateValue, 101)AS 'MM/DD/4...
April 11, 2013 at 9:22 am
Thanks - excellent information
April 10, 2013 at 4:54 am
todd.ayers (4/8/2013)
April 8, 2013 at 8:23 am
Viewing 15 posts - 91 through 105 (of 3,221 total)