Frustrated

I'm not to familiar with SQL so I'm frustrated. The deal is this: I have a table with product information in it. I'm creating an xml doc from this data via a datagrid. I have to add two extra fields into the table to match my DTD. I did that fine and what I need to do is set those fields equal to the value in another. I need to pull my id field value and store that in the BuyUrl field which is appended to the end of a url. How can I achieve this? Thanks for your help.Select
field1, field2, field3,
field1 as field4, field2 as field5
from table1

You can select fields multiple times in a SELECT statement. Using the AS operator assigns a new name to the column (for purposes of the query).|||::I'm not to familiar with SQL so I'm frustrated,

In geneeral reading the documentation or a good book helps.

I would recommend SQL for dummies.

http://www.amazon.com/exec/obidos/tg/detail/-/0764540750/qid=1085204033/sr=8-1/ref=pd_ka_1/104-5531251-7639964?v=glance&s=books&n=507846

or

Sql Server 2000 for dummies

http://www.amazon.com/exec/obidos/tg/detail/-/0764507753/qid=1085204058/sr=8-2/ref=pd_ka_2/104-5531251-7639964?v=glance&s=books&n=507846

If you really have a generic problems with your knowledge about SQL, then any particular help to answer one qusstion is wasted help. Among the lines of:

Give a hungy man a fish, and he will not be hungry for the day. Teach him how to fish, and he will never be hungry again.

I suggest sitting down and getting one o fthe books and reading them.|||lots of people rec' "SQL for Dummies", might be worth a look. No offense.|||Nevermind I figured it out without the book. Seems like developers are turning out to be like network engineers. No one wants to help anyone any more. When you need a quick answer because you're trying to meet a deadline a quick answer or a point in the right direction would be appreciated. Not go buy the book. Thanks.|||Sorry you feel like that. When the question is so very simple its more helpful to direct you to somewhere you can learn about the problem and other simple issues that you're bound to fall foul of.

From Visio 2003 to SQL

I am in the process of creating another database for one of our departments, I'm creating a diagram of the structure in visio 2003. I'm done with the diagram but when I try to export to sql it wont let me. Anyone ever had this problem before??
This is the Error message I'm getting

ODBC Error: 01000
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'Audit_Tbl' has been created but its maximum row size (20070) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.This just means that SQL got grumpy because the datatypes that you have chosen for this one table result in a table bigger than it likes. It gives you the warning about inserts and updates but in my experience inserts and updates still work. I was on a project where I had to break up a bunch large tables that exceeded the maximum field length to fix the design but the application still worked before I got there. One thing I did notice is that DTS may not work sometimes in tables that exceed 8060. Your table should have still been created or altered or whatever. this is just a warning.

Friendly Names of Dimension Attributes for ProClarity UI tool

Hi,

I am creating Cubes, Dimensions and most of all the SSAS objects using AMO. I use the data from a Oracle datawarehouse for this. Finally when the cubes are ready I use a front end tool called ProClarity Web Professional to create reports off it.

Proclarity displays the cube data with the dimensions as drop downs in the web page. The problem is that the Dimensions and its attributes display the label and value as "DIM_dimname_ColumName". This is because in SSAS the id is programmatically set as "DIM_DimName_ColumnName", This is a standard in the system and cant be changed.

Now I want ProClarity to display friendly names, that I would set in the ssas objects. I am not able to find any property in SSAS where i can set friendly names.

Guess: While I create reports in ProClarity, it gives me a option under Cube Options > Memeber Names > Show Default Names Or Show Alternate member Names. Proclarity displays a message saying that "Alternate names are only avaliable if they exists in the cube definition." Now my question is, does this have to do something with friendly names of the dim and dimAttirbutes? if so how to set them in SSAS?

Regards

Vijay R

Hi Vijay:

The IDs can definitely be changed in the XML. But I am not sure whether the AMO code will give you access to that. You could try setting the Dimension.Name property in your code.

Thanks.

Suranjan

free tools for creating sql script with records?

is there some freeware tools for that?
thanks!
On Thu, 9 Dec 2004 11:13:35 +0100, green_eye wrote:

>is there some freeware tools for that?
Hi green_eye,
http://vyaskn.tripod.com/code.htm#inserts
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Innovartis do a free data and schema scripter
http://www.innovartis.co.uk/Evaluation.aspx
"green_eye" wrote:

> is there some freeware tools for that?
> thanks!
>
>

free tools for creating sql script with records?

is there some freeware tools for that'
thanks!On Thu, 9 Dec 2004 11:13:35 +0100, green_eye wrote:
>is there some freeware tools for that'
Hi green_eye,
http://vyaskn.tripod.com/code.htm#inserts
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Innovartis do a free data and schema scripter
http://www.innovartis.co.uk/Evaluation.aspx
"green_eye" wrote:
> is there some freeware tools for that'
> thanks!
>
>

Free SQL Reporting Services or license?

I had attended course 2030 creating report using MS SQL Server Reporting
Service and I wonder how do I get this tool? Free or license?
I had license MS SQL Server 2000 and do I need to purchase or request MS SQL
Server 2000 Reporting Service?
Please advise.I have heard a couple ways to get Reporting Services. RS is free to use
with your SQL Server license.
1. From the vendor where you got your SQL server.
2. From MSDN
3. From Microsoft directly, but I do not know how.
There might be other ways, but that is what I have seen so far.
--
| From: "sam" <samuellai@.ajikl.com.my>
| Subject: Free SQL Reporting Services or license?
| Date: Thu, 7 Jul 2005 11:06:43 +0800
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#sj67DqgFHA.824@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 211.24.171.163
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47538
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I had attended course 2030 creating report using MS SQL Server Reporting
| Service and I wonder how do I get this tool? Free or license?
|
| I had license MS SQL Server 2000 and do I need to purchase or request MS
SQL
| Server 2000 Reporting Service?
|
| Please advise.
|
|
|

Fragmented databases and database backup

Hi,

If a database file size grows and shrinks it becomes fragmented. When creating a backup of a database and to restore it on another SQL Server, does it increase the fragmentation on that server?

How can I keep database files defragmented? Does SQL Server have tools for that or should Windows defragmentation tools be used?

/M

I think you are confusing data file fragmentation with disk fragmentation. They are two separate issues although they both affect performance of SQL Server.

If you backup your database and restore to a different server, it will not have any disk fragmentation if there is enough contiguous space to hold all of the data. Otherwise, it is at the mercy of the new disk drive.

For file fragmentation, creating a backup does not relocate data within the files. So a restored backup on a new server will have the exact same file fragmentation as the original version on the old server.

|||

Thank you for your answer, I was not aware of the two different framentation problems. Now I am curious on fragmentation solutions. Our SQL Server database is set to grow 10 % when needed and not to auto shrink.

I guess disk fragmentation can be solved using the standard Disk Defragmenter in Windows.

How can file fragmentation be solved within the database files?

/M