Noob Question For Msde2000

Apr 20, 2004

looks like a noob question but how can i manage msde2000...i can see sql is runnin but how can i create database , attach/detach database, write functions and so on...

thanx alot for the reply :)

View 2 Replies


ADVERTISEMENT

Installing MSDE2000

Aug 26, 2004

Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.

Anybody know why this is?

View 1 Replies View Related

Need Help Setting Up Msde2000

May 23, 2005

hey guys heres my problem iam trying to install SQL server2000 but i keep on running into problems....??
here is what iam having problems with
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL
it keeps saying the instance name specified is invalid there has to be an easyer way to run the program...??
i have all ready set up an instance name and the SAPWD.
any suggestions?? please help

View 2 Replies View Related

MSDE2000 And SQL ExpressCTP

Sep 11, 2005

Hi,

I have a problem with the database that I created using MSDE 2000 SP4. I tried to attached the database into the new SQL Express using the sp_attach_db and it worked. The message mentioned is that the DB has been upgraded. When I tried to attach back the DB back to my MSDE, it can't be done.

My PC is XP pro SP2. Before I reattach the DB back to MSDE, I detach the DB from my SQL express.

Is it because once the SQL express upgraded the DB, it cannot be supported by MSDE or SQL 2000 ?

Thanks. Any help is greatly appreciated.

View 1 Replies View Related

Msde2000 Installation

Jan 23, 2007

Hi

Im installing MSDE2000 on new Machine Pentium IV LGA Processor HT technology; OS Windows 2000 Professional. Its getting roll Back after some installation.

The same setup if im installing on my other new Machine With Scoket 478 Processor OS Windows2000 Professional. Its installing completly.

Is there any compatibilty problem.

Please Advice me what to do. Thanks In advance

View 2 Replies View Related

Uninstalling Msde2000

Oct 23, 2006

Ii have installed msde 2000 now all my Access files are in 2000 format how do i change back to 2003?

View 1 Replies View Related

SQL Server MSDE2000 Problems...

Feb 25, 2008

Hi there,

I'm having some trouble with my MSDE2000 (version 8.00.194) and I'd appreciate any insight you could provide...

Long story short, I'm not sure what went wrong, but after stopping my SQL server to change DBs, it wouldn't start again. On the server, it showed no errors. In my services list, it said something along the lines of 'This service has no actions to perform, and so will not start'. It was a few days back, so I forget the exact message...

After restarting my PC, the service started without any errors, but my ODBC Connections will not find my SQL server. I get the following messages with the following scenarios:

Server: (local) : SQL server does not exist or access denied.
Server: . : Specified SQL server not found.
Server: 127.0.0.1 : Login failed for user <username>.
Server: <PC name> : Login failed for user <username>.

I have come across a similar issue before, where re-installing the MSDE sorted it out, this time however, I cannot uninstall the desktop engine: simply shows 'An error has occured during the installation' and nothing else after that. I also cannot apply any service packs, I get the same message as above. I have also tried upgrading to MSDE2005 (using company CDs on my PC at work), to be told that the installation has been blocked due to the following software: 'MSDE2000 8.00.194'.

For the record, I have also installed SP3 for Win XP... Not sure if that might be the issue? I somehow doubt it though. I tried a system restore to the day before the problem started, and it is still doing the same after a successful restore.

Help?!? Please? I need an SQL server for my work software to function correctly, I work in a busy call centre and I cannot get this fixed myself. I'm on the brink of formatting with a fresh install if XP.

Regards,
Andre.

View 6 Replies View Related

Can Not Attach Msde2000 Db Into Sql Express

Jun 19, 2007

I have side by side msde2000 and sqlexpress installed. I need to move a db that has been detached from msde2000 and where it works perfectly fine into sql express. After I select the .mdf file to attach I get this error:



TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'LTBAHIASQLEXPRESS'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x55555551). It occurred during a read of page (1:97) in database ID 6 at offset 0x000000000c2000 in file 'C:Memo2005DiaryMEMOinMEMOsql.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Converting database 'MEMOsql' from version 539 to the current version 611.
Database 'MEMOsql' running the upgrade step from version 539 to version 551. (Microsoft SQL Server, Error: 824)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=824&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------






Thanks for any help,



Luis

View 6 Replies View Related

Does The MSDE2000 Sp3a Come With Northwind Database

Jan 30, 2004

