Database Discussion Boards

snouto29-Sep-09 21:28

29-Sep-09 21:28

hi everybody .

i am trying to use pivot
i use northwind data base

i try to execute the following sql statement in my sql server management studio

SELECT * FROM Orders
PIVOT (COUNT(employeeID) FOR employeeID IN ([1],[2],[3],[4],[5],[6],[7],[8],[9])) p

but it gives me that error , i don't know what is wrong with the above statement , actually i didn't change the query from the article that i learn from , i copied and pasted it inside the sql management studio

i got that error

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '('.

Human knowledge belongs to the world.

Re: pivot error

Mycroft Holmes30-Sep-09 0:42

Mycroft Holmes

30-Sep-09 0:42

I used this on AdventureWorks (I done't have northwind) and it worked fine. I got the IDs with a select distinct. Dammed if I can see a difference.

SELECT * FROM Sales.SalesOrderHeader
PIVOT (COUNT(SalesPersonID) FOR SalesPersonID IN ([274],[275],[276],[277])) p

Never underestimate the power of human stupidity
RAH

Re: pivot error

Syed Mehroz Alam30-Sep-09 0:50

Syed Mehroz Alam

30-Sep-09 0:50

Hi,

Your Northwind db may not have compatibility level of 90 which is a requirement for the Pivot clause. Try this:

ALTER DATABASE [NorthWind] SET COMPATIBILITY_LEVEL = 90

Hope that helps.

Regards,

Syed Mehroz Alam
My Blog | My Articles

Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

Re: pivot error

i.j.russell30-Sep-09 1:15

i.j.russell

30-Sep-09 1:15

It works fine on my machine! I am running Express 2005 but I have the extended Northwind database from http://www.linqdev.com/PublicPortal/publicportal/home.aspx[^].

how to backup oracle 10g

E_Gold29-Sep-09 9:58

E_Gold

29-Sep-09 9:58

hi
how i can backup oracle 10g like backup and restore in sql server ?

i want to backup tables and data

thank's in advance

Re: how to backup oracle 10g

Mycroft Holmes29-Sep-09 19:31

Mycroft Holmes

29-Sep-09 19:31

I thought the title was dumb - and even had this ready for you backup[^] but then I read the content.

Correct me if I'm wrong but you seem to be asking if you can back up an Oracle database and restore it into SQL Server, assuming I have not completely misinterpreted you question.

You CANNOT do that. There may be tools around that will allow you to generate a script from Oracle to create the equivalent database in SQL Server and then query the data across but backup is not going to work.

help required in adding dynamic columns and search anywhere in table ????

jarajeshwaran29-Sep-09 7:17

jarajeshwaran

29-Sep-09 7:17

Hi all,

I would like to get your help and guidance in implementing the following requirements.

please consider the following situation.
We have an address book application. The app will have fields like name/age/Sex by default. I want to give the user the freedom to add his own fields to the application. Like website address/email etc. This wil be decided by the user while the sets up the application for the first time. I have a clear understanding of doing this at the UI level(using dynamic controls to hold the value) how can the same be handled at the database level? Like how should the table be designed to accomodate this dynamic column creation.

my second requirement is
While we search our inbox in GMAIL using the default search box(not the advanced options) we key in the keyword. And gmail returns the results irrespective of where the search keyword appears( it may be in the subject line/ message body/from email address etc.)
I want the same feature be implemented in a windows application( I want the search to be done against all the columns in a given table or given set of tables).

www.BeginWithDisbelief.com

hi hi hi hi

Re: help required in adding dynamic columns and search anywhere in table ????

Mycroft Holmes29-Sep-09 19:43

Mycroft Holmes

29-Sep-09 19:43

Some ideas

1
Traditional solution is to have a number of user defined blank columns on a table and allow the user to name and use them. This limits the number of additional fields to the user defined columns you create. It does make query easier.

Another way is to have an attribute type and attribute table where the user can create a type (web address) and create an attribute record for an address where required. This allows unlimited attributes to be created but makes supporting queries more difficult.

2
You are asking for 2 very different things, GMail queries 2 or 3 fields, subject and body, you want to query any field in any table. A simple compound where clause using OR will do that.

Select *
From EmailTable
Where Address like '%searchstring%' or Subject like '%searchstring%' or Body like '%searchstring%'

Re: help required in adding dynamic columns and search anywhere in table ????

jarajeshwaran29-Sep-09 23:11

jarajeshwaran

29-Sep-09 23:11

for the first question do you suggest to me to have a table design as suggested here

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/9b781fae-a12d-4405-9a6e-9dd5421b4fc4/[^]

Fields

FieldID FieldName

1 Website

2 Home Phone

3 MSN

(the fieldnames will be user created)

Field Values

ContactID FieldID FieldValue

X 1 Hotmail.com

X 3 Abc

Y 2 65766786786

Y 1 msn.com

have I understook properly. or haven't I Confused | :confused:

the solution for my second requirement works like a breeze Cool | :cool:

(yikes why didnt I think of this)

hi hi hi hi

How to user SQLServer Authentication in SQL server management studio

AhmedMasum29-Sep-09 2:49

AhmedMasum

29-Sep-09 2:49

I have installed visual studio 2008. Then I installed sqlserver management studio. I connect using windows authentication. But there is another option to connect using sqlserver authentication. Where will I get the login name and password to connect using sqlserver authentication.

For test purpose I have connected using windowsauthentication and then created a login by right clicking the security folder and I have chosen sqlserver authentication and provided necessary information and clicked ok.
But when I tried to login by this new login name using sqlserver authentication It shows the following error:
"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.) (Microsoft SQL Server, Error: 233)"

Am I in the right way to login using sqlserver authentication? If I am in right way why I am getting the error?? Please help to solve the problem. I really need to test the option: sqlserver authentication

Re: How to user SQLServer Authentication in SQL server management studio

leckey29-Sep-09 3:28

leckey

29-Sep-09 3:28

1. Check that mixed mode authentication is enabled.
2. Check that the "sa" login is enabled; I think it's disabled by default.

Back in the blog beatch!
http://CraptasticNation.blogspot.com/[^]

Re: How to user SQLServer Authentication in SQL server management studio

AhmedMasum29-Sep-09 17:52

AhmedMasum

29-Sep-09 17:52

I have enabled the sa login. But how can I enable mixed mode?

Re: How to user SQLServer Authentication in SQL server management studio

Nisha Agrawal29-Sep-09 20:17

Nisha Agrawal

29-Sep-09 20:17

You can enable mix mode Authentication via connecting to SQL Server in Mamagement Studio via Windows Authentication then Open the Properties of the Server. Select Security Page listed in left panel.
At this page, there is Server Authentication Block, Choose SQL Server & Window Authentication Mode.

I hope it gonna help u.

Re: How to user SQLServer Authentication in SQL server management studio

AhmedMasum1-Oct-09 4:32

AhmedMasum

1-Oct-09 4:32

Thanks a lotzz!!! It's really great. It is working.... Smile | :)

Re: How to user SQLServer Authentication in SQL server management studio

Nisha Agrawal1-Oct-09 19:35

Nisha Agrawal

1-Oct-09 19:35

How can I backup my sql server 2008 database on a remote server??

Nada Adel29-Sep-09 0:33

Nada Adel

29-Sep-09 0:33

Unfortunately the server doesn't allow ftp for security so I can't backup the database and then send it through ftp to the other server.
So is there anyway I can do this from sql server 2008?
Is there a way to write the url or path of the remote server in order to save the backup file?
example: \\1.2.3.4\.... something like that?

Re: How can I backup my sql server 2008 database on a remote server??

Vimalsoft(Pty) Ltd29-Sep-09 1:16

Vimalsoft(Pty) Ltd

29-Sep-09 1:16

Backups are done Locally. That is why when you try to make a Backup, it only gives you a Local Filesystem option. So what you can do is that back them localy and move them Programatially.

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: How can I backup my sql server 2008 database on a remote server??

Nada Adel29-Sep-09 1:32

Nada Adel

29-Sep-09 1:32

Thanks for the reply.
Do you mean create something like a windows service to move the backuup file to another server? How can I do that if ftp is disabled on the server?

Re: How can I backup my sql server 2008 database on a remote server??

Vimalsoft(Pty) Ltd29-Sep-09 1:44

Vimalsoft(Pty) Ltd

29-Sep-09 1:44

If you cant have Access to the FTP , you can share the Folder in the Destination Folder and Map it in the Machine that does the Backups. and move the backups Between these Folder. You can Add this as a Batch File and that Batch File gets Executed as a Job in SQL After the Backups are done.

Hope this Helps

Re: How can I backup my sql server 2008 database on a remote server??

Nada Adel29-Sep-09 1:57

Nada Adel

29-Sep-09 1:57

I'm sorry for bothering you, but my problem is that the 2 server are on different networks.
So I don't know how to share folders between them.
Can you help out by explaining with an example?

Re: How can I backup my sql server 2008 database on a remote server?? [modified]

Vimalsoft(Pty) Ltd29-Sep-09 2:06

Vimalsoft(Pty) Ltd

29-Sep-09 2:06

You are not Bothering me. its my pleasure to help.

Can you Ping the Other Machine, meaning can you Ping from the computer that does the backups ?

Go to Run-->cmd

in the Command type

Ping <<IP or Computername>>

and see if there is a reply and post back the results here

modified on Tuesday, September 29, 2009 8:20 AM

Re: How can I backup my sql server 2008 database on a remote server??

Nada Adel29-Sep-09 2:40

Nada Adel

29-Sep-09 2:40

I pinged the other server successfully from the server that does the backups.

Re: How can I backup my sql server 2008 database on a remote server??

Vimalsoft(Pty) Ltd29-Sep-09 2:53

Vimalsoft(Pty) Ltd

29-Sep-09 2:53

Good, Go to your "My Computer" --> when you are there

Click on Tools-->Map Network Drive and Write the Following in the Folder Option

\\ComputerName\ShareName\

Remember the ShareName needs to be the name of the Share in the other Computer. So that means you need to go to the other Server and Create a Folder and Share it. The name of the Folder will be the name of the share. and Write a Small Program that will move the Files across

Re: How can I backup my sql server 2008 database on a remote server??

Nada Adel29-Sep-09 2:54

Nada Adel

29-Sep-09 2:54

So what's next??

Re: How can I backup my sql server 2008 database on a remote server??

Vimalsoft(Pty) Ltd29-Sep-09 3:19

Vimalsoft(Pty) Ltd

29-Sep-09 3:19

First Question. Do you automate your Backups to Happen at a Specific Time ?

The Next thing you need to do is to text if you can place any File in the Share. Just Copy any File and paste it in your Share. if you have no Permission Problems then its Cool. Create a New Project create a cmd Project

and Look at this Articles to Create a cmd application to Copy Files

http://msdn.microsoft.com/en-us/library/cc148994.aspx[^]

http://msdn.microsoft.com/en-us/library/system.io.file.copy%28VS.71%29.aspx[^]

http://www.dreamincode.net/code/snippet1807.htm[^]

http://www.computerhope.com/issues/ch000766.htm[^]

When you are Done , Create a Batch File and Tell it Execute this File, to Create a Batch File and Run the Batch File on the time you know your Backups will be Done. I was gonna say you must use Jobs in SQL, am not Sure if you know them .

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 14:44

Refresh

ᐊ Prev 1...753 754 755 756757758 759 760 761 762 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.