aas4mis
Last Activity: Mar 11 '13, 10:55 PM
Joined: Jan 16 '08
Location:
-
The only memory limitation I'm aware of is on a 32bit system. I believe the VAS mem area caps out at 4 gig; virtually unlimited on a 64bit system. Not sure if it's your problem, but something to look into. I've ran into this issue with linked servers, namely an old ODBC driver connecting to a Pick UniVerse db. I've used the following SP to monitor my memory when I was having these issues. Pick UV (rocket software) has fixed the memory leak (as of... -
There is an index on t1.item_identif er (item_master), but not on the view. The view combines quantities from multiple sources (Online,WMS, EDI, etc...), then joins the sources together and aggregates the total quantity. t2.ID_X may or may not exist in T1, which is why I used COALESCE to choose the correct identifier to match t1 on. I'm on a time crunch at the moment, so I created 4 procedures, each procedure joins and updates on t1.item_identif ier...Leave a comment:
-
Join T1.distinct_identifier to T2."choice"_identifier
I've got a primary key on t1 (Item_Identifie r) and on t2 I have 4 "item" fields. t1 is the master identifier and is derived from one of the 4 fields in t2. I'm currently trying to join on a COALESCE function, but it is taking way too long. I end up cancelling after about an hour of letting it run. Does anybody know a faster alternative to the following query?
...Code:SELECT ... FROM tbl_Enterprise_Master_Items item_master
-
Modify "Script Table as" template
Does anybody know if it's possible to modify the "Script Table as" template within SSMS (2008)? If not, is it possible to add another template so that when I right click an object (table) in the object explorer I'm able to use my own template?
Not looking at the Template Explorer, just looking at the right click function in Object Explorer.
This is more of a pet peave than anything, I'd like to use my own... -
Thanks Rabbit, I'm not at my work pc at the moment. Do most objects have a FromName method? My sql table will be feeding a lot of properties if so.Leave a comment:
-
I've also tried the following. Same issue, need to get property type and cast before inserting "Value".
Any words of wisdom would be appreciated. Thanks!
Code:'Doesn't work txtTextBox1.GetType().GetProperty(Name).SetValue(txtTextBox1, Value, Nothing) 'Works txtTextBox1.GetType().GetProperty(Name).SetValue(txtTextBox1, DarkBlue, Nothing)Leave a comment:
-
Dynamic properties via CallByName
Is it possible to assign control properties from a SQL Server table? This is the closest i've been able to come. It errors out due to the fact i'm passing a string and not the correct property type. Any way to implicitly convert the string to the correct property type? Possibly be getting the correct type from the "Name" value? Just thinking out loud.
As always, thanks to the scripts community for your help (I mean bytes.... -
Nevermind.. :) Looks like the 'str' inside of the Double.TryParse () needed to be 'str.Value'. I'll load this into sql and post back if it works.
Thanks!
(you know, it's bad enough to talk to ones self, but to answer ones self??).. ProgrammersLeave a comment:
-
CLR for sql server 2005
I know this is C#, but thought the SQL community would know better. I'm trying to get a CLR compiled to handle a Double.TryParse () via TSQL and the code won't compile.
I'm no C# guru, found this code on the web when looking for a way to try_parse in earlier versions of sql (2005).
...Code:using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlTypes;
-
... not leaving without posting my results, just haven't had an opportunity to get back on this. ... deadlines. :(Leave a comment:
-
Ruheeeally? I didn't realize a variable declared in dynamic sql would exist outside of that scope and be available to use in the calling stored procedure I thought that was only true for tables.
I'll give it a shot and let you know if it works. Thanks CK!!!Leave a comment:
-
Thanks for the reply, but I don't think I got my point across. I'm familiar with dynamic sql, but my struggle is DECLAREing the variables programmaticall y. Once this is accomplished I'll be a happy camper. :)
I'm looking for a way to get lines 34 and 35 to work. If I can get this to work I can setup a master table of variables/settings for use in multiple stored procedures. My settings would be easily maintained and updated across...Leave a comment:
-
Must not be possible. Usually the responses are pretty quick around here. .. I hope somebody benefits from the "fake cursor". :)Leave a comment:
-
dynamic variable names from table
Is it possible to DECLARE variable names and set the values in TSQL dynamically at the start of a stored procedure so that the "setting/value" pairs may be used throughout the stored procedure?
Something along these lines...
...Code:-- settings table CREATE TABLE tbl_Settings ( SETTING_ID int IDENTITY(1,1) NOT NULL, SETTING nvarchar(max) NOT NULL, VALUE nvarchar(max) NOT NULL
-
Junction Table or bit field?
I'm curious on the best way to start my IT Inventory database.
a few key bullet points
1 - need to be able to tell where a piece of equipment is at any given time.
2 - need to be able to recall previous repairs and resolutions
3 - don't want to have to search all records for 'active' repairs
Part of my concern is whether to use a junction table for active repairs, or to use a bit field on my repair... -
Thanks for the suggestion CK, but I believe I have this one whipped.
[code=sql]
SELECT t1.devId, t1.daValue as assetname, t2.daValue as ipaddr
FROM tDeviceAttribut es t1
INNER JOIN tDeviceAttribut es t2 on t1.devId = t2.devId
WHERE t1.daName='user Attribute.asset name' and t2.daName='user Attribute.adapt er.pccardx5cpho ton1.ipaddr'
ORDER BY assetname
[/code]
results:
devid...Leave a comment:
-
There's still the issue of missing attributes. Say devid 1 has ipaddr and assetname, devid 2 has assetname, devid3 has assetname.. won't devid 2 and devid 3 now have devid 1's ipaddr? sorted by devid that is....Leave a comment:
-
Oops, my mistake. Typo, I just copy/pasted the "needs to be" table, only the first row is correct. But this illustrates a good point, the suggested query would've done the same thing, since it's ordered by devId but apparently a couple attributes are MIA....Leave a comment:
-
Thanks ck9663, but I don't think this is the correct route. The suggested query relies on the previous row, regardless of identifier (in my case devId). Should a device be missing an attribute the next device will receive the wrong value. I'm thinking this would best be solved with a self join, but not sure how to implement it....Leave a comment:
-
No, unable to normalize. This is not my DB, actually designed by motorola (and works for their purposes). I'm making a custom web page to interact with the database and need this query for a stored procedure. I don't see where this would be slow as there are less than 7,000 total records in this table. Surely there must be a clean way to write this. ... is there are Shirley in the building???...Leave a comment:
No activity results to display
Leave a comment: