Help to Pivot the Following Table - Database Discussion Boards

First Prev Next

Re: Insert Data In Database

himanshu256115-Jun-09 0:03

himanshu2561

15-Jun-09 0:03

Just read some basic tutorials which ae easily available on google

himanshu

Re: Insert Data In Database

InvXeesh15-Jun-09 0:05

InvXeesh

15-Jun-09 0:05

I did try to find but didn't get any appropriate tut aur guide.. Cry | :((

Re: Insert Data In Database

himanshu256115-Jun-09 1:14

himanshu2561

15-Jun-09 1:14

string sql = "Insert into "TableName" (Column Name) values('Column Value')";
string connectionString = @"Data Source='local\SQLEXPRESS';Integrated Security=True;Pooling=False;Initial Catalog='MASTER'";
DataSet dtSet = new DataSet();
using (connection = new SqlConnection(connectionString))
{
command = new SqlCommand(sql, connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dtSet);
}

himanshu

Re: Insert Data In Database

Aman786Singh15-Jun-09 21:44

Aman786Singh

15-Jun-09 21:44

Is this himanshu kashyap from amritsar??

Re: Insert Data In Database

himanshu256115-Jun-09 22:32

himanshu2561

15-Jun-09 22:32

yes

himanshu

Enable TCP/IP and Named pipe in SQL Server 2005

Isaac Gordon14-Jun-09 21:33

Isaac Gordon

14-Jun-09 21:33

Hi Experts
i want to enable/disable tcp/ip and name pipe of sql server 2005 using command or query
not from wizard or internally open the window or SAC(Surface area Confg.).
Can You tell me what is query/command to enable the tcp/ip and namepipe.
Dines Sharma
Thank U

Re: Enable TCP/IP and Named pipe in SQL Server 2005

Niladri_Biswas17-Jun-09 20:29

Niladri_Biswas

17-Jun-09 20:29

You can use Windows Management Instrumentation (WMI) to configure SQL Server 2005 programmatically, including its protocols.

See the following article for more information:

Configure and manage SQL Server 2005 from your application using WMI
http://blogs.msdn.com/sql_protocols/archive/2005/10/19/482840.aspx

You can also use PowerShell to automate WMI

http://blogs.msdn.com/sql_protocols/archive/2008/08/29/configuring-sql-protocols-through-windows-powershell.aspx[^]
Smile | :)

Niladri Biswas

Help to Pivot the Following Table

Vimalsoft(Pty) Ltd14-Jun-09 20:29

Vimalsoft(Pty) Ltd

14-Jun-09 20:29

Good Morning All

Recently i posted some Sp that i had a problem with while working on a high volume of Data and someone suggested Pivot in sql . I goggled it and found that it was exactly what i was looking for , but i had a problem on the aggregate site because i wanted to Concatenate the Strings. here is the table structure.

ID              DESCR           CYCLETEMPLATE
====================================
7620	     Campbell P Dr	26
7620	     Campbell P Dr	27
7620	     Campbell P Dr	28
7620	     Campbell P Dr	29
7620            Campbell P Dr	      31
7621	      Jones D Dr	        23
7621	      Jones D Dr	        24
7621	      Jones D Dr	        26
7621	      Jones D Dr	        28
7621	      Jones D Dr	        29
7621	      Jones D Dr	        33
7621	      Jones D Dr 	       34

i want to Pivot it and it should look like this

ID              DESCR           CYCLETEMPLATE
===============================
7620	Campbell P Dr	26,2728,29,31
7621	Jones D Dr	23,24,26,28,29,33,34

The CycleTemplate will be Concatinated if the Description is the same and the Discription will not be duplicated again. as you can see in the above example. If your solution duplicated the Cycletemplate its ok, i have an efficient way of removing duplicates in a Field level.

Thank you

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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: Help to Pivot the Following Table

Mycroft Holmes14-Jun-09 21:18

Mycroft Holmes

14-Jun-09 21:18

Didn't someone supply a sample function to concat the strings. This is the way I would do it.

It would also depend on the number of doctors as well, too many would cripple the process. You cannot do this in a single pass select query.

Never underestimate the power of human stupidity
RAH

Backup database using sql 2005 Express Edition.

ram_panda0914-Jun-09 19:44

ram_panda09

14-Jun-09 19:44

Hi Team,

I'm a software developer and,
I want to make my hosting server database as my local server database for testing purpose.
But my problem is that, I'v downloaded the sql2005 ssmsee from msdn subscription and installed it in my Vista Home Premium.
The thing is that after installation the Import and Export Options are missing.
So I can't able to Import and Export the database.

So, please anybody help me to make the hosting server database as my local database.

Thanks in Adavance...

Thanks and Regards,
Rama Krishna Panda,
S.E.(.Net Tech.)
Ergode.com,Mumbai.

Re: Backup database using sql 2005 Express Edition.

Mycroft Holmes14-Jun-09 21:12

Mycroft Holmes

14-Jun-09 21:12

