Access Table Manually

Jul 24, 2005

Hi:

I have a UDF that splits a string based on a delimiter.The UDF returns a table of records:1- ID2- ValueThe string I am sending to split is:'2-4-07:00 AM-08:30 AM'I am splitting on '-'What I get back is a table of 4 rows.I want to get each value, convert it to the right data type, then assign it to its own variable.How can I get each row alone manually? Can I? Without using Cursors?if I do a "select * from Split(@myData,'-')", then I cannot retrieve each field alone,Thank you.

View 6 Replies


ADVERTISEMENT

Manually Input Data Into Replicated Table

Jul 17, 2007

Is it possible to have a replicated table that you can open from and input data manually?

That is, I've got a table that I am replicating data to and I want to add some manual data to this table, every now and then.

Will this break replication?


www.beyonder422.com

View 4 Replies View Related

Import Access Tables (set Up As Pass-through Table Types To Oracle )--OLE DB Connection To Access Cannot See Them

Mar 17, 2008

Access Connection

create a new Connection Manager by right-clicking in the Connection Managers section of the design area of the screen. Select New OLE DB Connection to bring up the Configure OLE DB Connection Manager dialog box. Click New to open the Connection Manager. In the Provider drop-down list, choose the Microsoft Jet 4.0 OLE DB Provider and click OK.
Browse to the Access database file and connection set up---all good!!!

Dataflow task
Add an OLE DB Source component
Double-click the icon to open the OLE DB Source Editor. Set the OLE DB Connection Manager property to the Connection Manager that I created . Select Table from the Data Access Mode drop-down list.
I cannot see the tables set up as set up as pass-through table types to a Oracle 9i db

Any ideas please help

thanks in advance
Dave

View 2 Replies View Related

Users' Access Linked Table From ACCESS To SQL 7.0 By ODBC

Jan 12, 2000

Hi Everyone,

I have set up a link from ACCESS to a SQL 7.0 database using ODBC (File DSN saved on a shared DRIVE). The link works well only from the workstation where the link was created. But How can I create a link so a group of users can view the linked table in ACCESS without type a password? Any suggestion is appreciated.

Lunjun

View 2 Replies View Related

Can I Access MS Access Table In A Select Query Of SQL Server

Nov 29, 2006

Is there a way to specify a MS Access table (or query object) in the select query of SQL Server.

Ex.:

MSAccessTable (in file.mdb)



col1
col2

a1
a2

b1
b2

SQL query in SQL Server:

SELECT col1, col2 into SqlTable from [file.mdb].MSAccessTable;

Thanks,

View 3 Replies View Related

How To Run Sql Log Shipping Manually

Nov 29, 2006

Hi everyone
In my project, sometimes, I need to run log shipping manually rather that it runs automally when the schedule occured.
manually run log shipping means call the log shipping in code.
 
Thanks.

View 3 Replies View Related

Autoincrement Manually

Jun 24, 2008

Hi All,

This may sound quite easy for you, however I am a newbie in SQL.

So I have an identity field, which I wish to increment automatically every time I do an insert. However the starting integer has to be the MAX value from another table.

So for example I am doing an insert in a #temp table
INSERT INTO #temp(name, surname)
SELECT name, surname from table1

Now the personId of the #temp table has to start from the MAX of table2
Ie SELECT MAX(personId) from table2

The SELECT MAX(personId) from table2 can also be NULL, ie the first time I am inserting, so I also have to cater for this scenario.

can anyone help?

Thanks

Johann

View 12 Replies View Related

How To Install Sql Files Manually?

Jan 13, 2004

I am new to the ASP.NET and SQL scene.
How do you run a sql script manually?

I have MSDE SP3 installed and running. I am having a problem with the localhost setup for some of the kits and need to run the scripts manually.

Any help would be great, including helpfull learning resources.

View 2 Replies View Related

Cant Manually Grow Database

Jan 24, 2003

Hardware:
IBM Netfinity 8500
2 processors Xeon 700
1,5 Gb memory
Windows 2000 Server SP2 Build 2195
SQL Server 2000 Standard Edition 8.00.534 SP2
There is only on Database (DB) of 16 Gb in drive G.
Drive G has 32 Gb space free.
Yesterday we appended tables to the database and in SQL logs appears the next error:

