Answer Questions

• rachbabe Query Oracle Table In SQL & Put In Temp Table

  Hi all, I am querying a table in oracle, the server connection to the Oracle database is determined by a criteria. Though how can I put the results from the oracle query into a temp table This is the code i'm using for the query: DECLARE @cmd VARCHAR(500) declare @Year varchar(25) set @Year = '2006' DECLARE @Link VARCHAR(100) DECLARE @Table VARCHAR(100) select @Link = Server from tbl_Conn where Area='Floor' select @Table = Target_Table from tbl_Conn where Area='Floor' SET @cmd = ' select * from OPENQUERY ( ' + @Link + ', '' UPDATE '+ @Table +' SET TARGET_VALUE = '+@Value+' WHERE Date = '+@Year' '' ) ' EXEC (@cmd) How do I put the executed results into a TEMP table Rgds, ...Show All

• GSK_phili Is there a way to add a Database Property?

  I got to thinking how nice it would be if there was a way to add a new Database Property that was just a simple text field with a 'friendly' description of the database. Is there any way to add this Thanks for the tip! This will work perfect! Hi Sandy, Yes, you certainly can.  Have a look for "Extended properties" in BOL.  Otherwise, you can add extended properties via SSMS under database properties.  Extended properties can also be bound to individual columns or tables. So, to add a property to YourDatabase you would: USE YourDatabase GO EXEC sp_addextendedproperty @name = 'DBDescription', @value = 'DescriptionHere' Cheers, Rob ...Show All

• Becker2 Seemingly odd ordering of results with/without TOP and/or index

  I've been trying to find out why a simple query containing a couple of top-level order bys produces different results when I introduce TOP into the query. I've found nothing so far, other than the results of both queries (TOP and non-TOP) are different again if I add an index. All the DDL and DML is below, along with the results. The database uses the BIN2 collator. I guess there's a simple explanation for this... DROP table employee CREATE TABLE employee ( id INTEGER IDENTITY (1, 1) NOT NULL, givenname NVARCHAR (20), familyname NVARCHAR (20), CONSTRAINT pk_employee_id PRIMARY KEY (id) ); insert into employee values('John', 'Smith'); insert into employee values('John', 'SMITH'); insert into employee values(' ...Show All

• in.the.dark Sum function: only on specific rows

  Hi, I have a table where I want to use the sum function, but only on the rows with a positive value. Is there any way to do this Heidi, I Suppose you want somthing like this: select customer, sum(amount) from orders where amount >= 0 group by customer Hi, if you know the data type of your values you can sum only the positive values in the following way: example data type: double =Sum(iif(Fields!Amount.Value > 0, Fields!Amount.Value, CDbl(0))) if you don't know the data type exactly you can do it this way, but watch out that you not choose a data type which is too small for your data: =Sum(iif(Fields!Amount.Value > 0, CDbl(Fields!Amount.Value), CDbl(0))) ...Show All

• xwinterx Report server cannot open a connection to the report server database

  I am getting the following error, when trying to deploy. the report should point to a server which is in my network, but the report is on my machine. where i am trying to deploy locally but point to a different machine. ****************************************************** The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. *********************************** Thank you very much for the information. Jarret, That was my mistake i recently changed my systems password, that did'nt get updated for the services. so the services are not running, i had to go to each service and update the new passw ...Show All

• AnilKumar_bhaskara Need Help: For Cube data in Multi Languages.

  Dear Friends.. I need help if any one can... My need is that...I am devloping my Cube using SSAS. I want to access my cube in multi languages e.g.: English, Japanese or other. At the movement I have two languages description in SQL Database like English and Japanese. But In SSAS Translations, I can translate Measures Groups, Dimensions, Perspectives, KPIs, Actions, Named Sets & Calculated Members names. But there will be a need to Map Columns as per selected Lenguage so that I can display in proper language data. Suppose I select Japanese the description should come from Column where Japanese description is stored. OR any othere method by doing I can see my reports/data in any language. Please Help... ...Show All

• Dr. YSG Linking to External Tables

  I am trying to create a single query from 2 tables on different SQL servers. In Access 2003 I have been able to accomplish this by created a Linked Table via ODBC connection to a table then create my query reference the linked table. Is something link this possible with SQL Any direction would be greatly appriciated! Scenerio: Server1 Books Book_ID Book_Author Book_Title Server2 PurchasedBooks Customer_ID Book_ID vPurchasedBooks (View on Server 2) Customer_ID Book_Title (Joined on Book_ID on Server1\Books) Yes, look up linked servers in books online. It is pretty easy to do. You can also use OpenDataSource and OpenRowset to do this without setting up a linked se ...Show All

• Lenoire77 Which SQL priveledge is required for SQL user to execute DTS job?

  Question regarding SQL Server 2005 (sp1) Hello, I need to give a domain user the ability of executing a DTS package from command line using DTS run and I needed to know what specific grants to give to that user to databaseA 1. I added a domain user (domain_name/user) to the SQL Server and granted ddl_reader/writer and admin role. 2. installed SQLclient on user machine and showed user how to execute dtsrun.exe command with /E. I am not sure if these priveledges are correct. can somebody guide me on this thanks, Jigar Yes that should be ok to create the DTS package and underlying table permissions. Are you getting any issues with these problems there are new database roles provided in MSDB of S ...Show All

• Jarodtweiss Load Data using ADO.NET in SSIS

  Hi, How to extract and Load Data using ADO.NET in SSIS.i hope to extract data we have DataReader source .but how to load (Insert) data with ADO.NET .and is ADO.Net  quicker than OLEDB Thanks Jegan.T   Where are you loading it to SqlServer and OleDB Destinations will be the easiest, and most performant since they will do a bulk insert. Sean, Thanks for the Informations.But still as a part of our analysis .we need to load in to Oracle Database. can i know how to load data using ado.net . Thanks Jegan.T Jegan, you can use .NET, Ole DB or ODBC providers to load data in to Oracle Databases, and these are all possi ...Show All

• MR_ED Sql Monitor or something to manage SQL

  Hello Everybody: I need something to manage my querys in SQL server 2000. I dont know how to make a graph of the querys from the users, or make some kind of report of store procedure (user's store procedure, querys, etc), and i'm not talk about Performance Tools of Windows 2000, i need something more complete and visual. any information about this will be very useful. thanks can you be more specific about your requirements it sounds like to me that you want a report of queries being ran against your server, but I am not sure Right...i need something like "Performance" of windows 2000, but more complete..any info about this Derek Comingore wrote: here is a lis ...Show All

• Haplo_69 What is the alternative to "go" under sqlcmd?

  Hi I found it a bit annoying to type Go after some very simple query and I wonder is there a short cut to execute the query i type right after I press enter 1> select * from Table 2> go <enter> instead, how to you execute line 1 without entering go Thank you Thanks for the suggestions from everyone I am new to sqlcmd and sql server that's why i come up with this sort of question ;-) You can choose a one-character alternative to GO with the -c switch (for osql or sqlcmd), or you can write a batch file or script to do this for you. Really, how hard is it to type GO Steve Kass Drew University Batikit@discussions.microsoft.com wrote: > Hi > > I found it a bit annoying to type Go ...Show All

• Emre &amp;#199;etinkaya Time Series only predicts one step

  I have a relational table with daily sales for 364 days (52 week span) for 60 stores. I have created a Microsoft Time Series model using store as the case and the historical/actual line charts appear in the Charts viewer for each store. But only one prediction step is shown no matter how many prediction steps I select. I have tried this with an OLAP-based model and also tried a simple DMX query, all with the same result. Thank you in advance for any help with this. P Taylor I have a similar experience with time series that have seasonal behavior as well as "drastic" upward or downward trends in the last few observations. Is there a way to control the heuristic that truncates the predictio ...Show All

• winstonSmith Lock and unlock the table

  Hi, How would I lock a table so that the access calls from other applications are put in "wait" by sql server till I unlock How would I do this Thanks, Fahad Could you please explain your problem Locking entire table hurts concurrency and performance. Maybe there are other ways to do this. Tom Phillips wrote: MS SQL, and most "server" based databases, don't do that unless they absoulutely need too, and it is done by the engine, not the user. What is it you are trying to do and why If you just want to make sure someone doesn't read partially updated data, use a transaction. I need a synchronization between two processes which are accessing a table, both are initiated with a second of differenc ...Show All

• Geo725 Ignoring NULL values in LOOKUP transformation.

  Hi, Can you please tell me the way to configure the LOOK UP transformation so that it will ignore all the null values I want to configure a Look up component for the column "Col1" as follows All the NULL values of Col1 should not be considered for look-up process. They should be passed to the downstream component as valid rows. All NOT NULL values of Col1 should be processed by the Look up component. If there is no matching value present for any NOT NULL value of Col1 then it should be directed to error output. Regards, Gopi If you pass the NULL Col1 records to the lookup, you would need an entry in the lookup table to handle the NULL. otherwise, it will fail the ...Show All

• Kukyona Archive & Restore design question

  Hi, I have a design question. So, I am designing an web application that will store lots of data. Because of that we need to allow administrator users to archive some of the data. However, the user needs the ability to view the archive data (just to know that it is there) The administrator user can restore the data by using the web application. My design includes 2 databases, one for the actual data, and the second for the archive data, and I manipulate it by moving data from one database to the other. What do you think about that Another thing is the fact that every month administrator will want to empty the archive database and save it on a disk. What is the best way of doing so and lets say i want to take one of the ...Show All