Viewing 15 posts - 2,596 through 2,610 (of 5,590 total)
Data conversion should be faster
November 2, 2010 at 11:10 am
homebrew01 (11/2/2010)
Do they get an error trying to access the data ?
Were they able to get data before, but now they can't ?
What application or method...
November 2, 2010 at 11:08 am
LOOKUP_BI-756009 (11/2/2010)
Thank you so much WayneS :-D.The [] did the trick
I'm glad it worked for you. I have to admit, I thought you had used double-quotes there...
November 2, 2010 at 11:06 am
george sibbald (11/2/2010)
November 2, 2010 at 11:04 am
It really sounds like less of an import problem, and more of a "Garbage-In, Garbage-Out" issue. The delimited file is missing a delimiter, so the file is Garbage. You really...
November 2, 2010 at 11:02 am
cmayeux (11/2/2010)
If I wanted to include a sequence number (1,2,3,,,) for each point based on the order within the XML, how would I do...
November 2, 2010 at 10:55 am
keymoo (11/2/2010)
Sorry, here you go 😀
INSERT INTO [orders] ([orderId],[tradeId],[units],[side],[price],[spread],[strategyId],[signalTypeId],[brokerId],[orderTypeId],[orderDateTime])VALUES(12,4,2,'S',1.359400,1.00,3,'IE',1,'SM','Feb 15 2010 7:00:00:000AM')INSERT INTO [orders] ([orderId],[tradeId],[units],[side],[price],[spread],[strategyId],[signalTypeId],[brokerId],[orderTypeId],[orderDateTime])VALUES(14,4,1,'B',1.364100,1.00,3,'MX',1,'BM','Feb 16 2010 7:00:00:000AM')
INSERT INTO [orders] ([orderId],[tradeId],[units],[side],[price],[spread],[strategyId],[signalTypeId],[brokerId],[orderTypeId],[orderDateTime])VALUES(13,4,1,'B',1.359700,1.00,3,'XXX',1,'BM','Feb 16 2010 7:00:00:000PM')
Profit should be the...
November 2, 2010 at 10:10 am
keymoo (11/2/2010)
Sorry, here you go 😀
INSERT INTO [orders] ([orderId],[tradeId],[units],[side],[price],[spread],[strategyId],[signalTypeId],[brokerId],[orderTypeId],[orderDateTime])VALUES(12,4,2,'S',1.359400,1.00,3,'IE',1,'SM','Feb 15 2010 7:00:00:000AM')INSERT INTO [orders] ([orderId],[tradeId],[units],[side],[price],[spread],[strategyId],[signalTypeId],[brokerId],[orderTypeId],[orderDateTime])VALUES(14,4,1,'B',1.364100,1.00,3,'MX',1,'BM','Feb 16 2010 7:00:00:000AM')
INSERT INTO [orders] ([orderId],[tradeId],[units],[side],[price],[spread],[strategyId],[signalTypeId],[brokerId],[orderTypeId],[orderDateTime])VALUES(13,4,1,'B',1.359700,1.00,3,'XXX',1,'BM','Feb 16 2010 7:00:00:000PM')
I think you might...
November 2, 2010 at 10:04 am
WayneS (11/2/2010)
the profit is
entry price - next exit price for each entry
So, purchase price (p.Price) minus sale price (s.Price).
It definitely seems to me that the "profit"...
November 2, 2010 at 9:44 am
Perry Whittle (11/2/2010)
WayneS (11/2/2010)
We're having an outage this weekend when we're upgrading to SQL 2008... I plan on using this time to do this.
Good luck with the upgrade Wayne, be...
November 2, 2010 at 9:40 am
DECLARE @cmd1 nvarchar(2000)
SET @cmd1 = 'IF ''?'' NOT IN(''master'', ''model'', ''tempdb'', ''msdb'')' + 'BEGIN '
+ 'Print ''Populating Login Audit table for ?...''; '
+ 'INSERT INTO [AW]..[Audit]([Login Type],srvLogin,srvRole,dbUser,dbRole) ' +
'select
[Login Type]=
case...
November 2, 2010 at 9:25 am
Saravanan_tvr (11/2/2010)
ThanksBut I got this Below error
Msg 208, Level 16, State 1, Line 7
Invalid object name 'dbo.Tally'.
I cant understand why u using the above table name..
You might want to check...
November 2, 2010 at 9:18 am
Assuming @theXML is of datatype XML:
declare @theXML XML;
set @theXML = '<Polygon>
<PolygonId>8343f355-a26b-4db7-adc0-b2715a9ea2f9</PolygonId>
<Parts Count="4">
<Point>
<PointId>b905ea74-55de-42ee-8373-42fa5ca6e5e7</PointId>
...
November 2, 2010 at 9:16 am
Sounds simple... if the database is designed right.
I assume that you have a table of species (cat, dog, reptile), and a table of types (bulldog, doberman) that point to the...
November 2, 2010 at 9:12 am
November 2, 2010 at 8:54 am
Viewing 15 posts - 2,596 through 2,610 (of 5,590 total)