2003-01-23 12:26:42.57 spid101 fcb::ZeroFile(): GetOverLappedResult() failed with error 2.
2003-01-23 12:26:42.61 spid101 Error: 1105, Severity: 17, State: 2
2003-01-23 12:26:42.61 spid101 Could not allocate space for object 'ttdssc030104' in database 'MYDATABASE' because the 'PRIMARY' filegroup is full..
2003-01-23 12:26:48.03 spid101 fcb::ZeroFile(): GetOverLappedResult() failed with error 2.

DB configured to grow automatically by 100 Mb and transaction log Automatically grow in 10% .
Unrestricted file grow selected on both.

I try to expand the DB manually by Enterprise Manager to 20 Gb but not work and in SQL log appears the error

"2003-01-23 12:26:48.03 spid101 fcb::ZeroFile(): GetOverLappedResult() failed with error 2."

In Enterprise Manager-Databases-Properties-General-Size of DB maintain 16Gb.
Windows explorer say MYDATABASE.MDB is 20480 MB.

I delete the tables inserted and the problem persist.

Thanks in advance,

View 6 Replies View Related

Manually Insert Query

Apr 9, 2015

I am getting 228 rows once I manually inserted the value for the ct.code in test region. I would like to insert into other regions using the SQL, how can I do that ?

select distinct
ocmi.name,
ct.code,
ctv.value
from
cv3ordercatalogmasteritem ocmi
join CV3CatalogClassTypeValue ctv on ctv.CatalogMasterGUID = ocmi.guid
join CV3ClassType ct on ct.guid = ctv.ClassTypeGUID

[code]....

View 1 Replies View Related

Check Point Manually

May 8, 2007

Dear Experts,
please guide me, how can i run checkpoint manually?
and how can i make it done automatically? what is sql server default?

is it a problem (making the checkpoint to run more times)?

Vinod

View 3 Replies View Related

Manually Triggered Replication?

Aug 8, 2007

I've been studying/experimenting with the replication features and though the Updating Susbcribers Replication Model was the answer to my data environment.

What we want: We have a live server (Publisher) that'll serve content to our users, but we want an "offline/data entry" server (Subscriber) that'll pretty much have the exact same data as the live server for data entry and validation purposes. Changes and inserts would be done on the Subscriber locally, vetted through, and once done, it'd be updated to the Publisher.

I've managed to get some semblance of the above working, but the updates are nearly instantaneous. Which means that changes/inserts that may be erroneous on the subscriber machine would almost always be seen on the publisher machine before our operations can do anything about it.

Is there a way to configure the replication process to hold off until the admin triggers it? Or am I using the wrong feature?

View 4 Replies View Related

How To Remove MSDE Manually?

Sep 27, 2005

Please help me to clean a Windows 2000 Pro instance which is "dirty"with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrectinstalled/removed.I have a software product installation containing MSDE 7.0. When I triedto install MSDE 7.0 I got an error "You have installed MSDE".*** Sent via Developersdex http://www.developersdex.com ***

View 5 Replies View Related

SCD - Must Change SQL Command Manually

May 30, 2007

Hi all



I'm trying to use the Slowly Changing Dimension transformation and it seems that in order to get the transformation to work as expected the custom property "sql command" has to be manually changed so that a "RTrim" function is applied to all string columns referenced. As an example consider this:



SELECT Initials, Department_Name from dimEmployee



has to be changed to



Select RTrim(Initials) as Initials, RTrim(Department_Name) as Department_Name from dimEmployee



where Initials is the "bussines key" and "department_name" a historic attribute.



Is this the normal behaviour ??



Regards, Steen





View 7 Replies View Related

Incrementing Rows Manually

Aug 28, 2007



Hi,

I have a table



Code Snippet
CustomerDetail
customerid
customername
status
app_no
deskno





Now everytime a new customer is created, i allocate the deskno. The logic I use is




Code Snippet
create proc spoc_incrementdesk
as
DECLARE @deskno int

select @deskno = (SELECT max(deskno) from customerdetail)

Insert into customers(1,'rick',1,23232,@deskno)




If there are already records present in the customer table, it works well. However if the very first record is getting inserted it inserts null in the deskno because when no records are present (max(deskno) = null).

At time time of insertion, how do i check if @deskno = null and allot it 1.

Vidkshi

View 4 Replies View Related

How To Run A Report Subscription Manually?

Mar 13, 2008

I have a report scheduled for email delivery at a certain time of the day. Is there a way I can execute the subscription ON DEMAND so that when ever I execute it, the report is processed and emailed? Is there a way to run the subscription from a batch file/ssis/tsql etc?

