I am working with SQL Server 2000 table called dbo.proofofconcept".
I need to separate values that are all in one column that are space limited.
For example I have a column called tryit and the
value = '1234 456.75 01/01/2001 ABBR TRY@xxxxxxx 75% $12.75 '.
I want to write a query so that the results can be split out to 7 output
columns. In other words, I would like the output to be:
Column 1 = 1234,
Column 2 = 456.75,
Column 3 = 01/01/2001,
Column 4 = ABBR,
Column 5 = TRY@xxxxxxx,
Column 6 = 75%,
Column 7 = $12.75
The output would be separated into different columns for reporting purposes,
setup to create an output file, and possibly to be split into an XML file.
How would I go about writing a query like this? If this should be a stored
procedure, can you show me how I would write the stored procedure and how
would I execute the stored procedure?
Re: comma delimited file ... I need to separate values that are all in one column that are space limited. ... setup to create an output file, and possibly to be split into an XML file. ... How would I go about writing a query like this? ... can you show me how I would write the stored procedure and how ... (microsoft.public.sqlserver.mseq)
Re: separating comma delimited values in one column ... I need to separate values that are all in one column that are space limited. ... The output would be separated into different columns for reporting purposes, setup to create an output file, and possibly to be split into an XML file. ... How would I go about writing a query like this? ... If this should be a stored procedure, can you show me how I would write the stored procedure and how would I execute the stored procedure? ... (microsoft.public.sqlserver.tools)
Re: Search database for namee ... Not that based on your previous response, your tblcompany would also have a ... drop-down identifier so you can "virtually" separate them into the eight ... I have 8 tables in my database.... >> them together and am basing my form on the query.... (microsoft.public.access.queries)
RE: Approach to ... I did come up with a solution - a union query.... Thanks, too, for you comments about normalization.... Each row in what you posted should be a separate record in your ... Susan in your example, I assume this is filtering by Student, so sorting by ... (microsoft.public.access.formscoding)
Re: Excel query from Access databases ... the data is in 2 separate Access mdb files.... > use CustNo as the common field?... > AFAIK you can only query one Access file at a time and only one Record ... > the Access query to an Excel file as another option. ... (microsoft.public.excel)