I just downloaded and installed MSDE2000 sp3a for winform and asp.net
quickstart tutorial. But I found it has no sample database such as pubs
and northwind. It used to have these databases. At least in last September
when .Net web Matrix came out.

If this is the case, can someone tell me where to get the sql scripts
to create Northwind database in MSDE?
Becasue the winform tutorial uses this database.

Thanks in advance!

Lei Xu

View 1 Replies View Related

Win98, MSDE2000, Connection Problems

Oct 12, 2004

hi there,

i have following system:

the MSDN is running on a win98 machine,
the client-applications, which uses the DB are running on winXP.

there are (SOMETIME!) connection problems to the DB, i guess because of
connection timeouts.

unfortunately i can not change the system, i only can change some setting
or install additionally components such as MDAC.

what can i do,
please help me, it is a support case for a customer.

thank you very much.
mik

View 1 Replies View Related

Can V Install Msde2000 N SqlServerExpress Simultan

Mar 12, 2008

Hello !

I have installed msde2000A , but wanted to use Adventure Works database for which I am trying to install sql server express edition 2005 ,
But I want to install it w/o removing earlier msde2000A .

Is it possible.. I was guessing I could install 2 instances .
1st of mase200A and 2nd that of sql express edition 2005.

If it is poss , how to do that ? any other particular procedure / or normal install procedure .

Any one can help ?
Thanks
Bobo

View 2 Replies View Related

Installing MSDE2000 For Remote Connection

Jul 23, 2005

I attempted to install MSDE on a WinXP machine(server) today. I installedfrom the command prompt as follows:-[color=blue]>setup INSTANCENAME="NetSDK" SECURITYMODE=SQL BLANKSAPWD=1[/color]Before I get 'blasted', I know that I 'really shouldn't' use a blank sa pswdbut.......I did :-)I then detached (sp_detachdb) an existing db from another machine. Moved itonto the new instance and reattached it.Finally, I executed the following scripts:-sp_addlogin @loginame = 'name', @passwd = 'password', @defdb = 'dbName'sp_grantdbaccess 'name'sp_addrolemember 'db_owner', 'name'So, this was fine and I could connect to the new db using either windowsintegrated security or 'name'/'password' BUT..BIG BUT, only at the server.When I tried to connect from a client I received an error message, 'SQLServer Does Not Exist or Access Denied'.I am assuming that all is well with the db and that it is something I havedone...or more probably not done with the sql server instance (as the errorsuggests:-). Can anyone please suggest my error?Thanks

View 3 Replies View Related

Problem With Updating MSDE2000 To SQLServer2005Express

Feb 28, 2008

Hi,


i have a problem when i try to do an inplace update of msde2000 to SQLServer2005Express (adv.).

The following error message is displayed:

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft]
[SQL Native Client][SQL Server]Incorrect syntax near '='..Refer to the server error logs and Setup logs for detailed error information

Has anyone a suggestion to solve the problem ?

thank you in forward.

BR
Jürgen

View 4 Replies View Related

Failed To Upgrade MSDE2000 SP3a To SP4

Aug 24, 2006

Hi,

Recently when i try to upgrade my current MSDE 2000 (SP3a) to SP4, the system just keep on failing me. Here is the scenario:

1. Download the MSDE2000 SP4 from microsoft

2. Extract the SP4

3. Run the following command in either the command prompt or via a batch file:

echo off
echo "Start to Upgrade MSDE SP4 ... "
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=Th3B3st /L*v c:MSDE_Log.log
echo "SP4 Upgrade Process completed!"

4. Once the above batch file was runned, the standard SQL configuration screen (gathering information) will be triggered.

5. However after a while the installation will just stopped.

6. When i checked on the log, i have found out that the failure of installation is due to the system has failed to configure the server. PFB for the last few rows of the verbose log:

=== Logging stopped: 8/22/2006 17:36:49 ===
MSI (c) (90:88) [17:36:49:865]: Note: 1: 1729
MSI (c) (90:88) [17:36:49:865]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.

MSI (c) (90:88) [17:36:49:865]: Grabbed execution mutex.
MSI (c) (90:88) [17:36:49:865]: Cleaning up uninstalled install packages, if any exist
MSI (c) (90:88) [17:36:49:865]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/22/2006 17:36:49 ===

7. When i check the MSI Installer Event ID at Microsoft site, it just said that this is the server configuration problem and i cant find any solution.

Any forumers here experience the above before? Mind to share some thoughts?

FYI, my current MSDE configuration is as follow:

- MSDE 2000 Release A (SP3a - 8.00.760)