any help appreciated.

thanks
Jacob

View 4 Replies View Related

Time To Manually Failover?

Mar 8, 2007

When I force Mirroring to fail over while watching the Mirroring Monitor I notice something interesting. Before I failover, the servers are synchronized and there is zero unsent log and zero unrestored log. When I failover, the mirror changes to "restoring", stays there for about four minutes, switches to "Principal, restoring", and then the unsent log and unrestored log numbers jump to values in the tens of megabytes, and we spend time restoring.

We wait about five minutes between requesting the failover and having the servers back up again, answering requests.

Why does failover take so long? We've been thinking that failover shouludn't take so long because the servers think they're synched. What causes the log spooling spike? Is the state refelcted by the mirroring monitor inaccurate?

View 6 Replies View Related

Manually Triggering Subcriptions

Feb 24, 2007

Is there a way to do this? It would be useful to test whether a subsciption works. At the moment I am setting the scheduled time a few minutes ahead and waiting for the report to run.

Subsciptions are also a convenient way to store different parameter settings for a report.

My preference would be to to do this through the Report Server UI (presumably from the subscriptions tab).

Alernatively, being able to call a report (with paramters) from a stored procedure woukd be useful.

Thanks,

Dick Campbell

View 3 Replies View Related

Manually Change Report

Apr 24, 2007

Hello,

I use Reporting Services in my solution. The data i have as source is very uncertain. Sometimes i manually have to delete a record from the report (not the database itself). I woluld like to have a checkbox or something simular to delete from report and totals, grafs would be updated. At the same time I would like the report to make a comment that a record was taken away, alternative let the user make a comment. Is this possible? DO i have to make a own application for that?



Thank you for your help!



Best regards,

Luskan

View 2 Replies View Related

Using Sqldatasource Insert Command Manually

Aug 4, 2006

