Why don't you just try it?

It would probably take less time than writing the post.

Of course you can do it.

Just don't use cursors inside...

WHERE (age = @age OR @age IS NULL)

When you test the script declare variables to relace SP parameters.

Don't replace it with hardcoded values within query..

If you have such task then you store same entity in different tables.

Read about normalization rules, think about what do they mean and why people created it, and fix DB...

I can guarantee one day they will ask you to store bar code for each item.

Do you plan to leave before that day?

And lets do a little bit of...

Read "CAST and CONVERT" in BOL.

Must be something like this:

select o.*

from z_inquiry o

INNER JOIN (

select max(inquirydatetime) as maxinq_dt, frontend_id

from z_inquiry

group by frontend_id...

People talking not about acounts conecting to SQL Server, but about the account started SQL Server

I understand, they don't want newbie to affect their production system.

So, instead of letting him to create SP which could be checked by a professional, tested properly and provide required...

> I am going to stick with the "lazy way."

"lazy way" is slightly modified my query. Just another GROUP BY added.

No value added, this just slows query down and...

I don't see any use of LEFT or SUBSTRING function in this example.

So, it's not relevant.

Don't think it will work because of GROUPING keyword.

You welcome.

Next time try to read "Cast and Convert" topic in BOL by yourself.

REPLACE(CONVERT(varchar(10), @Datetime, 1), '/', '') +

REPLACE(CONVERT(varchar(10), @Datetime, 8), ':', '')

I wanna see a requirement to monitor car engine temperature without putting a sensor in it.

Why IT projects are ruled by such idiots?