Viewing 15 posts - 4,921 through 4,935 (of 14,953 total)
Looks like homework. Or the first question on an interview tech screening.
Hint: Join the table to itself.
February 17, 2011 at 2:09 pm
LutzM (2/17/2011)
GSquared (2/17/2011)
...Yes, at camelsexchange.com. :w00t:
Must be a pain for the camel. (They still use bricks for it, right?) :pinch::crying:
Sledgehammers. Or dynamite if you're in a hurry.
February 17, 2011 at 2:07 pm
If you end up with a false positive on checksum in this case, saying a row has changed when it hasn't, that can be handled by a second step of...
February 17, 2011 at 2:05 pm
I'm going to second the motion on the recommendation to not put this in a trigger.
You'll want to have the initial logic in a stored procedure, or whatever other code...
February 17, 2011 at 2:00 pm
pietlinden (2/17/2011)
I'm a recovering Access...
February 17, 2011 at 1:56 pm
Brandie Tarvin (2/17/2011)
You people are strange.@=)
It's okay for me to talk to kids. I'm not a stranger. I'm the strangest!
February 17, 2011 at 1:00 pm
Alvin Ramard (2/17/2011)
They exchange camels too??
Yes, at camelsexchange.com. :w00t:
February 17, 2011 at 12:09 pm
IsNull doesn't work that way in SQL. You're using it like a binary function (which would make more sense, given the name), but what it really does is return...
February 17, 2011 at 12:07 pm
Craig Farrell (2/17/2011)
GSquared (2/17/2011)
Ken Jennings? I was more thinking along the lines of expertsexchange.com.Until you just mentioned it I don't think I ever quite caught that one... 😛
That's because...
February 17, 2011 at 12:02 pm
Alvin Ramard (2/17/2011)
What does all of this have to do with Integration Services?
Not a thing.
It's all about how to ignore that job prep is a superset of interview prep. ...
February 17, 2011 at 11:59 am
One of the best ways I know of to get used to optimizing SQL and stepping away from row-by-row is to stop looking at rows, and starting thinking about what...
February 17, 2011 at 11:57 am
MissTipps-320357 (2/17/2011)
'right(column_name,1) != 'X'
(not my query)
The problem I have is that...
February 17, 2011 at 11:46 am
Are you in a position to make sure tables in the source databases have RowVersion columns? (Called Timestamp in most SQL 2000 databases, but it's the same thing.)
That makes...
February 17, 2011 at 11:39 am
CirquedeSQLeil (2/17/2011)
Stefan Krzywicki (2/17/2011)
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc...
February 17, 2011 at 11:35 am
Randheer (2/17/2011)
What are criteria to define covering index and how we create it?
Please provide some details for this question.
For Sql...
February 17, 2011 at 11:32 am
Viewing 15 posts - 4,921 through 4,935 (of 14,953 total)