There was one in Chicago last April, http://sqlsaturday.com/31/eventhome.aspx. I wasn't leaving FL for Chicago in April though.:-D

Have you heard of the PASS SQLRally? It may be something that your boss may be willing to do or help with.

Love to hear when people enjoyed a SQLSaturday. I've yet to be at one that I didn't have a great time at and I've attended 7 with 2 more...

What is the...

I suggest you read this post by Kalen Delaney. Based on it I'd say Alter Column is the way to go.

I've got to agree with Howard on this one. The code parses in SSMS without issue which means it is probably an error in the data.

Assuming that this is meant for me, you are welcome. If it isn't meant for...

If the data is stored as one of the date datatypes then you do not need...

I'm still not sure what you are asking? Yes you can call another sp from sp3.

What is the problem you are trying to solve?

Why do...

Sounds like you want something like this:

SELECT

*

FROM

table1 T1 JOIN

table2 T2

ON T1.mrn = T2.mrno AND

T1.DeliveryDate >= T2.AdmDate AND

T1.DeliveryDate <= T2.DischargeDate

Can DischargeDate ever be NULL?

I recommend reading this article[/url] by Andy Leonard about incremental loads using SSIS. You may not be using SSIS, but I think you can use the same pattern.

The article Ashish linked to gives a good explanation as to how the date format works. What you need to remember is that SQL Server does not store date...

I don't think you've given us enough information to intelligently answer your question.

Are you saying that you have 3 sps (sp_1, sp_2, sp_3) and sp_1 calls sp_2 which calls sp_3?...

I agree with Lowell on putting the Discounts in a separate table.

How are you importing the data from the spreadsheet?

Essentially what this is saying is that, for optimal performance, you could add data files of the same size to tempdb up to the # of processors on your server....