Search results for query: *

We're are going to be using transactional replication for bi-directional data flow between our ERP at one physical location and our e-commerce store at a secondary physical location. There is a tunnel between the two locations to support secured data flow. We're having much heated debate...

SQL Server 2005 Standard I need to copy specific records from server 1, table A into server 2, table A. (2) physical servers with there own instance. The tables are identical between the servers. I need to copy records from one into the other to recover lost data. I've been playing with...

I wrote the following query wanting the results to be one row with a sum for column1 and column2 as the fields. However, I'm getting 20 records results with a sum by the field ledgertrans.accountnum. Appreciate some assistance with getting the desired result. Thank you, Andrew...

SQL 2005 I'm trying to eliminate a division by zero issue. Can someone assist with proper syntax for a statement like; if sum(Field 1)[denominator] = 0 then 0 else sum(field 2)[numerator]/sum(field 1) [denominator] Fields 1 and 2 also need to be summed. I keep getting an invalid expression...

SQL 2005 Table A (Item Master) Table B (Item Location) There is 1 record for every item in the item master TABLE A. There are 3 records for every item in the item location table, TABLE B. I want to join the (2) tables and have the results be just 1 record per item where the quantities in...

SQL 2005 we have a situation where we have a master sales header table that holds all sales records, however, we have (2) sales line tables, with unlike data structures that hold the aggregate of the sales lines that are associated with the headers. table A = sales header (3 records, 2 from B...

Not sure the best practice for accomplishing this requirement in a select query; I want to query FIELD 1 in Table A if FIELD 1 = ABC then query another field for it's value if FIELD 2 = XYZ then 2 else - 2 else 0 the result of this query...

I have a query set result of 135,000 records that I need to get into Excel. Excel is limited to about 65,000 rows. I'm aware of the TOP function where I could select the TOP 65,000, leaving me with the remaining or bottom 70,000 records in the query results to get into a second Excel file...

I want to query a column from a table, evaluate the value in that column (column 1). If the value in column 1 is > 0, input that value into column 2, if the value in column A is < 0, input that value from column 1 into column 3. ex: column 1 column 2 column 3 -5...

I want to create a global distribution list that will include both, corporate email accounts from our GAL, and also, a few external email accounts. ex: A distribution list with both corporate staff and staff from a consulting firm that we are working on a project with. Appreciate your...

I want to link my inventory master to my sales history to display sales by item (sku). The issue is, I want to return all items from the inventory master, even if they have no sales. (Not have a corresponding record in the sales history table). Once I link the two tables, all items without...

IS there a way to variablize, or make as a parameter a grouping? All our reports have the same columns with the same calculations, same parameter (Date Range). We have many reports that are identical, other then how they're grouped. Sales by state, sales by customer, sales by product. These...

WHat is the appropriate syntax to convert a field from a char(65) to a int datatype? I need to convert the following field [Quantity] in the following line; Min(Case When PT_UD_Number = 5 Then LongName End) As [Quantity] Thanks in advance, Andrew

crystal 8.5 I have a report design off a sql view. In Crystal, I'm grouping by a field in the view that has null values. I've created a parameter on this field with null values. When I generate the report the null values do not return. The null values return in my sql query so I know they're...

SQL Server 2005 STD SP1: I want to add a field from third table [TABLE3]. TABLE3 can link to TABLE2 via a key Field [Field2]. I'm not sure how to correctly add a TABLE3 to the existing, and working properly joined TABLE1 and TABLE2 script. Can this be done, and if so, what is the proper...