Viewing 15 posts - 211 through 225 (of 654 total)
mmm. what are you using for your front end app. in asp .net u can make use of disconnected recordsets. as for the computations and data formatting, that should really...
July 22, 2007 at 12:50 pm
you can try to use table hints in your select statement,i.e.
CREATE PROCEDURE [dbo].[GetWFSAInfo]
@WFSAID int
AS
SELECT WFSA.*, FirstName, LastName, EmailAddress, LoginName FROM WFSA, WFSAUsers WITH (NOLOCK)
WHERE WFSAID=@WFSAID AND WFSA.CreatorID =...
July 22, 2007 at 12:02 pm
try http://www.quest.com/Toad-Data-Modeler/ but you will probably not get everything in your requirement set.
July 22, 2007 at 11:49 am
kavita,
I am failing to exactly understand your problem. Which part of the code above is the XML?
July 22, 2007 at 11:46 am
have you registered any servers in EM? was it working properly before
July 22, 2007 at 11:37 am
Jim,
What processing are you doing in your stored proc? if possible can u post the stored proc dml
July 22, 2007 at 11:34 am
you will have to:
create a signed assembly in .net environment
create an asymentic key on sql server for the .net assembly
grant EXTERNAL_ACCESS or UNSAFE permission set to the .net assembly
probably...
July 22, 2007 at 11:23 am
Ben,
The relevance of the Hier_level is it shows the position of the task in the path. i.e.
for PATH 1
1. Reporting - Cynthia Reece/4813 ===>>> 2. Interconnectivity...
July 20, 2007 at 12:29 pm
you can try cute pdf, but its not free http://www.cutepdf.com/ pdf sdk
from their sample code you will be doing something similar to
Dim objMyForm
Set...
July 20, 2007 at 8:57 am
> I need the data to be replicated to server B, after, the data be deleted on the server A.
I didn't think this was still replication, because the rows that are on B...
July 20, 2007 at 7:09 am
i will substitute your use of the word hierachy and use order by. to me your problem seems to be a network path problem akin to project management. you are...
July 20, 2007 at 6:59 am
you would need to get the pdf form API/component/ DLL
July 20, 2007 at 6:26 am
some developers usually create their forms using e.g. word and then print it to a pdf printer. the reason being the ease of use of the the apis that are...
July 20, 2007 at 6:23 am
why are you using a dts pkg to update a field in table. presumably it is much easier to do in in your stored proc.
July 20, 2007 at 6:19 am
... where SomeColumnName LIKE '%' + @ParameterName + '%'
July 19, 2007 at 8:56 am
Viewing 15 posts - 211 through 225 (of 654 total)