How to create SQL function - Database Discussion Boards

_Damian S_24-Oct-07 20:24

24-Oct-07 20:24

select School, Semester, Grade, Campus,
sum(CASE WHEN Status = 'Accepted' THEN 1 ELSE 0 END) AS NumOfAccepted,
sum(CASE WHEN Status = 'Rejected' THEN 1 ELSE 0 END) AS NumOfRejected
from StudentResult
group by School, Semester, Grade, Campus

Of course, this is what you have asked for, but not necessarily the best way of going about it... you could always just use count (*) and use the Status as a Column heading also...

-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!

how to know other users are connecting to my sql database

skyleo_200824-Oct-07 17:06

skyleo_2008

24-Oct-07 17:06

hihi,i'm new baby in sql.So, I would like ask someone can help me solve a question as posted as below.

1. As a admin, i need to know who is connecting to my sql database.But,I have no idea to get the method to detect who is connecting to my sql database

thank for your help

Re: how to know other users are connecting to my sql database

N a v a n e e t h24-Oct-07 20:36

N a v a n e e t h

24-Oct-07 20:36

Running sp_who2 will give necessary details

My Website | Ask smart questions

Re: how to know other users are connecting to my sql database

skyleo_200824-Oct-07 22:04

skyleo_2008

24-Oct-07 22:04

thank for your helping.
But, can you explain more detail about 'sp_who2'.
I really have no idea to 'sp_who2'.

Thank again

Re: how to know other users are connecting to my sql database

N a v a n e e t h24-Oct-07 22:54

N a v a n e e t h

24-Oct-07 22:54

sp_who[^]

My Website | Ask smart questions

Re: how to know other users are connecting to my sql database

John-ph25-Oct-07 3:08

John-ph

25-Oct-07 3:08

select [name] from sysusers where [name] <> 'dbo' and islogin = 1

Regards
- J O H N -

Re: how to know other users are connecting to my sql database

skyleo_200825-Oct-07 15:01

skyleo_2008

25-Oct-07 15:01

thank for help.I can solve my problem.thank again.

How to create SQL function

Yulianto.24-Oct-07 16:25

Yulianto.

24-Oct-07 16:25

I want to update table, with this following code:

declare @parentid int<br />
				select accountparentid=@parentid from account where accountid=@accountid<br />
				<br />
				while @parentid<> 0<br />
				begin<br />
					UPDATE [dbo].[account]<br />
					   SET [accountvalue] = [accountvalue]+@accountvalue<br />
								where accountid=@parentid<br />
					select accountparentid=@parentid from account where accountid=@parentid<br />
END

How do I create the function in SQL with the name UpdateAccountParent, I'm using C# express. This should be easy. Thanks.

<italic>Work hard, Work effectively.
Stock Pick

Re: How to create SQL function

Tirthadip24-Oct-07 21:04

Tirthadip

24-Oct-07 21:04

consult MSDN[^]

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

Newbie: round control buttons

lee_hatcher24-Oct-07 14:48

lee_hatcher

24-Oct-07 14:48

Hi My name is Lee Hatcher and I am a newbie to Access and sql. This has probally already been asked but I am trying to create round control buttons for them. Any help will be appreciated.

Thanks,

Lee

Re: Newbie: round control buttons

Paddy Boyd25-Oct-07 4:06

Paddy Boyd

25-Oct-07 4:06

Round buttons for sql??

What are you doing?

Re: Newbie: round control buttons

lee_hatcher25-Oct-07 5:06

lee_hatcher

25-Oct-07 5:06

Patty

Thanks for the response. Big Grin | :-D

I have created a database for a company in sql with an access front end and would like round control buttons instead of squares and rectangles. It is not necessary but I would like some personal touches to it.

Thanks

Lee

Re: Newbie: round control buttons

Paddy Boyd25-Oct-07 5:30

Paddy Boyd

25-Oct-07 5:30

Good luck customising an access front end. If it's not necessary, then i'd just save yourself a lot of pain and heartache and deploy it... If they want a pretty front end, make them pay you for it and do it in using decent tools...

Re: Newbie: round control buttons

lee_hatcher25-Oct-07 5:39

lee_hatcher

25-Oct-07 5:39

Thanks again Paddy,

Ok what would you suggest for a front end VB?

Thanks
Lee Big Grin | :-D

DTSX and file locations

CurtOlive24-Oct-07 12:06

CurtOlive

24-Oct-07 12:06

I am executing a DTSX from a VB.Net application. Problem is that when I built the DTSX to do importing of the flat files, it has hardcoded the locations of the Flatfiles. I want to be able to set a variable for the file's location and pass that variable in the vb coding. HOW CAN I SETUP THE FILE LOCATIONS TO BE VARIABLES PASSED IN? How do I pass it in?

