This is he error I got

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'Schema'.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'Database'.

Msg...

Thank you for your replay but this give me an error

Thanks,

Oded Dror

Time and time again this is a gotcha questions to impress your boss during the interview.

Instead of asking how do you approach the new challenge we having or if you...

Andy,

What about deployment?

The report builder is for SharePoint basically

Thanks,

Oded Dror

In addition to that they called themselves Senior or consultant or even manager

How come you call yourself a senior developer and you don't basic staff

100% agree

Thanks,

Oded Dror

Hi there,

It still positive number

Thanks,

Ed Dror

T SQL code - I created stored proc and func

/* http://www.sqlservercentral.com/articles/SQLCLR/71942/ */

--linear_regression

USE Development

GO

CREATE TABLE dbo.test_table(

col1 FLOAT NOT NULL ,

col2...

Hi there,

I'm using SQL Server 2012 x64 and VS 2013

I follow your code and

The T SQL return -0.99988192786007

And CLR return 0.999766931939805 (positive number instead...

of course I try it will give you two record for Apple one with ReferenceNo SO 1111 and one with null

Look the code doesn't answer the null

What about

execute [dbo].[Shipment_Tracking] @CustID = 'Apple', @ReferenceNo = null

Will give all record regardless null

Thanks,

Oded Dror

Hi there,

How do you fix the null value?

Execute dbo.Shipment_Tracking @custID = null

This will give all records

Thanks,

Oded Dror

Thank you very much it works!

Hi there,

After copy and paste into notepad it still give me an syntax error

Can you type it inside sql and attach it as a script

no matter what I do it...

Peter,

You can do it with CTE like this

WITH x As (select row_number() over (partition by id1, id2 order by id2) nr FROM MyTab)

delete FROM x where nr > 1

Thanks,

Oded

In that sanerio, I'll put the Description into a seperate table with one to many relationship with the option to move into a second row or third.