Thanks guys - I was always testing that the date was valid first, but I've lost the will to live on this one (lol), so created another sproc and my...

Thanks guys - I already validate before passing the string.  I also added SET DATEFORMAT DMY.
The value, once validated, is passed to the DefaultValule of a SelectParameter in a GridView...

I tried CAST and CONVERT but it's still throwing up errors.  I need to learn more about spExecute but don't have time just now, so I'm just calling 2 separate...

Thanks all - I followed the link from Jeff and created the following stored procedure which I think is almost there, but I'm mow getting an error:

Conversion failed...

Thank you John and Chris.  I pasted the code from Chris (as that looked simpler) into a VIEW, but it doesn't work, do I need to declare X??  Sorry, not...

Yes lol!  I'm sure I tried this before and got an error but the error must have been from somewhere else in my syntax.  Working perfectly, thank you 🙂

Hi Thanks - I think 'Output' was perhaps the wrong term.  Yes there will be multiple rows which I will be using to populate a GridView (.net WebForms), so I...

Thanks - that is an interesting link. I have resolved my problem with simply typing in MY-PC-NAME\SQLEXPRESS in the connection dialog instead of expecting it to be in the...

Thanks - I tried it again with the 2 Drivers tables and it worked 🙂

Thanks Gift Peddie - I've read the link and the stuff looks really interesting but when I open SQL Server Management Stuidio it asks me to connect to a server...

Thanks but don't know anything about the wizard so probably not! Should I uninstall then reinstall Management Studio or will that just give me more problems??

Thanks - I have checked and the service is Started and is set as automatic. However, I still cannot connect to my local server. I am logged on...

Just wanted to thank all you guys for your input (on the output :hehe:). No seriously this has been really interesting to me and I have learnt loads. ...

Thanks - you have all been really helpful and I have learnt some about OUTPUT into the bargain. I see the benefits of using OUTPUT in certain scenarios, however, to...

Checked and I definitely have the first field (CustomerId set as an identity column). I don't actually need the CustomerId in the application, I just need it passed to...