Apologies for all the questions!

How about this syntax?

SELECT @s-2 = (CONVERT (NVARCHAR (50), DateDiff(minute, CONVERT (CHAR (24), [PI9_StartDT], 108), CONVERT (CHAR (24), [PI9_EndDT], 108)) / 60)) + '...

That helped, thanks.

One more problem.

I want to call a stored proc from within another stored proc. Here is my code:

ELECT @OUT = EXEC [MUJV].[FailPassPI9]

GarrisonName,

(CONVERT (NVARCHAR (50),...

There are no null values.

BackupAssist is a backup software I am using. I thought that maybe a cause for the problem?

I will check the event logs ASAP. I am backing up to USB drive...

Hi,

How do I use that query?

To the last poster - I haven't inherited a database, I just have too many tables that it will take too long to join up...

All tables have the same key structure.

I am talking about foreign keys into the parent table.

Wouldn't both fields in the intersecting table be PKs?

Ok but what I am confused about is that the Employee table has a PK, so that will link to the intersecting table. The intersecting table have the PK of...

I have also passed 70-630, which is the Sharepoint 2007 Configuration Exam and I'm taking 70-562 (ASP.NET) very soon, both MCTS.

I guess I will have to decide on the path...

Hi,

The way I got this to work is to keep trying the installer. So work around the problem, really. I was advised by someone else in another thread I made...

RBarryYoung (6/14/2009)

---

info (6/14/2009)

---

First poster - thanks!

To the last poster - XXX denotes a specific part of a car. So I have one table containing reviews for all parts with a...

First poster - thanks!

To the last poster - XXX denotes a specific part of a car. So I have one table containing reviews for all parts with a table design...

Yeah C# does have certain ways to distinguish between output parameters and non-output parameters.

I now get these errors:

Msg 102, Level 15, State 1, Procedure GetDiscount1, Line 4

Incorrect syntax near '@ret'.

Msg...

I found an article which said the following:

Manager ---> Player

You will link the manager table to the player table because the player table will only need 1 manager for each...

Seth Delconte (10/14/2008)

---

This may start you off in the right direction for the first part of your question:

create proc uspGetAdmins @User varchar(40), @IsAdmin varchar(1) OUTPUT

as

set @IsAdmin = (

select IsAdministrator

from tbl1...