- Installed Instance = JSNG



Thanks.

regards,

JS

View 1 Replies View Related

Upgrade From Msde2000 To SQL 2005 Express

May 19, 2006

Has any one had experience with upgrading MSDE2000 with no instance to SQL2005 Express?

Thanks

ZS

View 1 Replies View Related

Creating WorkGroup/User Account In MSDE2000

Mar 3, 2004

Hi

I am using MS Access project as a frontend and MSDE 2000 as a backend database. I have few users and i want to give every one restricted access to database based on their use.

How can i create user accounts. I checked tools-->Security--> but workgroup admin option is not active. How to solve this puzzle

Thanks in advance

Neha

View 1 Replies View Related

Client(Win XPpro)-&>server(MSDE2000 SP3) Problem

Mar 12, 2004

Can't connect from Win XPpro to named instance nor default instance on server running MSDE2000 SP3 via LAN (WORKGROUP). Works fine from Win 2K in the same network. Attached screen shot of error message. Osql gives the same response.

View 2 Replies View Related

Can You Install MSDE2000 After You Have Installed SQL Server Express?

Jul 26, 2006

I am aware that instances of both can exist on the same machine.

But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000

Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again.

I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005.

When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back.

In the event log, there is an entry

The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: (SpnRegister) : Error 1355.

I have down all the usual things like uninstalling SQL Server Express 2005 (using control panel and msiexec /x {GUID}), patching the registry etc etc

The result is always the same.

The Sony Media Manager is not important and I probably won't use it but it's annoying the hell out of me - I've always claimed, over a good few years, that there was no computer problem that I couldn't finally solve, but presently this has got me beat and I feel undone!!!!!!! :-)

regards

Stuart

www.mckears.com

View 3 Replies View Related

Rolled Back And Unfinish Installing MSDE2000

Oct 11, 2006

I'm trying to install the MSDE2000 on window xp, sp2. During the installing, apperance the percent bar is rolling back, which is not even completed install. I had read the issue from microsoft to restart the server service, and...but no luck. Is there anyone has an ideas.

View 1 Replies View Related

Problems Of Installing MSDE2000 In WinXP Home Edition

Apr 12, 2005

My Problems & Situation:Hi! I am a ASP.NET starter. My platform is WinXP Home Edition and I haven't installed any version of SQL server before.I download different version of MSDE and extracted in my C drive separately, including:   1.  Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A   2.  Microsoft SQL Server 2000 Service Pack 3a (contained MSDE 2000)   3.  MSDE 2000 for Developers Using Visual Studio .NETsince all of the above versions have the same problem when I try to install it.
The problem is that when I double click each of the setup.exe, it will show a pop up error:[A strong SA password is requires for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit.]
Then I found a solution from Microsoft, it told me that: 1. Run the setup in the command prompt 2. Locate in the extracted path 3. type --> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<pwd>"
p.s. I have changed the <pwd> to 123abc
However....another Error Occur:1st pop up --> [Unable to determine system default collation.]2nd pop up --> [Microsoft SQL Server Desktop Engine Setup failed.]
My Question:1. Why the error still occour when I type that command to setup? (Solution from Microsoft)2. How can I fix it and complete the installation?3. How many users(maximum) can be created in a MSDE database?
Greateful if anyone can give me hand.

View 3 Replies View Related

How To Add Login User (ASPNET) To MS SQL 2000 Desktop Engine Server (MSDE2000)?

Sep 21, 2004

How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.

View 1 Replies View Related

T-SQL Noob!!!

Dec 21, 2005

In VB, I have this code...


lSQL = "SELECT * FROM OPENQUERY(liorder,'SELECT a.KF_ORDER_NO AS OrdNo, f.KU_NAME AS Customer, " & _
"a.KF_ORDER_POS AS Pos, a.KF_SCHEIB_NR AS Pane, a.KF_QTY AS Qty, d.BREITE*d.HOEHE/1000*a.KF_QTY AS SQM, " & _
"a.KF_QTY*d.SUM_NETTO AS Val, a.KF_FERT_QTY AS Done, d.BREITE*d.HOEHE/1000*a.KF_FERT_QTY AS DoneSQM, " & _
"a.KF_FERT_QTY*d.SUM_NETTO AS DoneVal FROM LIORDER.AUF_KOPF c, LIPROD.KAPA_AUS_FERT a, LIORDER.KUST_ADR f, " & _
"LIORDER.AUF_POS d WHERE (f.KU_VK_EK = 0) AND (a.KF_SCHR_NR = 12) AND (c.AUF_NR = a.KF_ORDER_NO) AND " & _
"(c.KUNR = f.KU_NR) AND (a.KF_ORDER_NO = d.AUF_NR) AND (a.KF_ORDER_POS = d.AUF_POS) AND (f.KU_NAME IS NOT NULL) " & _
"GROUP BY a.KF_ORDER_NO, f.KU_NAME, a.KF_ORDER_POS, a.KF_SCHEIB_NR, a.KF_QTY, d.BREITE, d.HOEHE, a.KF_FERT_QTY, d.SUM_NETTO')"
Set RS = New ADODB.Recordset
RS.Open lSQL, DB

