Already told him that... maybe he'll pick it up this time...

But I feel I must warn him that since you're changing the query... you'll be getting different results from now...

Yup but this can be interpreted is any women is better at multitasking that man.

But just now, while I'm typing this, I'm listening the news on tv, music on the...

I don't think you can do it that way.

I think I would create a function with the parameters index and number and the function would return true of false depending...

Maybe...not sure anymore.

Looks who making sexist comments now...

SELECT User_ID, Position_ID, Company_Name, Position_Title, Start_Date, Convert(DateTime,End_Date) as End_Date

FROM dbo.MySurvey_Positions

WHERE User_ID = @user-id

Don't have much time to deeply analyze this but if you want to report something based on a date or time period, you need a date column somewhere. While...

It probabely means that there's no period in the field... maybe you could check it out with this query :

Select * from dbo.YourTable where charindex('.', YourField, 1) = 0

To...

I think I saw a solution with no default value on the parameter that had the same results. Can you check this out and report back?

The idea behind this...

Never tried, but most likely fail with error. What normally happens is that the field is calculated on the fly when you query it. But in this case,...

There was another option, set the parameter to a local variable and use that variable in the query... Should save you sum grief and won't need recompiles.

No we can't, tell us pleaaaaaaaaaaaaaaaaaase.

Seriously, good week-end .

Again, this is a task that the APPLICATION should be doing, the server can do it but its work is to fetch data and send the results as fast as...

You can read both the article and the discussion, the information is extremely relevent in both cases.

Real world query plans

Was in your head... maybe we should document it .