Search results for query: *

Hmm, I can't seem to change the owner of the jobs to anything. When I click on owner it only shows my login and [sa] but when I try to change it to [sa] and exit out it still says it's owned by me when I check. Maybe I don't have permission to do that. Is it possible for me to change how Excel...

Oops, forgot to include my Excel side of things. Public cn As New ADODB.Connection ServerName = "blahblahblah\yaddayadda" DatabaseName = "PSME" 'Specify the OLE DB provider. cn.Provider = "sqloledb" 'Set SQLOLEDB connection properties. cn.Properties("Data...

I have created a number of jobs that call SSIS pacakges to import data and stuff. In Excel I've set up an interface that lets me run these jobs by calling stored procedures that call the jobs, etc. Works perfect. Yay! But... When I had another user test this out it fails. Well it turns out that...

I have a table that lists a business code and then 5 fields of business information. Other tables will refer to that table using the business code to get business information. Once in a while one or more of those 5 fields will have a change. When we make a change we only want it to apply to new...

Well now I feel like an idiot. There was supposed to be no duplicates in either table, making this a 1 to 1 query. Digging further into this I discovered that the older table DID have duplicates. Evidently we need to put an extra step into the process to get rid of duplicates. I could have...

Yep! I was just coming back to post that it's because of duplicate results. But this still confuses me. Neither table has duplicate records based on the AcctSchd and Idms_Region key provided in the query. So how am I getting a few duplicate lines in the select query like that? This worries me...

Hi Markros, thanks for the reply. I've never used CTE's before (still learning here), but I gave this a shot. Same results as with just a straight query unfortunately. I'm just not sure how this is possible. I tried inserting the data into a new table and trying it against the new table with...

As I was double checking some of my queries I discovered an oddity. An update query I have updates 12831 records, but the identical select query shows 13022 records. Aroo?? The query updates one field to "X" based on some criteria. There's nothing special about the field. It's set as...

Oophda, this is a tough one to explain. The little gerbils in my brain are squeaking their wheels in a way that makes me think I can do this but I think they need a few nudges. We have a table with account numbers, status codes, status dates, and a number of flags. Part of our metrics involves...

Thanks you two, I'll give these a shot when I'm able. The one by bborissov seems especially straight forward to my neophyte SQL Server skills. Markros, I'm not entirely sure I understand yours fully. What does ";with MaxDates" do? And then where does your "tbl1" come from and what does "cte...

Thanks, bborissov. I see where you're going with that. But what about the current date field? I need the max of that too. I need the max(current date) first, and then within that I need the max(status date). Otherwise it's possible an older current date could have a status date that is newer...

Hi everybody! We're upgrading from an Access 2003 database to SQL Server. I'm a complete neophyte to SQL Server but of course have a passing knowledge of SQL from Access and VBA. Currently one step in our project is to remove duplicates. What I do right now is go through the recordset and...

RiverGuy, thanks for the filtering tip. I think that'll help the guys a bit as we start getting more in our list. That should work pretty good as long as we do a decent job with our naming convention.

Hi, is there a way to create folders in the "Tables" or "Stored Procedures" groupings? We're going to have a number of tables and procedures and it'll start to get very confusing if it's all just one big long list. Even if we do something like...

Hopefully this is the correct forum for this question. I've recently been designated to be the developer for a large project that will eventually involve some data analysis and reporting. We started out using Access as that is the only tool currently available to us and we quickly learned that...

Wow, thanks George. That'll come in very handy once I can get my grubby paws on a real version instead of Express.

Ahh, ok. Thanks for the tip. So when we go to the full version of SQL Server, instead of playing around with Express, and I have access to SSIS you think that I will be able to do what the wizard does? I don't doubt that there's some goofy data in the flat files. They're dumped from Business...

Hi, we're in the process of moving from a bunch of Access databases to a SQL Server environment. I have no experience with SQL Server (we use a lot of Excel, Access, and VBA here), but I'm managing to figure things out so far except for one issue. I've built the tables and made some queries...

Hmm, that might be useful! Is there a way to tell where the .exe for each version is located? For instance if a user has both Access 97 and Access 2003 and you want to force a database to open with A97 you could run A97's .exe or something.

Phooey, that didn't work either, mrmovie, but thanks for the tip!