Do While Not RS.EOF
Select Case RS!Pane
Case "0" Or "1"
glassSQL = "SELECT IDNR, GL_BEZ FROM OPENQUERY(liorder, 'SELECT a.IDNR, a.GL_BEZ FROM LIORDER.GLAS_DATEN a, LIORDER.AUF_POS b " & _
"WHERE a.IDNR = b.GLAS1 AND b.AUF_NR = " & RS!OrdNo & " AND b.AUF_POS = " & RS!Pos & "')"
Set glassRS = New ADODB.Recordset
glassRS.Open glassSQL, DB

SQL = "INSERT INTO PendingLamination (OrdNo, Customer, Pos, Code, GlassDesc, Qty, SQM, Val, Done, DoneSQM, DoneVal) " & _
"VALUES ('" & RS!OrdNo & "', '" & Apostrophe(RS!Customer) & "', '" & RS!Pos & "', '" & glassRS!IDNR & "', '" & glassRS!GL_BEZ & _
"', '" & RS!Qty & "', '" & RS!SQM & "', '" & RS!Val & "', '" & RS!Done & "', '" & RS!DoneSQM & "', '" & RS!DoneVal & "')"
DB.Execute SQL
Case "2"
glassSQL = "SELECT IDNR, GL_BEZ FROM OPENQUERY(liorder, 'SELECT a.IDNR, a.GL_BEZ FROM LIORDER.GLAS_DATEN a, LIORDER.AUF_POS b " & _
"WHERE a.IDNR = b.GLAS2 AND b.AUF_NR = " & RS!OrdNo & " AND b.AUF_POS = " & RS!Pos & "')"
Set glassRS = New ADODB.Recordset
glassRS.Open glassSQL, DB

SQL = "INSERT INTO PendingLamination (OrdNo, Customer, Pos, Code, GlassDesc, Qty, SQM, Val, Done, DoneSQM, DoneVal) " & _
"VALUES ('" & RS!OrdNo & "', '" & Apostrophe(RS!Customer) & "', '" & RS!Pos & "', '" & glassRS!IDNR & "', '" & glassRS!GL_BEZ & _
"', '" & RS!Qty & "', '" & RS!SQM & "', '" & RS!Val & "', '" & RS!Done & "', '" & RS!DoneSQM & "', '" & RS!DoneVal & "')"
DB.Execute SQL
Case "3"
glassSQL = "SELECT IDNR, GL_BEZ FROM OPENQUERY(liorder, 'SELECT a.IDNR, a.GL_BEZ FROM LIORDER.GLAS_DATEN a, LIORDER.AUF_POS b " & _
"WHERE a.IDNR = b.GLAS3 AND b.AUF_NR = " & RS!OrdNo & " AND b.AUF_POS = " & RS!Pos & "')"
Set glassRS = New ADODB.Recordset
glassRS.Open glassSQL, DB

SQL = "INSERT INTO PendingLamination (OrdNo, Customer, Pos, Code, GlassDesc, Qty, SQM, Val, Done, DoneSQM, DoneVal) " & _
"VALUES ('" & RS!OrdNo & "', '" & Apostrophe(RS!Customer) & "', '" & RS!Pos & "', '" & glassRS!IDNR & "', '" & glassRS!GL_BEZ & _
"', '" & RS!Qty & "', '" & RS!SQM & "', '" & RS!Val & "', '" & RS!Done & "', '" & RS!DoneSQM & "', '" & RS!DoneVal & "')"
DB.Execute SQL
End Select

ProgressBar1.Value = ProgressBar1.Value + 1

If ProgressBar1.Value = 800 Then
ProgressBar1.Value = 0
End If

RS.MoveNext
Loop

...and I'm planning to use the same flow of logic in the SQL Server Agent using T-SQL. Is there any way I can do it?

