Field Content Reversal

Apr 9, 2007

I have a field 'LastName' in a SQL 2000 table 'customers' that is populated with all our customer's full names in this order:

Smith John M

I need to flip the information around so that it can be exported into a CSV file for an automated email notification program to notify them their items are in and having it in first, last, MI format is much more professional.

I've been playing with charindex and stuff routines and am spinning my wheels. Is there a canned routine for something like this - this must have been done a hundreed times out there in SQL somewhere (or it's so easy to do that everyone (but me) just cranks it from scratch).

Thanks in advance for your help.

ronanpcs

View 8 Replies

Field Content Alteration

Feb 24, 2000

Hello,

I have a field in a table called 'CourseId' - the course Id should always contain a backslash somewhere in the list of numbers eg :

12342322
11231131

Unfortunately, some of the course Ids have a forward slash instead of a backslash eg :

462322/1
23/232323

How can I update the field to replace the / with a

Any help is very much appreciated.

Thanks in advance,

Anthony

View 1 Replies View Related

Select - Copy Field Content From Previous Row?

Aug 12, 2014

I have 1 table with some empty product codes that I have imported from a txt file. And I would like to fill in the empty product codes by taking the previous product code

date product_code
01/01/14 | BIC01 |
03/01/14 | |
01/01/14 | CASH |
04/01/14 | BIC01 |
02/01/14 | CASH |
05/01/14 | |
03/01/14 | CASH |

I though of using the LAG function but the table does not have any specific order.So after running the select, the table should look like:

date product_code
01/01/14 | BIC01 |
03/01/14 | BIC01 |
01/01/14 | CASH |
04/01/14 | BIC01 |
02/01/14 | CASH |
05/01/14 | CASH |
03/01/14 | CASH |

View 5 Replies View Related

Write Content Of TEXT Field To A File

Sep 19, 2007

I have a table with a column [FileData] of type TEXT or XML. I need to write the content of the column to a file, using sp_OAWrite for example, but the stored procedure who needs to read the content and write it to the file does not work because the limitation is no local variable for those types. What use is that datatype if i can not use it in procedures like this?

Anyone out there who could give me a tip on how to solve that?

View 6 Replies View Related

Reversal Of Date Format

Oct 22, 2007

Hi Everyone,

I am running SQL Server on Windows 2000 Server Edition and have had a problem with the date format in some of the tables. Specifically all of the days and the months have swapped around where they logically can. The original data was all saved as dd/mm/yy but has now all swapped over to mm/dd/yy - unless of course it will not form a logical date.

The only thing which has happened which i can put this down to is that the server has just had service pack 3 installed on it. Has anyone ever encountered this before and if so is there an easy way to fix it?

View 5 Replies View Related

Reporting Services :: SSRS Shared XML From Content Field

Dec 2, 2015

I am attempting to pull certain bits of information from the content field in the ReportServer.dbo.Catalog. I found this blog post that is nearly perfect : URL....However, when I try and bring in the query parameters, I am just getting nulls. All the code is:

--The first CTE gets the content as a varbinary(max)
--as well as the other important columns for all reports,
--data sources and shared datasets.

