Search results for query: *

hi to all... though ive been designing databases for about a couple of years, they seem to be concentrated on the "supply chain" this year, im trying something new - the finance industry (investments, life insurance, etc.) though the old and tested rules of DB design do apply here - i do find...

does anyone know how to change the default data directory for Analysis Services? just to note: the default directory is usually, C:\Program Files\Microsoft Analysis Services\Data so... is there a way to change it (without reinstalling) to, say, D:\Microsoft Analysis Services\Data thanks...

the site im working on is under windows 2000 server, iis (asp), and im using excel (office 2000 and above) as my presentation layer. the problem im encountering is the way excel shows the data which is kinda funny at times. i mean, even though your refresh - it still is funny. well, if i do...

below is code snippet (which im assuming is the cause of the problem) from a certain stored procedure EXEC Master.dbo.xp_sendmail @dbuse = 'DanoneSSS', @recipients = 'xxx@yyy.co.jp', @subject = 'mmm nnn', @message = @parMessage, @query = 'SELECT CHECK_JS_CODE, CHECK_TYPE FROM T_CHECK_LOG WHERE...

just out of curiousity, can anyone show me/teach me on how to write a QUERY that would check if there are ANY CURRENTLY executing jobs? thank you very much.

TO: TheGreenOne (Programmer) btw, thanks for providing me at least a new way of accomplishing the same thing

hhhhhmmm... you are using multiple joins in a single select query... because of lack of experience, im not really sure if having ALL your queries inside ONE query is better than having ALL your queries execute consecutively anyway, my own version goes like this (wherein i created a temporary...

to psprague (Programmer) thanks for the advice i guess id do just that - stop relying on *

yeah... i have thought about that too... unfortunately, if i wanted to do an insert on it, i need to put the ENTIRE column names after the INSERT INTO phrase instead of just using INSERT INTO aTable SELECT * FROM anotherTable

having a PARENT-CHILD structure table as follows (product_level can go as high as 6) product_id int product_parent_id int product_level int product_name varchar <some data> <some type> i would like to write a script (the more efficient, the better) to create a flat version of it that...

could anyone show me a script on how to remove the IDENTITY property of a table just using ALTER TABLE and ALTER COLUMN? ps: i do know how to put define a column to be an IDENTITY column, but i would like to do the reverse thanks!

ive created a cube that shows proper values whenever i use real dimensions. well, once i add virtual dimensions, it DOES also show the correct value unfortunately, say after i restart the analysis manager console, and reprocess the cube, all values turn back to zero. and the only way i can get...

to be honest, i really dont know how to state the subject, thus id begin with the situation at hand i am to design a cube for a supply chain-based company with the following dimensions = time (granuality of days), product (granuality of sku), organization (sales group/team), and customers...

yeah... i too am experiencing the same thing... im using PTS in Excel 2000 is there any fine-tuning stuff for this? i wonder how this would affect an excel file embedded in an HTML frame? ie., the excel file containing the pivot table is hosted on a server where clients can connect to, and...

forgive my ignorance, but could anyone help me how to create a &quot;parent-child&quot; table using nothing but SQL Server Scripts? and be able to enforce Referential Integrity by an &quot;automatic&quot; delete the problem is that my script below doesn't seem to work... CREATE TABLE...

a good discussion/discourse about using recursive algorithms for heirarchical data (in sql server) has been presented at msdn at this url: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/recursion.asp and as you'll note - some sample codes are also available...

im quite new to CrystalReports, and have this problem that ive been trying to solve for days now without any success... SQL Server 2000 Analysis Services comes with a FoodMart 2000 sample database that has FIVE (5) cubes - two (2) of which are virtual cubes of the others: + Budget + HR +...

.... WHERE Isnull(dst.Product_Name,'') <> IsNull(Src.Record_Name,'') AND IsNull(dst.Product_Value,'') <> IsNull(Src.Record_Value,'') i tried the code, and wouldn't you think that an OR would be better... say, a product could change how much it cost (product_value) without changing its...

Just make sure you get the right book....I made the mistake of getting a book by Calvin Klein .....didn't help me a bit. Sorry for the bad joke....its a bad day. sure... no problem... (^^) it actually made me look through the previous post if it was indeed calvin klein

Another way to implement the above scenario would be to use triggers. You could create an ON INSERT and an ON UPDATE trigger for the Source table, and code the triggers to perform the inserts into the destination tables. Check out BOL (Books Online) for more info on triggers (or feel free to...