mrpolecat, it may not be an issue in this case, but for a truly randomized...

Asif, I am going off of these rules, and thought I would offer...

Asif, we kind of need some rules here. For example, is the first instance of Ignition=1 meant to signify the engine was turned on at this time? And...

Thanks Steve. Nothing but tables for this database.

Thanks Jeff, I knew I should have looked there first. It looks like that will do, but only when the value to the right of the decimal is exactly...

What I am looking for is a way to capture non-conformances based on Employee Name. However, the field that the name goes into is a text field (and has...

newmang, I don't see anywhere you are telling the query which years to pull. Is there a collumn for year? If so, you might want to add 'AND...

Greetings. I'm not sure what you mean by 'messy', as it is kind of subjective. If you are talking about what your code looks like to the eye,...

You can't link Excel to a stored procedure, so no parameters are allowed coming from SQL Server. However, you can use VB in Excel to build your query based...

I don't think I've ever experienced that problem Seth. I usually save Excel files as text files then use bulk insert. That is cumbersome though, when I only...

Thank you Ramesh, that solved my problem.

Thanks for the tip, and that will take me some time to understand. In the mean time, I successfully convinced the user that it will be sufficient for me...

Yep, after reading more about it, I realize now why it is not for users, as it could be dangerous. My problem is that there is a need to...

That's pretty scary. I'm thinking an IF statement looking for key words like 'SET','UPDATE','DROP','ALTER', etc might work to thwart that kind of attemp. But if the user does...

Matt, thanks for the reminder. I work in a fairly safe environment, so I don't always consider that as a threat. However, I don't want to be complacent....