'Here we import the files from the file location into Loader's tables
Dim app As New Application()
Dim vars As Variables
Dim AppPath As String
AppPath = My.Application.Info.DirectoryPath
Dim package As Package = app.LoadPackage(AppPath & "\AutoLoaderPkg.dtsx", Nothing)
vars = package.Variables
vars("fileLocation").Value = gsFileLocale

Dim result As DTSExecResult = package.Execute()
If result = DTSExecResult.Success Then
FileImport = True
Else
FileImport = False
End If

Run SQL query in A2T Application

wellpoint24-Oct-07 9:01

wellpoint

24-Oct-07 9:01

Does anybody know if I can run SQL query in A2T Application? and How? Thanks.

Jane

Re: Run SQL query in A2T Application

Dave Kreskowiak24-Oct-07 9:38

Dave Kreskowiak

24-Oct-07 9:38

Pardon my ignorance, but what's an "A2T application?"

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Installing SQL 2008 VHDs

Mark J. Miller24-Oct-07 3:29

Mark J. Miller

24-Oct-07 3:29

I'm trying to install the SQL 2008 VHDs from MSDN on WinXP MC running Virtual PC 2007. But it asks me for the archive "en_sql_server_2008_ctp_4_vhd_part_1_of_5_.rar", which doesn't exist on MDSN subscriber downloads. Has anyone else had trouble installing this? I googled the file name and there's only one post out there, with no response.

Re: Installing SQL 2008 VHDs

Mike Dimmick24-Oct-07 4:15

Mike Dimmick

24-Oct-07 4:15

Yes, somehow they've mangled it. When it asks for each file, just give it the next part in sequence:

part_1_of_5.rar -> part_2_of_4.rar
part_2_of_5.rar -> part_3_of_4.rar
part_3_of_5.rar -> part_4_of_4.rar

Presumably they've used a self-extracting executable because a .vhd is generally very compressible and it shaves a lot off the download time. I can't recall if the MSDN downloader uses the Attachment Security stuff added in XP SP2 to give the download the 'mark of the web'. If it does, one reason for carving it into pieces might be to save having to check all 2GB of the file for a signature when you run the first piece.

They can't make it a standalone ZIP because the file's bigger than 4GB and the built-in 'Compressed Folders' in Windows XP and Server 2003 can't handle the ZIP64 extensions to get around the 4GB file limit.

DoEvents: Generating unexpected recursion since 1991

Re: Installing SQL 2008 VHDs

Mark J. Miller24-Oct-07 4:36

Mark J. Miller

24-Oct-07 4:36

Thanks. I'll do that.

Re: Installing SQL 2008 VHDs

TJoe24-Oct-07 5:17

TJoe

24-Oct-07 5:17

I downloaded this from MSDN[^] earlier today and it worked fine. Did you get another version or from a different location?

The file may have been corrupted.

Take care,
Tom

-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com

Re: Installing SQL 2008 VHDs

Mike Dimmick25-Oct-07 5:16

Mike Dimmick

25-Oct-07 5:16

The version on MSDN Subscriber Downloads has the problem mentioned.

DoEvents: Generating unexpected recursion since 1991

Restoring backups between SQL Server 2005 Editions

Mridang Agarwalla24-Oct-07 1:50

Mridang Agarwalla

24-Oct-07 1:50

Hi Guys,

Is it possible to restore a backup of SQL Server 2005 Enterprise/Standard Edition onto a SQL Server 2005 Express Edition DB.

I have a small backup file. its really small. Can someone just restore the backup for me and generate an SQL script from it. I need the script. I'll be lost without it.

Thanks in advance everyone.

Re: Restoring backups between SQL Server 2005 Editions

Marek Grzenkowicz24-Oct-07 3:28

Marek Grzenkowicz

24-Oct-07 3:28

Mridang Agarwal wrote:
Is it possible to restore a backup of SQL Server 2005 Enterprise/Standard Edition onto a SQL Server 2005 Express Edition DB.

I've never done this myself, but I'm almost 100% sure that it is possible.

Mridang Agarwal wrote:

I have a small backup file. its really small. Can someone just restore the backup for me and generate an SQL script from it. I need the script.

Can you restore a backup using a SQL Server Management Studio? If yes, you can generate an appropriate script automatically in SSMS. (Of course I could paste you the script here right away, but if you do it yourself you'll learn more.)

SQL Tables

Illegal Operation24-Oct-07 1:26

Illegal Operation

24-Oct-07 1:26

I need some advice.

I have 2 tables. They are not related in any way except that they are in the same DB. Now I need to write a select query where it returns the columns from table1 and columns from table2.

How can I achieve this?

My Query at the moment is:

SELECT Table1.Column1, Table1.Column2, Table2.Column1 AS EXPR1 FROM Table1 CROSS JOIN Table1 AS Table2

Thank you in advance!!

Illegal Operation

Making Computer Software Talk

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