View 6 Replies View Related

Noob: How Do I Run Pl/sql On Ms Sql?

Feb 9, 2004

Hi experts,

I'm using MS SQL 2000. The closest i could get to having pl/sql within ms sql was tru its stored procedures feature.

I created a new stored procedure within the built-in Northwind database. I pasted the following inside:

-----------------------------------------------------------------
declare

vname Employees.firstname%TYPE;

begin

SELECT firstname INTO vname FROM Employees
WHERE firstname = 'Nancy';

dbms_output.put_line ('Name is ' || vname);

EXCEPTION

when NO_DATA_FOUND then
dbms_output.put_line ('no data found');

when TOO_MANY_RECORDS then
dbms_output.put_line ('too many records');


END;

-----------------------------------------------------------------


I checked the syntax and i get some error about the employees table.
Error 155: 'Employees' is not a recognized cursor option

Any idea?

Thanks..

View 1 Replies View Related

SQL Noob Needs Help

Aug 25, 2005

Mike writes "I have a string, >!~[99DC# 4.12$2251.% 1.63& 3.58'2150.(-2050.>/~]

and I would like to extract parts of it and send it to a SQL database. here is the layout and data that should be in each column. The Data column will be filled in automatically, but once that happens I would like the other columns to get their data from the Data column.

