Viewing 15 posts - 196 through 210 (of 621 total)
mrpolecat (7/6/2010)
I need to extract any 2 of each type into a second table for sampling.
mrpolecat, it may not be an issue in this case, but for a truly randomized...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 7, 2010 at 1:53 pm
asifchouhan08 (7/6/2010)
yes Ignition =1 means turn on and ignition 0 means turn off with respective modified date time
Asif, I am going off of these rules, and thought I would offer...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 7, 2010 at 1:17 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 6, 2010 at 9:26 am
Thanks Steve. Nothing but tables for this database.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 21, 2010 at 1:03 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 7, 2010 at 9:13 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 2, 2010 at 1:12 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 2, 2010 at 12:50 pm
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 26, 2010 at 2:16 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 3, 2010 at 2:29 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 3, 2010 at 2:06 pm
Thank you Ramesh, that solved my problem.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 2, 2010 at 8:09 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 24, 2010 at 3:26 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 22, 2010 at 12:57 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 22, 2010 at 12:30 pm
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....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 22, 2010 at 11:26 am
Viewing 15 posts - 196 through 210 (of 621 total)