I'm pretty sure there is no option to Import a database. I use the developer version and I am able to restore a backed up database OR attach an MDF and LDF files. I can uses import of a table but there is not import database option.

Never underestimate the power of human stupidity
RAH

Re: Backup database using sql 2005 Express Edition.

Aman786Singh15-Jun-09 1:05

Aman786Singh

15-Jun-09 1:05

Download SQL express 2005 tool kit from Microsoft.com

and attach it with your running version as a external tools.

regards,
Aman

Re: Backup database using sql 2005 Express Edition.

Aman786Singh15-Jun-09 1:06

Aman786Singh

15-Jun-09 1:06

SQL server 2005 Express edition tool kit.

Re: Backup database using sql 2005 Express Edition.

K030616-Jun-09 1:55

K0306

16-Jun-09 1:55

first you get the database backup from your hosting server, then create a new database in your local server(database name may be same) and restore the backup database to your local server. There is option for Backup & Restore options in Express edition

In Sql Server 2005 Express Edition - there is no Import & Export options, if you need this option you should by the standard edition or professional edtion etc,,,

Unicode Column Alias [modified]

Mustafa Ismail Mustafa14-Jun-09 6:57

Mustafa Ismail Mustafa

14-Jun-09 6:57

This issue has been giving me some grief and maybe one of you guys can shed some light on how to solve it and why does it happen.

Look at the following:

Select [PatientID] as [رقم المريض] from EMR.Patient;

(if you can't see the Arabic characters between the square brackets its OK Smile | :)

)

This is a very straight forward statement and the column alias works perfectly fine.

Doing this:

DECLARE @SQL nvarchar(250);
SET @SQL='Select [PatientID] as [رقم المريض] from EMR.Patient';

EXEC sp_executesql @SQL;

Returns a column titled [??? ?????] instead of the unicode alias. I tried setting it as a string and that didn't work either.

Any clues?

TIA

[edit]
http://www.sommarskog.se/dynamic_sql.html#columnalias[^]

This is a solution, but it seems a bit complicated for something seemingly simple.

If the post was helpful, please vote!

Current activities:
Book: Devils by Fyodor Dostoyevsky
Project: Hospital Automation, final stage
Learning: Image analysis, LINQ

Now and forever, defiant to the end.
What is Multiple Sclerosis[^]?

modified on Sunday, June 14, 2009 1:22 PM

Re: Unicode Column Alias [modified]

Mycroft Holmes14-Jun-09 15:13

Mycroft Holmes

14-Jun-09 15:13

I would assume that sp_executesql will use a standard ascii character set to interpret the string @SQL. Try prefixing the string the N, this is designed for unicode (I think, I have limited experience with unicode)

And I can't post unicode in the message

SET @SQL=N'Select [PatientID] as [] from EMR.Patient';

Test - works for me Big Grin | :-D

DECLARE @SQL NVARCHAR(1000)
set @SQL = N'SELECT PatientIDAS [stick your funny text in here] FROM EMR.Patient'

EXEC (@SQL)

Last modified: 1hr 4mins after originally posted --

Never underestimate the power of human stupidity
RAH

Re: Unicode Column Alias

Mustafa Ismail Mustafa14-Jun-09 23:41

Mustafa Ismail Mustafa

14-Jun-09 23:41

I am such a fool! D'Oh! | :doh:

Thanks a million, works like a charm!

i need help with oracle database!

Eldad_kd14-Jun-09 6:17

Eldad_kd

14-Jun-09 6:17

hi
i need help with oracle database!
i have 2 tables in my database A and B. i want add the diffrance between A and B in B and also get the result.
i calculated A-B but i only get to result or insert it to B but i need to to them both!
in ms-sql i saved A-B into temporary table then read from that table and insert it into B
but it doesn't work in oracle

can anyone help me!?!
thanks Eldad.

Re: i need help with oracle database!

David Mujica15-Jun-09 3:03

David Mujica

15-Jun-09 3:03

Sounds like you want something like this:

Select (stuff from table A)
UNION
Select (table A - table B)

You don't give any details about the tables, so that is the best I can do.

David

Auditing in Database!!

Sr...Frank13-Jun-09 23:34

Sr...Frank

13-Jun-09 23:34

Hi Guys,

I have never used auditing in MSSQL Server2005.
Could you please let me know right steps to use auditing for my Database?

Thanks

Roll eyes | :rolleyes:

Re: Auditing in Database!!

Mycroft Holmes14-Jun-09 15:16

Mycroft Holmes

14-Jun-09 15:16

People write books on database auditing and you want a precis in a forum post. Do a search on SQL 2005 auditing[^] in Google, read some of the articles and come back with a more specific problem.

Never underestimate the power of human stupidity
RAH

Re: Auditing in Database!!

Sr...Frank18-Jun-09 7:40

Sr...Frank

18-Jun-09 7:40

Thanks!

Re: Auditing in Database!!

Niladri_Biswas17-Jun-09 20:51

Niladri_Biswas

17-Jun-09 20:51