Database

well you could better use BCP command for large files to import into a database. See here for more details In Word you can only store 2 bytes. That is why I use Writer.

SQL Server comes with "SQL Server Integration Services" which is commonly referred to as SSIS. One commonly uses SSIS for data migration tasks. A very general outline of your solution would involve. 1. Create the migration task. 2. Schedule it so it runs repeatedly. The following is a tutorial which which teaches SSIS basics as well as creating a data migration task. http://technet.microsoft.com/en-us/library/ms365330.aspx[^]

Alternatively, you can use this. I'm assuming that the column PHOTO is in the USER table. I see that some of the columns in the query have not been prefixed with an alias, it is always a better practise to prefix all column names with alias, it improves performance too... SELECT K.KIDID, K.STUDENTNUMBER, KIDNAME, KIDLASTNAME , SC.SCHOOLNAME , KIDGRADE , KIDCLASS , SC.SCHOOLID, k.TEMP_BARCODE, (SELECT PHOTO FROM USER UP WHERE U.USERID = UP.USERID) AS PHOTO, A.ACCOUNTID ,SUM(TRANSACTION_AMOUNT) AS [BALANCE] FROM KIDS_DETAILS K INNER JOIN SCHOOL SC ON K.SCHOOLID = SC.SCHOOLID INNER JOIN PARENTKID PK ON PK.KIDID = K.KIDID INNER JOIN USERS U ON U.USERID = K.USERID INNER JOIN ACCOUNTS A ON A.USERID = U.USERID INNER JOIN ACCOUNTRANSATIONS AT ON AT.ACCOUNTID = A.ACCOUNTID LEFT OUTER JOIN KIDSPHOTO KP ON KP.KIDID = K.KIDID GROUP BY K.KIDID, K.STUDENTNUMBER, KIDNAME, KIDLASTNAME , SC.SCHOOLNAME , KIDGRADE , KIDCLASS , SC.SCHOOLID, k.TEMP_BARCODE, A.ACCOUNTID

Try putting headers in the first row of the spreadsheet and use HDR=Yes option.

Another alternative is to enclose it using [] Example like '%TEST[_]%' string str = "TEST_" str= str.Replace("_", "[_]");

Damnit Pete, you said his name. You know it's cursed right?! Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson

Thanks, that worked. Kind of funny how simple that was. In the time it took to get a response, I wrote a complicated Regular Expression Validator control to get around the issue..... Let me go delete that. lol

paper67 wrote: To get some more structure in my window form application, I want to move a DataSet in a custom "DAL" folder. Did you move it using Windows Explorer, or did you move the file from within the VS IDE? paper67 wrote: When I place it in the root folder everything works fine. I'm guessing that VS cannot update the path to the files when you copy it using the Explorer. You could try to drag&drop it in the 'Solution Explorer' in the IDE, that should update all references during the move. Bastard Programmer from Hell :suss:

Firewall on Win7 blocking port TCP/1433 maybe? Look in the Win7 event logs and/or the firewall logs. Never give aversion therapy to a masochist. The results are unpredictable. My Mu[sic] My Films My Windows Programs, etc.

Maybe there is a spambot posting comments quickly, like say around 200 a second. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

When a task request is received, SQL Server will attempt to allocate the task to an available worker thread. If no worker thread is available, a new one will be created to handle the task, up to the configured maximum number of threads. Once that maximum limit has been reached, task requests will queue until a thread becomes available. As you might guess, it's quite a lot more sophisticated than that, but that is essentially what it boils down to. If you want to know more detail, there are plenty of articles on Google that will explain it in as much detail as you want.

Found this answer from Ask Tom... It appears that I have no choice but to use a global index on the PK.

Depends on your database server, there is plenty of information out there for SQL Server[^] Never underestimate the power of human stupidity RAH

Any operation on null will yield null. Set the initial value of @abc to something other than null.

what exactly is the problem? i.e. what are you trying to acomplish?

A "view" is a way of looking at data stored in table(s), therefore using a view instead of the underlying base table will not solve your performance issue. If your query is slow, consider these tips: 1. Index your base table(s). 2. Use a WHERE clause to filter only those rows that is needed. 3. Select only the required columns (don't use a * in the SELECT statement).

Posting your query will help us determine your problem, but here are some general tips: 1. Index your table(s) properly. 2. Select only the required rows using a properly constructed WHERE clause. 3. Select only the required columns.

Do not create duplicate posts, you can edit your previous post and make your additions.

Go with option 2, it sound horrible duplicating user profiles in each db. You could setup tables in your memberDB to control which app each user can login to.