i think i overlooked one common rule, i will be back soon, but you can still check it tough.

Now you can just delete those employees.

Hi buddies,

With the following script you can find the employees that violates the marital status changes common sense rules.

;WITH CivilStatus (StatusSequenceNumber,[Marital_Status])

AS

(

SELECT 1,'SINGLE' UNION

SELECT 2,'MARRIED' UNION

SELECT 3,'DIVORCED' UNION

SELECT 3,'WIDOWED'

),

PersonCivilStatus

AS

(

SELECT...

I saw the article, is really cool, but i think our partner can't use FTS.

Are you able to use CLR?

Hi man,

This is just a guess.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.InteropServices;

using System.ComponentModel;

using System.Data.SqlTypes;

namespace ConvertToASCII

{

public static class ConvertStringToASCII

{

...

Hi,

I prepared the following steps of my solution, when i struggle to understand a query i break it down to the very fundation, then i add one thing at the...

I like it.

ooh you are rigth, i haven't seen it that way.

thanks man

Hey, what's up !

It looks like you can only add until 95851 months to a date of the year 2012, because DateTime datatype can only hold 9999 years.

thanks man.

Hi, what do you think about this one?

-- A tally table is needed.

CREATE TABLE Numbers (Number INT)

INSERT INTO numbers

SELECT TOP 1000 row_number() OVER (

ORDER BY column_id

)

FROM sys.columns;

-- Number the...

You are rigth, it produces table scan.

That is why said maybe haha, i will check it out.