hi i have an sqldatasource which has an insert command - a stored procedue is used.I have a text box with a button next to it . it is not in a datagrid.on the onclick event I would like to pass the value of the text box to the sqldatasource insert parameter ( it only expects this one parameter , and use the sqldatasource to do the insert basically doing a manual insert using the sqldatasource.does anyone know if this is possible thanks

View 2 Replies View Related

Manually Creating Membership Tables

May 26, 2007

Hi,  I have limited control on the server I use.  I can not create data bases but can add tables and edit the data base that has been created for me.  So what I would like to do is be able to use a tool such as aspnet_regsql through SQL Server Express to add the tables that Membership would automatically create.  Any help in pointing me in the right direction would be great
 
 
Thanks
howlinhuskie

View 6 Replies View Related

How To Merge Multiple Databases Manually

Jul 21, 2012

Recently i got one assignment from my senior, I have to merge multiple sql server databases,

Where to start?

How to start?

What prerequisites should consider?

What factor will cause error, how to tackle that error.

View 2 Replies View Related

Manually Increment Values Of ID Field

Nov 4, 2014

declare @kk int
set @kk=0
insert into tblSSAppsOrgEntityToEmployerMapDiffer
(Id,
OrgEntityCode,
EmployerId,
[Default],

[Code] ...

In above example Id is PK for Differ tbl and Temp tbl not having field related to this. thats why i have to take and increment that Id value manually.... but like above way i m getting error ..........

View 5 Replies View Related

Job Succeeds Manually But Fails If Scheduled

Mar 21, 2006

My client has a number of jobs that are run overnight. We've set themup to email me when they're completed. Every morning I get in to abunch of emails like this:<quote>JOB RUN:'Tech Pubs Email Notification' was run on 18/03/2006 at00:00:00DURATION:0 hours, 0 minutes, 0 secondsSTATUS: SucceededMESSAGES:The job succeeded. The Job was invoked by Schedule 10 (SendMail). The last step to run was step 1 (Send Mail).</quote>However, the most important job - the database backup - fails everytime.<quote>JOB RUN:'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1''was run on 20/03/2006 at 18:00:00DURATION:0 hours, 0 minutes, 2 secondsSTATUS: FailedMESSAGES:The job failed. The Job was invoked by Schedule 7 (Schedule1). The last step to run was step 1 (Step 1).</quote>What's strange is that the job runs successfully if you kick it offmanually (in EM: right-click and "Start Job")!!! Does anyone have anyidea of why that might be? Where to look for diagnostic information?TIAEdward

View 6 Replies View Related

DTS Runs Manually, Fails As Scheduled Job

Jun 26, 2006

I've mined countless threads all over the Net where people are having my problem, but none of the solutions I've seen seem to apply.

When I run a DTS package from Enterprise Manager, everything works great. When I schedule the same package as a job, it fails immediately and reports this error:

Executed as user: SERVER-NAMESYSTEM. DTSRun:  Loading...      Error:  -2147221005 (800401F3); Provider Error:  0 (0)      Error string:  Invalid class string         Error source:  Microsoft Data Transformation Services (DTS) Package      Help file:  sqldts80.hlp      Help context:  713.  Process Exit Code 1.  The step failed.

My hunch is the SERVER-NAMESYSTEM.DTSRun account doesn't have sufficient privileges, but I can't find how/where to fix that.

Help, please.

Thanks,

Doug

 

View 2 Replies View Related

How To Achange Service Account Manually

Dec 28, 2007



I know it will have SMK undescrypable in change the service acount of sql server manually From Laurentiu Cristofor's blog . But i don't know how what is "manual service account change", and i only know is that change service account by Configuration Manager.


any suggestions?



thanks

View 5 Replies View Related

How To Terminate The Client Connections Manually?

Jun 20, 2007

Hi guys,



You know when restoring a database in SQL Server, exclusive access is required. With sp_who I can see the clients. But I don't know how to terminate the client connections easily. Usually I have to stop the server and restart it. I DO think it's too troublesome. Do you have any ideas? Is there any sp or command, or tool that may help? How do you deal with this issue?



Thanks!

View 4 Replies View Related

Manually Stop Instances Before Rebooting??

Mar 31, 2008

Hello,

I've heard rumors of best practices to include manually stopping SQL instances before doing a reboot of the system. Is this true and if so, where is this documented. I've searched all over and come up empty. So I was wondering if this was just some old DBA saying but no longer relevant?

Thanks
Blue

View 5 Replies View Related

Inserting Manually Vs. Bulk Insert

Sep 12, 2006

Hi Andrea,
I have made a table which contain data inserted manually and also data that was inserted by using bulk insertion. I have no problems using the table with Grid View. But when I try to use a query like the following:

SELECT *
FROM dbo.last
WHERE VMake = 'Honda'
AND VType = 'sedan'
AND VColor = 'Red';

I would only get the data that were inserted manually.
When I use the same query to filter data from a table that the data was inserted by using bulk insert, I get column names but no data.

Any help please.

Juvan

View 1 Replies View Related

Why I Always Fail To Manually Train A Model?

Aug 12, 2006

Dear all,

Why I always fail to manually train a model in Management Studio?

ZhaoHui Tang recommends me to untrain the model first. So I untrained it like this.

DELETE FROM Decision_Tree.CONTENT

Then I train it like this.

INSERT INTO Decision_Tree
(Age, Bike_buyer, Customer_Id, Gender)
OPENQUERY ([AdventureWorksDW], 'SELECT Age, Bike_buyer, Customer_Id, Gender FROM Training_table');

The error message is

Error (Data mining): The mining structure , Decision_Tree is already trained and does not
support incremental updates. Before using the INSERT INTO statement, use DELETE FROM <object>.

Why is that so? I already untrained the model. The model has been made and processed
outside Management Studio, i.e., in the Visual Studio.

Thank you,

Bernaridho

View 3 Replies View Related

How To Deploy Semantic Models Manually?

Oct 5, 2005

Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.

View 9 Replies View Related

Looking For Direction On How To Add 4000+ Users Into ASPNETDB Manually

May 30, 2007

Hello and thanks for reading,
I would like to know if it's possible to add around 4000 users into the ASPNETDB without adding them one at a time.  I have to avoid using a "create user wizard" because this login is for a private online election only.  The list of users is in an access database and looks like this:
Username    Password
DHunziker    Hu8645
SEnderton    En0854
BAckler        Ac9576
....
Unfortunately, I don't have valid emails for all 4000 people, nor do I have the time and resources to collect security questions and answers so I don't know if this is even possible.  Can you help me?
Thanks!
 
 
 

View 6 Replies View Related

Replication Does Not Work After Deleting The LDF File Manually.

Feb 6, 2004

I have maually deleted the Database.LDF file by stopping the SQL Server. When i start the SQL Server, merge replication which was configured for the database does not work. How do i fix this problem.

Thanks in advance.

Regards,

Venu.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved