Linking On 2 Differing Columns

Jun 12, 2007

Hi I have two tables I want to link
On table1 the column is nvarchar (length 53) the value might be XXX0123 on the second table the column is varchar (length 80) and the value might be 123.
The important thing for this company is that 'XXX0123' is the same as '123' But it isn't always going to be the last 3 characters because the first table might be 'XXX0012' and the second value would be '12'

I just want to say SELECT column1, column2 from table1, table2 WHERE
(the two are linked)

hope that makes sense.

View 17 Replies


ADVERTISEMENT

Converting Csv Files From One Format To Another Format With Differing Columns

Dec 19, 2007

Hi,


I have a set of csv files and a set of Format Specification files for each of the csv files. I need to convert the csv files into another format of csv files as specified in the Format Specification files. All the columns of the input csv files do not have a mapping with the columns of the output csv files. How can I achieve this using SSIS ? This is an urgent requirement. Please reply asap. Thanks.

View 1 Replies View Related

BCP With Differing Criteria

Jul 12, 2002

I am familiar and happy with using BCP to export from SQL Server to a flat file

.. 1) Is there any way to pass a parameter to the sql script file each time so that i can vary the selection critria the script file uses each time?

.. 2) Can i batch the BCP calls together so they all use this parameter with some kind of 'super' BCP cammand?

Thanks in anticipation

View 3 Replies View Related

Differing RAID Levels And Their Performance...

Jan 18, 2001

Hi fellas,

I have to spec out a new server, and I have the option of using RAID-5 or RAID-1 drive sets. I am limited to 24 drives in groups of 6,
and I have to have one hotspare per group, so up to 5 usable drives per channel.

I need 80-100GB of space total.

Okay, you're waiting for the question....I have heard many differing opinions on which is better, RAID 1 or RAID 5. If I have 2 Large disks (say 36GB)
on a Raid-1, I assume having 4 smaller 9GB drives on a RAID-5 will be faster, but I am not sure due to overhead and the like.

Does anyone know where I can get more information on RAID performance and how it is going to affect me? The database is going to be Read-Write, with
a ton of small transactions, and the occasional (usually on a weekend) aggregation.

Any help would be much appreciated,

Joe

View 2 Replies View Related

SSIS - How To Deal With A Csv File That Contains Multiple Records With A Differing Number Of Fields

Apr 20, 2007

what is the best way to uses ssis to deal with a CSV file that contains a number of records that contain a different number of fields ?

I could just load as a single column delimited by <CRLF> but then I would have to write the code to parse the line, effectively detokenising the columns myself but if that is the case then why uses ssis at all ?

View 13 Replies View Related

RS2k Issue: PDF Exporting Report With Hidden Columns, Stretches Visible Columns And Misplaces Columns On Spanned Page

Dec 13, 2007

Hello:

I am running into an issue with RS2k PDF export.

Case: Exporting Report to PDF/Printing/TIFF
Report: Contains 1 table with 19 Columns. 1 column is static, the other 18 are visible at the users descretion. Report when printed/exported to pdf spans 2 pages naturally, 16 on the first page, 3 on the second, and the column widths have been adjusted to provide a perfect page span .

User A elects to hide two of the columns, and show the rest. The report complies and the viewable version is perfect, the excel export is perfect.. the PDF export on the first page causes every fith column, starting with the last column that was hidden to be expanded to take up additional width. On the spanned page, it renders the first column on that page correctly, then there is a white space gap equal to the width of the hidden columns and then the rest of the cells show with the last column expanded to take up the same width that the original 2 columns were going to take up, plus its width.

We have tried several different settings to see if it helps this issue or makes it worse. So far cangrow/canshrink/keep together have made no impact. It is not possible to increase the page size due to limited page size selection availablility for the client. There are far too many combinations of what the user can elect to show or hide to put together different tables to show and hide on the same report to remove this effect.

Any help or suggestion on this issue would be appreciated

View 1 Replies View Related

Linking 2

Apr 4, 2007

i already find the answer
thanks

View 1 Replies View Related

Linking To SQL Server 5.0

Sep 2, 2007

I'm writing my first web site using VS 2005 and with my login page I'm trying to link with my SQL database using the following setting in my web.config file
<appSettings> <add key="SQLDB" value="server=STEVE-LT; database=MasterDB; uid=sa pwd="/></appSettings>
Then in my Login.aspx file I use the following code to access the SQL database
Dim Sc As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("SQLDB"))Dim SqlCmd As SqlCommand = New SqlCommand("Select Password, Name from Login")SqlCmd.CommandType = CommandType.StoredProcedure
Sc.Open()SqlCmd.Connection = Sc
 This raises the following error message
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Could someone please tell me where I am going wrong. Thanks

View 2 Replies View Related

Linking Servers 7.0 To 6.5

Jun 27, 2001

I need to have database access via an
application to both sql server 6.5 & 7
the 6.5 uses mixed mode security,
the 7.0 uses trusted. Using
sp_addlinkedsrvlogin I can get from a client to
the 7.0 server, but not to the 6.5.
Is this even possible?

View 2 Replies View Related

Linking To Oracle

Nov 7, 2000

Can anyone tell me how to link to a oracle user? DO I use a predefined DSN? Do I just specify the server and the user and password?

Your assistance is appreciated,
David

View 2 Replies View Related

Linking 6.5 Server

Mar 8, 1999

I can't seem to link a 6.5 database from 7.0 and there's nothing in help which seems to help. Is it a "SQL Server" or do you have to use the OLE DB Provider? If the latter, what's supposed to be in the Product, Data Source, Provider String and Catalog fields? What about security? I've tried everything I can think of and can't get it to work. I also get errors creating a new DTS package that says "Could ot create Component Categories Manager", and then "Error during creation of DTS Package". I installed the desktop version of 7 on an NT Workstation. Has anyone successfully linked a 6.5 server in this environment?

View 4 Replies View Related

Linking Php Forms To SQL

Nov 28, 2001

How would you link an online application form done in php to an SQL 7 server?

View 1 Replies View Related

Help Linking Tables

Jan 11, 2005

this is the query I need help with

select a.RecordID,a.RelocateID,a.WhenConfirmed,b.RequestI D,b.DocumentID,b.RequestWhen from RelocateeDTA a inner join
docRequests b on ({a.RecordID}=' + CONVERT(VARCHAR, a.RecordID)'= b.WhereClause)

because I am trying to link RelocateeDTA that has RecordID to docRequests that has the same piece of data in field WhereClause but is a varchar, and I am getting an error message (syntax error or access violation)

Could somebody help me please

View 14 Replies View Related

Setting Up And Linking A DSN

Oct 14, 2005

Hello there, im new here and wanted some help, i would be very grateful to anyone that can help:

