This is on Microsoft SQL Server. We have a query where we are trying to join two tables on fields containing numeric data. One table has the field defined as numeric(18,2) and the other table has the field defined as decimal(24,4). When joining with the native data types, the query hangs and we run out of patience before it will finish ...
Hi there, I'm trying to write some native SQL in abap but got some problems. Here's my code: method GET_SOMEDATA. DATA: lt_table TYPE TABLE OF /BI0/TCUSTOMER, c1 TYPE /BI0/TCUSTOMER. DATA: BEGIN OF wa, customer TYPE /BI0/OICUSTOMER, txtsh TYPE RSTXTSH, txtmd TYP...
I installed SQL Server 2005 express on two computers. I installed SQL Server Management Studio Express on both computers. I ran each instance of Management Studio and connected to SQL Server using Windows authentication (one computer's connection example: "A-63A9D4D7E7834\SQLEXPRESS"). I created a database named "test1" and created a ...
So, MongoDB defaults to "AND" when finding records. For example: db.users.find({age: {'$gte': 30}, {'$lte': 40}}); The above query finds users >= 30 AND <= 40 years old. How would I find users <= 30 OR >= 40 years old? ...
I am curious on how exactly LINQ (not LINQ to SQL) is performing is joins behind the scenes in relation to how Sql Server performs joins. Sql Server before executing a query, generates an Execution Plan. The Execution Plan is basically an Expression Tree on what it believes is the best way to execute the query. Each node provides inform...
Hello, I was hoping to find an easy way to get a parameter list of a storec procedures parameters. If the proc has 3 params, I want a list like that: param1 param2 param3 It would be best to be able to do that in C# Code, but SQL would suffice as well. Ideas? Thanks!! :-) ...
Very complex query been trying to construct it for few days with more real success. I'm using SQL-SERVER 2005 Standard What i need is : 5 CampaignVariants from Campaigns whereas 2 are with the largest PPU number set and 3 are random. Next condition is that CampaignDailyBudget and CampaignTotalBudget are below what is set in Campaign ...
hi, i have a company table that is dbo.companies and has companyId as a column. I also have an invoice table that is dbo.invoices with invoicecompanyId column (which is the same as the companyId on the other table) and it also has a column called invoicedate. What i am mtrying to achieve is a view of each companyid with the corresponding...
I have a DECIMAL field which contains a date in the AS400 format : 1100614 I have tried : cast (MYDATE as DATE) : can't cast DECIMAL to DATE, DATE(MYDATE) returns null. How do I cast this field in a DATE field ? ...
I need to change the way I am storing information in the DB. Because the query works slow with the old model I had developed. General problem is following. 1) I have list of courses, and each course has list of tags describing general content of the course. For instance, the course called "Database Management Systems" could have follow...
Hi, I have a stored procedure that, ending with a SELECT, returns a recordset. I can call it within anoher stored procedure like this: EXEC procedure @param How to get the returning recordset? Thanks ...
Hello, I got question about IDENTITY_INSERT. When you change it to ON, SQL Server automatically changes AUTOINC_NEXT value to the last inserted value as identity. So if you got only one row with ID = 1 and insert row with ID = 100 while IDENTITY_INSERT is ON then next inserting row will have ID = 101. I'd like it to be 2 without need ...
I am working with an insert trigger within a Sybase database. I know I can access the @@nestlevel to determine whether I am being called directly or as a result of another trigger or procedure. Is there any way to determine, when the nesting level is deeper than 1, who performed the action causing the trigger to fire? For example, w...
I am building access database that will get data from a outside source and place it in a table that is link to the data source. As we all know that you are not allowed to recinfigure that linked table. What I want to do is take that data from that that linked table and make another table that I will be able to add additional new fields ...
I have a SSIS 2008 package that calls about 25 other SSIS packages. Each of those child packages loads a specific file into a table. But sometimes one or more of these input files will be missing. How can I let a child package fail (because a file is missing) but let the rest of the parent package keep on running? I've tried increasi...
Hello, I have a table with OWN_ID and OWN_Email - own_id | own_email ----------------------------------------------- 3ace7cf80edd | [email protected] 3acf6af33ff7 | [email protected] 3acda2524e00 | [email protected] 3ad75583c9a7 | [email protected] 3ad74b018999 | [email protected] etc. the problem is th...
I am running an Oracle query. It seems to work except that it returns 4 duplicates of each result. Here is the query: Select * from ( Select a.*, rownum rnum From ( SELECT NEW_USER.*, NEW_EHS_QUIZ_COMPLETE.datetime FROM NEW_USER, NEW_EHS_QUIZ_COMPLETE WHERE EXISTS ( select * from NEW_E...
I've got a homework assignment that requires that I use Oracle 10g Express to implement an Object Relational database to track phone billing data. I have a superclass of Communications with subclasses of Call, Text, and Data. I'm hitting a snag with properly populating these tables so that I can find the appropriate data in the various...
When I right click on "databases" in Sql Server 2005 Management Studio and then > Attach... > Add I get the following error: C:\Documents and Settings\Administrator\My Documents\SQL Server Management Studio\ Projects\Path\To\MDF\And\LDF\Files\ cannot access the specified path or file on the server. Verify that you have ...
I have an Access 2007 report that prompts for a range of dates. It is using the SQL Query: SELECT Calls.CallID, Contacts.County, Calls.ContactID, Calls.Date, Calls.Subject, Calls.Notes, Calls.Time FROM Contacts INNER JOIN Calls ON Contacts.[ContactID] = Calls.[ContactID] WHERE (((Calls.Date) Between [From date: ] And [To date: ])); Th...