klineandking (5/24/2010)

---

i created this SCALAR function

CREATE FUNCTION [dbo].[ufnNickTblPersonOrganizationSuperTypeID](@PersonOrganizationSuperTypeName VARCHAR(10))

RETURNS int

AS

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

-- History of changes:

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

BEGIN

declare @PersonOrganizationSuperTypeID int

Select

@PersonOrganizationSuperTypeID = PersonOrganizationSuperTypeID

from NickTblPersonOrganizationSuperType(NOLOCK)

Where PersonOrganizationSuperTypeName = @PersonOrganizationSuperTypeName

RETURN @PersonOrganizationSuperTypeID

END

and then i tried...

Agreed, but I have to abide by my supervisors directives. Just means trying to do more in the evenings as this how and where I hone my skills and...

Politics

Also, sswug.org is holding a FREE vconference on May 28th on SharePoint. Some of it may be worthwhile. Not sure about the 2 sessions on exposing LOB data...

Great. I'd hate to see things get this far and then just die on the vine.

Looks like I'll have to do more on the evenings and weekends. Can't...

Okay, looks a little dead here. We have a SharePoint site, now what is our next step?

Please take the time to read AND follow the instructions provided in the first article I reference below in my signature block regarding asking for help.

Based solely on your original...

I may have figured this one out, but i still have a few issues to try and iron out. One of them is a small problem, the first query...

If the dates are stored consistently, check out the following. Realize that you won't be able to use any indexes on the Date column on the table because of...

A Little Help Please (5/17/2010)

---

First, why is a date being stored in a varchar912) column instead of a datetime column? Second, you show how the date is displayed, but...

A Little Help Please (5/17/2010)

---

I have a simple SP delete:

DELETE

FROM NETHistory

The table NETHistory contains a Column called "Date", the column is a "Varchar(12)".

The Date is displayed as "May...

Grant Fritchey (5/17/2010)

---

GilaMonster (5/14/2010)

---

Apparently he's actually a very nice...

There is another way using T-SQL to concatentate values that needs to be used in versions prior to SQL Server 2005, problem is that it does not scale as well...

Steve, You have permission to grab my email address also.

Michael Valentine Jones (5/10/2010)

---

Lynn Pettis (5/10/2010)

...Who else is going to listen to the problems we have encountered and how we solved them, or what accomplishments we may have achieved at...