I am setting up a DSN for my website (www.t-f-l.com, it may make more sense if you visit the site) i need it so members can sign up to the site (for the exact problem, click 'sign up now' on the website

I have set up the DSN but it says i need to link it to the database tables via MS access, im not sure at all how to do this...please can someone help

please explain in real idiot language....as i am new to this

View 1 Replies View Related

Linking 2 Tables

Apr 24, 2007

dear experts,
i have two tables, tblcustomer and tblform. in tblcustomer i have cutomerid PK and i have also a field that link these two tables customername. in tblforms i have formname. customername and formname are not PK and customername has a lot of null values.
my question is that i want to link these two tables in customerid not the name and also to get the forms used by this customer. the thing is that i have to write a join query.
any suggestion to do that?

thanks my friends

View 14 Replies View Related

Linking Up Two Different Databases

Aug 22, 2007

I am not a database manager, but I work with people that use databases for sales and customer service... so I am not too familiar with the code and lingo... please bear with me.

We use two databases - one is in SQL, and it is for pre-sales customer service... i.e. tracking notes, phone calls, emails, and opportunities.
The second database is in Progress, and it is for actual quotes, tracking time, labor, materials, cost, and revenue.
As of now, our sales people have to enter new customers in the SQL database, and then duplicate the information in the Progress database. It's very frustrating, because everything needs to be entered twice - name, address, phone, shipping info, etc. etc. etc... When we first started this - 10 years ago - we were told that it could all be linked.

So my question is - is it possible to link these databases together? When our sales people enter a new contact in CRM, I'd like it to be automatically entered into the Progress database. If they make a change to a phone number, I'd like that to be updated in the Progress database. Also the other way around - if a shipping address is changed in the Progress database, I'd like it updated automatically in the SQL database.

Please tell me this is possible - and easy!!! Thanks for any help you can provide at all.

Jon

View 3 Replies View Related

Linking To Exchange From SQL

Mar 16, 2004

Does Exchange 2000 and SQL 2000 have to be the same machine to use exoledb.dll?
I want to link to an Exchange server and gain access to a Public Folder Contact Object for use as a lookup table within an Access front end. Someone directed me to use the Exchange OLE DB Provider, but it does not exist on my SQL machine.

Any help is appreciated

View 14 Replies View Related

Linking To Oracle9I

Apr 30, 2008

Sorry If I have posted this in the wrong head,

I would like to Establish connectivity to a Oracle9i DB thro Linked Server, Can any of you guide me to suitable links...
Thanks

View 3 Replies View Related

Linking Efficiency

May 6, 2008

I would like to use MVJ's formula for creating a date table.

I would like to use it with our main ERP database. However, I am reluctant to make changes to it because I fear that at some point when we upgrade that software and it's database that the upgrade program will delete my table.

So, here is my question. Performance wise, does it matter whether I add the date table to our ERP database or if I create another database (on the same server) for the custom date table? Does linking between databases take substantially longer than linking within the same database?

View 1 Replies View Related

Linking Tables

Mar 24, 2006

I know it's possible to link tables between Access and SQL Server using ODBC....however can u use DAO to do this? If there's a way i would appreciate some help. Thanks in advance.

View 2 Replies View Related

After Linking A Tabel To SQL

Nov 16, 2006

I link to a sql server for the first time.
I change my .provider and .connectionstring to ADO
And know in one of my forms i get a debug Error; Invalid table Name "tablename"
can someone help me with this.
Thanks eddied

View 6 Replies View Related

Linking 2 Databases

Mar 28, 2007

We are considering to implement Microsoft CRM 3.0 in our (small) organization. But we already have some customer information in another system (Unit4). We want to duplicate this information to our new CRM-system. This data will be read-only in the CRM-application.

Both the applications are installed on different servers with their own SQL databases(server 2000 and server 2005)

How can we duplicate the customer information from the unit4-system to Microsoft CRM? Can we simply link those databases using ?ODBC? (I heard something about ODBC but don’t know what it really is.)

Could someone clearly explain me what we have to do to make a construction as described above. (you don't have to give me all details) Is this construction possible anyway?

Thanks!

View 4 Replies View Related

Linking From Access

May 4, 2007

I am have created a test table in enterprise manager v8 and linked this table to an access database. I am able to append to the table from access but cant delete or update.

Ive set the permission settings to allow the user to update and del so cant work out why this isnt working?

ANyone got any ideas?

View 2 Replies View Related

Linking 2000

Jul 20, 2007

Hi,

I have a default instance that is Server1 (2000) and a named instance Server12005 (2005)

How do I link theses servers together so that my 2005 database can query the 2000 database.

Cheers

Leon

View 1 Replies View Related

Linking Two SQL Servers

Jul 23, 2005

Two SQL Servers1) "Test"Payroll DBTransaction Tablepr_SubmitTransaction in Payroll DB********************************************2) "Production"Payroll DBTransaction TablePr_SubmitTransaction in Payroll DBAccounts DBPr_VerifyAccounts (@AcctNumber)********************************************I want to use same pr_VeriftAccounts in both test and productionPr_SubmitTransaction stored procedure.The pr_SubmitTransaction in production works fine when I sayExec Payroll.dbo.pr_VerifyAccounts as it is on same server. (WORKSFINE)Exec [PRODUCTION].Payroll.dbo.pr_VerifyAccounts (DOES NOT WORK)Should I use sp_addlinkedServer ?? to do this ?. Please provide me somefeedback.I know I can acheive this by front end, but I was do it in one storedprocedure.