WITH ItemContentBinaries
AS ( SELECT ItemID ,
Name ,
[Type] ,
CASE Type
WHEN 2 THEN 'Report'
WHEN 5 THEN 'Data Source'

[code]....

I've tried various variations on the bit third line up from the bottom without any joy. I been reading lots on XML this morning and thing my head has completely gone out the window.

View 2 Replies View Related

View Field Content Update When Real Table Fields Change

Sep 1, 2005

Hi,I use view to join difference table together for some function. However,when the "real" table fields changed (e.g. add/delete/change field). Theview table still use the "old fields".Therefore everytimes when I change the real table, I also needed open theview table and save it by SQL enterprise manager manually for update theview table field.Can we use a SQL command or other method to update it directly?Regards,Silas

View 4 Replies View Related

Help On Updating A Field In A Table With The Field Content Of Another Table

Jun 25, 2007

HI everybody need help on this..

I have two tables below

table1

country countryid

africa ___
usa ___
italy ___
Spain ___

table2

countryid country name

1 africa
2 germany
3 italy
4 usa

I need to write the countryid of table 2 to the field countryid in table1 using the criteria of the correspoinding country name table 2 to country of table 1 if it write countryid else 0..

THE RESULT WOULD BE

country countryid

africa 1
usa 4
italy 3
spain 0

thanks

View 7 Replies View Related

SQL Vs XML Page Content

Apr 2, 2008

I want to create the most effective way (google) to have content displayed on a web page.
Currently, we are updating to SQL and populating to web via calling SQL statements hardcoded to page. I want to know if this is ok to do, or should we be reading from a static XML file that is updated?
I think the XML is the way to go being that i may have answered my own question, but i was curious to what the experts on asp.net had to say.
Thanks,Nick

View 9 Replies View Related

Moving Content From One Db To Another

Mar 9, 2007

an outside developer has sent us a mdf file that contains the need updates to a database.

here is where the problem comes in, how can i append the contents of the mdf file to an existing db?

there are about a dozen tables, 50 stored procs, and one new user.

View 2 Replies View Related

Transact SQL :: Return Field When A Field Contains Text From Another Field

Aug 25, 2015

I'm new to SQL and I'm trying to write a statement to satisfy the following:

If [Field1] contains text from [Field2] then return [Field3] as [Field4].

I had two tables where there were no matching keys. I did a cross apply and am now trying to parse out the description to build the key.

View 8 Replies View Related

How To Add Date Field And Time Field (not Datetime Field )

May 4, 2006

Good morning...

I begin with SQL, I would like to add a field that will be date like 21/01/2000.

Actually i find just "datetime" format but give me the format 21/01/2000 01:01:20.

How to do for having date and time in two different field.

Sorry for my english....

Cordially

A newbie

View 3 Replies View Related

How To Store A Content Into Database

Aug 22, 2006

Hi everyone,

I'm just using TEXTBOX control to save data into my DB. My question is, if I have multiple lines of sentences, it does not store as what it looks like. For example;

Hello, Mike

It stores into the database as "Hello, Mike" and if I read from the database, it does not have seperate lines and shows it like this;
Hello, Mike

How can I store the contents into database and make the contents as original? (Sorry for the poor English, but I hope you understand it.)

View 2 Replies View Related

Automatic Content Expiry

Jun 21, 2007

Hi All,I have a job coming up which involves me creating a vacancy system for our website.I (think) I'll only need one table:ID (PK)JobTitleJobLocationSalaryHoursJobDescriptionValidFrom (Date/Time)ValidTo (Date/Time)I'll display this data using a C#.Net repeater but I was wondering how I can automatically strip the page of the jobs that have gone past their expiry date? Is is straightforward to achieve?Thanks in advance,Brett

View 2 Replies View Related

How To Modify Xml Content In SQL 2000

Jan 14, 2008

HiI have developed a sql procedure for updating some xml content using SQL 2005 xQuery features.For example:Declare @xmlContent = '<books><book name="asp"/>< book name = "sql"/></books>'--Now I want to add attribute "book_id" to the xml content.SET @xmlContent.modify('insert attribute book_id{"1" } into (/books/book[@name="asp"])[1] ')SET @xmlContent.modify('insert attribute book_id{"2" } into (/books/book[@name="sql"])[1] ')SELECT @xmlContent--OUTPUT will be<books><book name="asp" book_id="1"/><book name="sql" book_id="2"/></books>QUESTIONQ1. Do we have any extension or plugin such that this SQl 2005 xquery feature can be incorporated in SQL 2000?Q2. If the answer for Q1. is no (as I expect), then do we have any TSQL feature in SQL 2000 for modifying xml content?I found all examples in SQl 2000 related with "openxml" function which performs the select kind of operations only. Like selecting data in XML format OR converting xml data in to tabular format. But I couldn't find any xml modification TSQL in SQl 2000 which can add element/attributes or change values.one workaround could be to consider xml content as string and use string functions to modify the content.But is there any more sensible approach available in SQL 2000?

View 1 Replies View Related

SQL Server As Content Store

Dec 29, 2003

Okay, moving to developing a small site that will be storing articles - that is a site largely consisting of html marked up articles with images. We already have an SQL Server so it is becoming the back-end.

So, since I'm not an SQL Server expert, some general advice on this would be appreciated? The articles, as I say in HTML (largely just markup for titles, and general text) would be stored in the DB? As Text datatypes?

How about the images...on disk or in SQL?

View 3 Replies View Related

Cannot Able To See The Content Of A Column In A Table?

Nov 12, 2001

hi everybody,

The problem is, I have a table with one column of varchar(8000) datatype. It has got 1000's of records. Through Query Analyzer, I am not able to view my records after 257 columns in my table, even I increased my textsize by using 'set textsize' command.

Any other setting is available to correct this. Any help is appreciated.

thanks,
Vasu

View 2 Replies View Related

Table Empty Of Content

Sep 10, 2001

I have a particular production database that on a few recent occasions has suddenly had one of it's tables empty of content. Now there are no jobs or triggers in place neither is any stored procedures that could perform a delete or alter table operation in place. The permissions have been set not to allow this either. The datatype is text only. What is intriguing is the QA server has an exact mirror and this dosen't happen. Has anyone come across this sort of phenomenon?

View 2 Replies View Related

How Can I Read The Content Of Transaction Log

Oct 30, 2006

How can I read the content of transaction log?

View 2 Replies View Related

How To Extract Content From Email

Feb 22, 2012

I want some way to extract email content from email that we send/receive in account.....

This question is in context to Text Analytic

View 4 Replies View Related

Content Of Sp From System Tables

Jun 4, 2008

Hi,

Anyone plz do tell me what s the query to see the text content of stored procedure from system database tables..

from which table we get the content of sp

Thanks & Regards

ARV

View 9 Replies View Related

What Express Content Do You Want MS To Provide?

Dec 14, 2005

Folks,

I'm the project lead for SQL Server Express in Microsoft (as well as owning the Storage Engine). I'm going to make sure that threads on this forum get answered - I see a bunch with no answer so far.

Now to the point - we’re in the process of assessing the content that exists to help people learn and use SQL Server Express. This includes demos, tutorials, whitepapers, Webcasts, Starter Kits, and any other type of content you could imagine. So this is a great chance to TELL US WHAT YOU WANT! We’ll integrate your feedback and make sure that we try and address the most requested areas of content. Please be as specific as you can.

Thanks in advance for your feedback.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

View 9 Replies View Related

Content OF Stored Procedure ??

Mar 31, 2008

Hi ,

Cay anyone tell me where is the content of Stored Procedure
stored in the database.. in which table

Thanks & Regards

Arv

View 12 Replies View Related

Merge Database Content

Jul 23, 2005

hi,i have a sqlserver CE and a sqlserver database.The tables are exactly the same on both databases.the sqlserver CE database Content will be synchronized with thesqlserver database with insert orders..is there a way to merge the two databases?this would be great cause different content will be inserted in bothdatabases. After a synchronisation both databases should have the samecontent..i hope you understood my problem. my english is not very well..christian

View 1 Replies View Related

Formatting Database Content

May 16, 2006

HiI have set up a SQL database to contain alist FAQ's for our company andthen plan to pull this info off using a web page.So far I have entered the data but I am unable to control how it isdisplayed inside SQL ie I cannot enter new blank lines I have triedusing lots of spaces but this does not work when I use the website todisplay the info.Is there a way of formatting and editing the data in the sql databaseas I am unable to do this, if I try to edit the data in the database Ihave to copy it to notepad delete what is in the database, edit thetext in notepad then paste it back in.There must be a better way.Please helpalamb200

View 8 Replies View Related

Web Content Database. Is There A Limit?

Jul 20, 2005

HiI've developed a simple web service that lets people easily set up their ownwebsites, and keep them up-to-date themselves.I'm storing all the content, including images in the SQL 2000 database. Sofar it's working well enough. Is there likely to be a performance orreliability problem as the system grows?You can see it in operation here: www.up-to-the-minute.comIt's early days and any comments and ideas are welcome.John SouthPangbourne UK

View 1 Replies View Related

Best DataType For Content System

Jul 20, 2005

Hello,On our corporate website, we will be using email notifications forvarious things. I would like for our marketing guy to be able to editthe email templates over the web so that I don't have to keep updatingthem myself for every little change. I want to store the templateswithin the database (since they will be small). The templates will beHTML based and not more than a few thousand bytes in length. Should Iuse a VARCHAR or VARBINARY, or what? I would assume VARCHAR, but I'mnot sure.Thanks,Will

View 1 Replies View Related

Combining The Content Of Two Tables

Sep 20, 2007

Hi all,

How can I combine the contents of the two tables below? The combination result of these tables is provided below. Thanks

Table A
Client Weight Purchase
Tom 10 2
Bill 4 2
John 3 2

Table B
Client Weight Purchase
Jim 2 5
Lee 4 3
Bob 6 7

Combination table (result)

Client Weight Purchase
Tom 10 2
Bill 4 2
John 3 2
Jim 2 5
Lee 4 3
Bob 6 7

View 3 Replies View Related

MCMS Content Inventory

Jun 29, 2006

Hi,

I would like to know how does CMS stores content inventory in SQLserver.?

Example-If I create or migrate an application to CMS in sqlDB how does information is stored ?

Regards

T.Gunaseelan

View 4 Replies View Related

Evaluating String Content

Jun 12, 2006

Our Business partners request me to read the field names from a SQL table dynamically so that my SSIS package will not get impacted if Web Service hosts make a change.

Is there a way to evaluate a string at runtime that contains a field name ?

Thanks,

Gulden

View 6 Replies View Related

Copy Content Of Txt File

Nov 6, 2006

Hi Guys,

What approach should I use to copy content of a text file. Is BCP capable of doing this? How about SSIS?

Example of the text file's content:

Date, "20060101"
ST_Code, "101"
A_Code, P_Code, T_Code, amount, price
"0001", "1111", "0101", 550, 230
"0002", "1111", "0102", 345, 122
"2001", 0212", 0930", 410, 90

In the example above, I just want to copy the rows Date, "20060101" and ST_Code, "101" into a table.

Regards,

Lars

View 2 Replies View Related

SQLLDR Content Of The Log File

May 10, 2008

HI,
We are using SQLLDR to send data from SQL Server to Oracle database. This utility creates a log file. I want to know whether there is a provision to change the contents of the file. We use this utility in multiple SQL Servers to send the data to the same Oracle Server. Can we add the source server name in the file so that identifying which server does a particular log file belong to? How?

Help would be greatly appreciated. Thanks a lot..

Manoj Deshpande.

View 3 Replies View Related

Example Of How To Retrieve The Error Log Content

Apr 9, 2008

Hello,

several days ago I've seen a sample code from Books Online which retrieves the content of error log as a rowset using a single SELECT statement. But now I can't find that article. Instead of this I've found the stored proc sp_readerrorlog which is undocumented. So I'd prefer the using of documented approach. Has anyone seen that article? Please remind me its location if so.

Thanks,
Yuriy

View 6 Replies View Related