Lokean
Last Activity: Sep 22 '09, 05:05 PM
Joined: Apr 2 '07
Location:
-
HTML kit has an XML editor that might get you in the right direction. -
Newbie question on a join.
I have table X.
In table X, I have 2 fields.
Field 1 is a user name
Field 2 is an account name
I want to find out if account XYZ has both User A and User B as members
I know this is simple, but I'm just out of the hospital and not thinking clearly. -
Sorry.
I am navigating through a tree structure.
Each "hold" item is a different level on the tree.
I start by feeding the query the serial number of the product I am looking for, then query for all of the parent groups that have this product in it. The product can have multiple parents.
I then go up another level to get the parents of those groups which each only have a single...Leave a comment:
-
SQL newbie, need help cleaning up my SQL (works, but ugly)
Okay, this works, but there has GOT to be a cleaner way of doing this.
Suggestions please.
[HTML]DECLARE @TMP TABLE
(
HOLD1 NUMERIC,
HOLD2 NUMERIC,
HOLD3 NUMERIC,
HOLD4 NUMERIC,
HOLD5 NUMERIC
)
INSERT INTO @TMP (HOLD1, HOLD2)
select PARENT_MEMBER_I D,null
from mydb.RELATIONSH IP
where child_member_id =2824
UPDATE @TMP
SET... -
It worked, THANKS!!!!!Leave a comment:
-
select top(1) from (whateveryouhav e)
where checkedfieldval ue = 0
or something like that.Leave a comment:
-
Access 2003: How to hide the record browser on the bottom.
Sorry if this is a novice question, but it's been about 10 years since I've used access in any depth.
I want to hide/disable the record browser on my form, I know that there is a way, but the last version of access I used was access 97, which of course does me no good.
Any help would be greatly appreciated. -
I've tried Excel(2003), the file is just too big for excel....Leave a comment:
-
newbie question: Convert XML to a table.
Sorry for this newbie question, this is not my realm of expertese.
I have searched google, tried several applications that claim they can do this, such as Mapforce, which I found confusing, to Oxygen, to HTML kit, et cetera.
I am more confused than ever.
here's my quandry.
I was sent a file and told that we need to get the data into a more readable form.
I've tried using apps to pull... -
There's the rub.
I don't know how to do that. I'm not a database programmer. I'm a .net programmer, I haven't gotten this deep into databases in over 10 years.
DB2 was the last one I had any serious hands-on with....Leave a comment:
-
Find hard coded strings in SQL: can it be done programatically?
The problem:
Company was bought out and we are bringing everything into complience. Passwords are not secure and do not need to be.(required by software we are using)
Old passwords *may or may not have been hard coded* in SQL SERVER database to validate (each account was setup with the same generic password).
Need to check each proc or function for presense of hard-coded password.
We have... -
db mail questtion: How can I clean up the format
Hi all,
I have a proc that runs once per minute that monitors the health a function of an application. When the check fails, I throw four queries at the application database to report on what the application was doing when it failed.
The problem is that the tables have very long field lengths for the columns and it makes the output unreadable.
I am a programmer and not a DBA, so I have no access outside... -
xquery help needed... can .modify be parameterized?
I know this works, but is there any way to get the query to accept variables instead of string constants.Code:set @xmlDocument.modify(' replace value of (//LogLevel/text())[1] with "TEST"')
I am not a SQL programmer by trade so I'm just stumbling around... nay help would be appreciated -
and at least on google he won't get hit with snarky answers to his queries...Leave a comment:
-
Complicated question re: Saving a file from SQL server
Our SQL server database has access databases saved as images contained within recordsets which also contain information about where the particular file came from, creation dates, et cetera.
Does anyone know if it is possible to extract those files stored as 'image' datatype in SQL server and save them to a directory (or directories) on a local machine?
I know that there are various methods to copy files, and to save... -
help needed with extracting XML data
I have an XML file that looks like this...
<Tag1>
<TagType ref="MyItem"/>
<TagRPU ref="MyCom"/>
<ItemName>Z2R74 </ItemName>
<ItemPassword>M yPassword</ItemPassword>
<ItemNumber>Z2R 74</SerialNumber>
<Description> My Thingamajig</Description>
</Tag1>
... -
To all:
Thank you for your advice.
I have found the problem.
There was a problem with the index in the staging environment that was causing the trouble.
The DBA just got back to me with the details.
I appreciate you all taking the time to answer me, you are most kind.
-Lokean.Leave a comment:
-
Processing times for SQL procs called through VB.net application
Hi all.
Here is my problem.
We have a SQL procedure that we were calling in a development environment, no problem... ran fairly fast.... no difference between the time it took to run in SQL server management studio and the VB app.
We move it to a staging environment...
The proc takes a few seconds longer to process on SQL Server, (about 12 seconds) but it takes about 3 minutes to process... -
1)Visual studio creates connection strings for you. Click on Data>> Add new datasource, and follow the prompts.
2)once you create the Visual studio datasets, the .fill and the .getdata commands will do the work for you. you just feed the parameters you need into the .fill command.
EXAMPLE.
...Code:Dim a As New LMDataSetTableAdapters.dpGetSomeDataTableAdapter a.Fill(Me.LMDataSet.dpGetSomeData,
Leave a comment:
-
Lokean started a topic In the dataset designer, how do you pass null as a parameter in the 'preview data'...in .NETIn the dataset designer, how do you pass null as a parameter in the 'preview data'...
...screen?
I am calling a procedure, and I would like to pass null as one of the parameters.
No activity results to display
Leave a comment: