Hi Athersgeo,

Believe it or not, this is a feature of SSIS. The best way to handle flat file importing is mapping the flat file connection EXACTLY the way the file is mapped and configuring the...

Hmm...I've done some beginner level java programming, do they by chance have an ADODB Recordset object? You could load records into the object then push those records into the table when batch...

Hi there.

Have you by chance attemped any type of batching? I'd queue up the record and try to batch them first, say 50,000 recs for each batch? See if that makes things any easier and let us...

This old function I made may help as it demonstrates the concepts of looping with SQL (without a yucky cursor!).

CREATE function [dbo].[fn_Is_Uppercase]
(@string varchar(1000))
returns bit...

Additionally, if you have to perform this task any more, its quite easy to build a SSIS package to do it for you. That way having a fresh new Access DB is only a click away.

Wow. Few issues I noticed with this:

1. There is no group by clause. You'll want to group by Cardno and cardeventdate when trying to aggregate.
2. Look out in your where clause!!
2A. You...

This (http://msdn.microsoft.com/en-us/library/ms189461.aspx) may correct the issue if implemented correctly, and at the same time eliminate the need of your functions.

To correct the function and...

Look through the metadata functions available in your database.

Specifically, the columnproperty() function looks like it may be of some use for you.

As suggested earlier the question was a...

Hi,

Could you provide us with a few sample rows of data. SSIS/DTS should be able to do the trick (commonly work with CSV data), we just need to see the data so we can put you in the right...

You can use SMO to look through each table in a given database and code SSIS to only export those that have a rowcount.

This kind of functionality is easy in theory but I'm not quite a SSIS ninja...

You need to use the logic in the SP to concatenate a dynamic SQL query, then execute the query.

Right now you know your parameter is going in right, you just now have to concatenate properly and...

I have a feeling you're going to have to use a cursor to get that kind of result. Read up on them, it should be pretty easy, but keep in mind they are a bit slow if you're using a lot of data.

Kav,

Change your cmd to this:


cmd = New OleDbCommand("Select * from table1 Where Mfg Like %'" & ComboBox1.SelectedItem & "'% And Make Like %'" & ComboBox2.SelectedItem & "'% And RAM Like %'"...

You could configure and adjust SSIS packages every time you add a table, for all 6 databases...or you could replicate (most practical solution IMO).

This should do the trick :) Although inefficient, I used self-left outer joins and the isnull function to give us a 0 value for quantity.

+++++++++++++++++++++++++
Name + Apple + Banana + Pine +...

Matiman,

Keep in mind some (actually most) hosting companies will only allow access to their SQL servers from their host machines. This is so they don't grant everyone on the internet the ability...

It looks like your SQL syntax is incorrect. Read up on INSERT syntax here (http://en.wikipedia.org/wiki/Insert_%28SQL%29).

Please keep us updated on your progress/trial & error.

Peter,

It seemed his/her question was pretty straight forward and geared towards flat files and text manipulation. You earlier replied with "I do not understand what this has to do with...

Ok...If this is working without the order by try this.

1. Remove the order by on both SQL statements
2. Turn the unioned set into a sub statement...something like:

Select * from
(Select...

Indeed...your error is coming from 1. lack of a filename in the connection string and 2. no driver specified. That should fix it as long as you can successfully modify it.

Try something like this for your connection string.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

That was from www.connectionstrings.com

I think [Records Ordered by rowID] could be part of a view which may not be updatable (includes deletion).

The invalid syntax is coming from the 'go' you have in between the union. 'go' is making SQL go do its work and it starts the next command with 'union all' and is probably wondering what to union.
...

Yes...keep in mind you can't do arithmitic operations with null values.

I'd suggest using a view or a stored procedure. The syntax would be something like the following.

SELECT Dayofweek, MAX(Timeslot) as 'Timeslot', MAX(AM/PM) as 'AM/PM', MAX(Description) as...

I think you should look into using DTS or SSIS (depending on SQL version) to bring the information in, then export it out.

This is a 5 minute job if you're familiar with DTS or SSIS.

Hi Strangeloop,

That really all depends what you plan on doing with SQL. Are you an IT Amin/Engineer or are you a programmer, if coding...what langauge?

Jon