Data = >!~[99DC# 4.12$2251.% 1.63& 3.58'2150.(-2050.>/~]
Display_Address = 99
CE = 4.12
TPK = 2251
Si= 1.63
C = 3.58
TPL = 2150
TPS = 2050

Can anyone tell me how to do this?"

View 1 Replies View Related

Noob Needs Help!

Jun 7, 2007

/* hi people im doing a task and im not sure about some things. could u check if what im doing is good plz.*/

The task is:
Produce a list of all female employees who earn more than the average salary of the male employees in the company. Display employee number, first name and last name.

The table: emp
Attributes: EMPNO, FIRSTNAME, LASTNAME, SEX, SALARY

What i came up with:
selectempno, firstname, lastname
fromemp
whereavg(salary)>any(selectavg(salary)
fromemp
wheresex='M')
group by sex
havingsex = 'F'

View 3 Replies View Related

Noob SQL Help

Aug 7, 2007

Here is my code to connect, any help would be appreciated. I am a total noob at this.

############### Code

<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="orderofb_test"; // Database name
$tbl_name="orderofb_test.members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from signup form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>


This is the error message I receive.

############### Code

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/orderofb/public_html/php/checklogin.php on line 11
cannot connect


I changed all the permissons to 777 and I still receive this error.

$tbl_name="orderofb_test.members"; // Table name

Is this the correct table name? Here is a pic of my phpmyadmin

http://mnetcs.com/thumb/storage/b3583134.JPG

View 2 Replies View Related

SQL Noob Help Required

Sep 26, 2007

I am trying to create a script that will return information from 4 different tables in a database using different where clauses.

This is working correctly, however the primary table the query uses has multiple entries for different people and i only want to return the last row per person.
I have got this to work using a MAX(t.column) statement, but when used in conjunction with all the where clauses things go wrong.

This is what i have


Code:

CREATE VIEW Firereport1 AS

select max(t.punch_id) as punch, e.EMPLOYEE_FIRSTNAME, e.EMPLOYEE_LASTNAME, c.CLOCK_NAME, t.PUNCH_TIME, d.DEPT2_DESCRIPTION

FROM TM_PUNCH t, EMPLOYEE e, COMM_CLOCK c, DEPT2 d

WHERE t.PUNCH_EMPID = e.EMPLOYEE_ID
and e.EMPLOYEE_ONCLOCK <> 'False'
and e.EMPLOYEE_LASTTIMELOC = c.CLOCK_ID
and e.EMPLOYEE_LASTDEPT2 = d.DEPT2_ID

group by e.EMPLOYEE_FIRSTNAME, e.EMPLOYEE_LASTNAME, c.CLOCK_NAME, t.PUNCH_TIME, d.DEPT2_DESCRIPTION

GO



This returns multiple entries because there are multiple unique entries for t.punch_time.

What i was thinking is i need a where statement on t.time_punch, d.dept2_description, c.clock_name
that says something along the lines of where return t.punch_time where t.punch_id=punch (**substitute correct column names**)

This is a sample of the tm_punch table


Code:



PUNCH_ID PUNCH_SEQNR PUNCH_EMPID PUNCH_DATE PUNCH_TIME PUNCH_MODIFIED PUNCH_PC PUNCH_CLOCKID PUNCH_DATA1 PUNCH_DATA2 PUNCH_DATA3 PROJECT_ID
141 0 52 2007-07-05 00:00:00 603 -1 0 0 0 0 0 NULL
142 0 52 2007-07-05 00:00:00 909 -1 0 0 0 0 0 NULL
143 0 52 2007-07-05 00:00:00 911 -1 0 0 0 0 0 NULL
144 0 52 2007-07-05 00:00:00 914 -1 0 0 0 0 0 NULL




If the query works correctly what should be returned is just the line with id 144

can anyone point out where i'm going wrong

View 3 Replies View Related

A, B And C Are The Same But At Least D Or E Are Different (was Noob Question)

Aug 23, 2006

hi,

just wanted to ask the most efficient way to query for the following:
say i have a table with the following columns A, B, C, D, E.
i want to find the records whose A, B and C are the same but at least D or E are different and then display all the columns (A to E) for these records.
thank you!

g11DB

View 8 Replies View Related

Total Sql Noob Help

Nov 19, 2007

Hi Everybody.

So as the subject states, I'm a total sql noob. I have a database in SQL 2k5 that was transfered over from an acces DB. In the sql db there are a few fields using nvarchar(255) but the data held is actually dates and times. I need to convert these over to datetime format but do no know how. Also, not all rows have a full mm/dd/yyyy hh:mm format. some hold only the date and can be seen as either m/d/yyyy or full out mm/dd/yyyy format. If anyone can help with this that would be great.

Thanks

View 2 Replies View Related

Noob Question

Dec 14, 2007

Hi

I installed sql sever 2005 enterprise edition in my computer.Where is the management studio? Is it a different program? Can I install the express edition of the management studio?Help please.

View 6 Replies View Related

Noob SQL Question

Mar 1, 2008

Ok so i have something like this for a simple quary,

select avg(reorderlevel)/ (avg(QOH)/(avg(reorderlevel)*2)) as "Needed qty",ItemCategory from item
group by ItemCategory



What I basicly need to do is to output the quantity needed for QOH to be 2 times the amount of reorderlevel. then grouped by diffrent catagories.

Anyways I have the formula done and it should work except for some reason "(avg(QOH)/(avg(reorderlevel)*2))" gives me 0 when in fact it should give me 0.728383 or w/e. Im wondering if its omiting the decimals or what??

Because if i run that code it tells me i cant divid by zero

Sorry im new at this and might be doing this all wrong so go easy on me =/

Thanks a lot

View 7 Replies View Related

Noob On Security But...

Apr 30, 2008

Apologies first up -I dont do security so slapped wrists all round, but I have a little situation that I need to take seriously so I thought I'd try do the job right for a change.
Scenario: I have a stored procedure that I want one, and only one, 'thing' to have access to. The 'thing' will be one and only one SSIS package invoked by external scheduling software so basically a call to the dtexec utility to run the package stored in the file system. At runtime therefore, this package has an ExecuteSQL task which connects to the server and runs the sproc. Given windows authentication how do I ensure that the ONLY user allowed to execute the stored procedure is whatever user happens to invoke the package but that this same user can never log in to sql server and execute the stored procedure. In even simpler terms, I want nothing on earth to run that stored procedure nor select the data from the table other than this package when it runs, regardless of who runs it, it is only internal processing by the package that gets the data.

View 1 Replies View Related

Total Noob Can't Get Db Connection......

May 9, 2007

My background is networking with a lot of SQL Server 6.5-2000 dba/sql code thrown in.  I've written some straight ASP pages, some Access DB frontends to SQL etc and I just can't get this .Net stuff.
 I'm trying to work my way thru the getting started vids here and can't get a db connection to the membership db.  I ran the aspnet_regsql.exe to create the db on my sql dev box, and it won't connect.  I've added the code from http://aspnet.4guysfromrolla.com/articles/120705-1.aspx to the web config. 
I erased the connection strings from the web config....I installed SQL 2005 express on my local machine and STILL CAN'T get anything other than can't connect to data store, data store doesn't exit, click here to crash....blah blah blah.
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. 
blah blah 
Test  the AspNetSqlProvider and get
Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
again.
I know the machine itself is fine.  It built the db on both the local machine and the remote sql server.  I can connect to the local and remote sql servers using sql management studio.
Can someone help a brother out?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved