Do you need to count the start date or the end date or both? I'm not entirely sure what you mean by the second part, can you provide sample...

Absolutly amazing article, thanks for the contribution!

Awesome demonstration... I was almost ready write out the case statements for this?

Regards - Brad

This is an interesting issue, because traditionally the earliest date for an MSSQL datetime value is 1/1/1753 due to the julian to gregorian calendar switch; however, seeing as you are...

I'm not 100% sure, but I believe that it's still just refered to as a join, the syntax of the statement is a little different that what would be considered...

I have not heard of modifying the Active Directory by using the LDAP connection from SQL Server, I do not think it's possible when using LDAP to issue update commands;...

I like to ask about turnover rate to see whether there is a body desk mentality or whether there is an emphasis placed on retained knowledge.... Just a thought.

Select * from USER_PGM_AUTHORITY where ACCESS is null and Program = 'INV_OPT'

If you can post the table and some sample data I can answer your question more specifically.

Hey,

Here is an excellent example of how to split strings using static pivoting, I pulled it from here.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/381e4164-f1e0-4b54-828f-2795d2cdcb3e

Thanks,

Brad

CREATE TABLE Foo (

keycol INT PRIMARY KEY,

delimited_str VARCHAR(500));

INSERT INTO Foo...

Can you post the code you have for creating the three tables along with a basic description of what the program does? I think that would help us understand the...

I will!

I don't have much experience with C#, So I borrowed a friends book on beginning C# programming. From my understanding it is very similar to Java so there shouldn't...

I really appreciate the response, I went ahead and ordered the book. The reviews say the book is absolutely amazing and I cannot wait to read it.

Thanks!

-Brad

Wow... That's impressive, Has a trend started towards outsource to even more remote area's yet? There was a similar trend in mexico with the manufacturing base during the late 90's......

Hah, Agreed, Though I assume you could live like king henry off of 12,000 USD monthly in india.

I don't know if this will help much or not; however, I'll give it a shot.

I would go under SSMS, open the relevant database. Expand the tables, Expand the specific...