View 7 Replies View Related

Linking A Table

Nov 10, 2005

Little puzzle this.I need to link from SQL2000 to Access to get to a table held within anAccess DB. Now you can link within Access to a SQL table, but can thisbe done the other way round ? It's the first time I've needed to dosomething like this.What I have is an application which was written (by me) with an Accessbackend (to run on a CD) and now it needs to run on SQL. However, Iwant to be able to swap over between backends so that I can choosewhere this runs from. I've done this with the sole exception of onetable. Previously most of the data was held in one MDB file and a linkto another (one local copy and one on CD). My queries use the link toquery both local and the CD copy data together.I can re-write things if I need to, but I was curious about there beinga way of doing this. What I want in effect is to query a view on SQL,but the data will be held in Access instead of on SQL.I suppose I can import as I need it as the data is purely read only. Idon't think this can be done, but wanted to check first. I can alwaysmove the remainder of the data over to SQL if needed. It's not a bigproblem, just something I'm curious about.Any pointers would be appreciated.Thanks in advanceRyanp.s. In case anyone wonders why I have taken this approach it isbecause we have a query tool and data that we send out to clients onCD. Some now want this web based, so I will publish the application ona Citrix server, and by changing a config file can swap within theapplication to point to SQL (by changing the ODBC settings). This way,I only need one copy of the application and can change backends as Ineed to.

View 2 Replies View Related

Linking Error

Mar 5, 2008

I am trying to compile a simple ODBC and C example on Windows XP SP2.I have Cygwin_NT 5.1.This is the code (obtained fromhttp://www.easysoft.com/developer/l...#dm_fns_drivers)i am attempting to compile.ODBCTest.c


Quote:

View 3 Replies View Related

About Linking Server

Oct 27, 2007

About linking server













Hi,
I am using sqlserver2005, when i make linked server connection between sqlserver2005 and oracle10g . It shows an error like that " Particular table doesnot exist or user doesn't have permission to connect ti this table"and below this one message is shown which is " Message 7314, line16".But i am giving it a proper "username/password ". In this linked server i am using Oracle10g new provider "ODAC101040.exe". so, please elaborate my such problem and also gives me the solution of this problem.
Thanx
regards
gautam

View 3 Replies View Related

Linking To Access Db

May 1, 2008

Hello,

Could someone please tell me (step by step as I am new!) how to establish a link from reporting services to an access database?

Thnaks,
RC

View 1 Replies View Related

Linking 2 Database

May 28, 2007

hi,

I have 2 databases from which my data will be coming from. How can I join this 2 databases in reporting services?



cherriesh

View 1 Replies View Related

Linking To Oracle

Sep 21, 2007

I need to query both Oracle and SQL Server tables for reporting and processing, ....no updates, insert or deletes.

Is creating a linked server the only way? My company does not want me to see the entire database.

Can you just link tables? Like Access or Excel does?

Any articles or links would be appreciated.

Thanks,

Mike


View 1 Replies View Related

Linking File In SQL

Nov 5, 2007

I want to link a file in the table, and want to open in the particuler programme, but the basic problem is by executing the T-SQL command this file open. Like creating the Hyperlink because I want to implement this command in my ASP project page.

Is the procedure is helpful for inserting, linking or opening the file in appropriate programme?

View 1 Replies View Related

Linking Servers

Sep 6, 2007



We have reporting services on 1 server, while the data comes off of another which does not have rs and on sql server 2000. I was able to build the reports and deploy it. But the report wont render. The error message is shown below.

My question is will linking servers work and if anyone has done this could you pl provide an example?

Thanks in advance

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'sds1'. (rsErrorOpeningConnection)


For more information about this error navigate to the report server on the local server machine, or enable remote errors

View 2 Replies View Related







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