Viewing 12 posts - 91 through 102 (of 102 total)
Hi,
This would be my approach...
Create a function that modifies the string to include the desired '&' and then modify the table as below:
USE [YourDBName]
GO
/****** Object: UserDefinedFunction [dbo].[PrettyPetNames] ...
October 21, 2009 at 2:30 am
Hi,
If you would like to delimit your export with a pipe instead of a coma, try this:
1. In the export data wizard, select flat file destination
2. When it comes to...
October 21, 2009 at 12:25 am
Strange problem you have, I'm having a hard time thinking of what the real life application of this might be. I would have expected inserts and not updates...but anyway...
I'm not...
October 20, 2009 at 5:29 am
diamondgm (10/16/2009)
diamondgm (10/16/2009)Firstly, we assume that the average is the result of an even spread (that the average length is in fact 8.5 - we only need an average of...
October 16, 2009 at 3:53 am
diamondgm (10/16/2009)
October 16, 2009 at 3:20 am
Firstly, we assume that the average is the result of an even spread (that the average length is in fact 8.5 - we only need an average of 8 for...
October 16, 2009 at 12:31 am
This may not be the best way of doing it, but it's how I would do it:
DECLARE @MaxSN INT
SELECT @MaxSN = MAX(SEQUENCE_NO) FROM Operation
/*JOIN On to this result set*/
SELECT...
October 16, 2009 at 12:03 am
I'm not sure if one can seperately purchase SSMS, my guess is that you can't. I do however know that depending on your requirements, SSMS Express may be an option...
October 15, 2009 at 11:38 pm
Hi Wallace,
I can't find where BOL says that it will round to 0.33ms, but if I understand your situation correctly, 0.33ms rounding is no problem for you.
You want accuracy within...
October 14, 2009 at 1:49 am
Hi,
This is what I would do, I hope I understand your problem and that this helps you:
SELECTCO.ROWID,
CO.CUSTOMER_ID,
DSL.DEMAND_BASE_ID,
DSL.SUPPLY_BASE_ID,
OP.WORKORDER_BASE_ID,
MAX(OP.SEQUENCE_NO)
FROMCUSTOMER_ORDER CO INNER JOIN
DEMAND_SUPPLY_LINK DSL ON CO.ID = DSL.DEMAND_BASE_ID INNER JOIN
OPERATION OP ON DSL.SUPPLY_BASE_ID...
October 14, 2009 at 12:07 am
Viewing 12 posts - 91 through 102 (of 102 total)