Viewing 15 posts - 6,256 through 6,270 (of 7,164 total)
mister.magoo (6/3/2011)
@GSquared:It seems that (for me at least) it works as long as you remember that your final
SELECT *
FROM dbo.LockTest
is the part that is being blocked...
Works for me too. It's...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 3, 2011 at 9:53 am
Happy to assist, thanks for posting back!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 4:55 pm
Excellent! Thanks for posting back.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 4:44 pm
Based only on your description alone I am almost 100% sure you can do what is required without using a cursor.
I second what Ron said. Help us by providing DDL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 4:42 pm
Not sure how they're generated internally but they look random. It is a better practice to explicitly name all your keys, constraints, indexes, defaults, etc. instead of allowing the database...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 4:36 pm
Jan Van der Eecken (6/2/2011)
opc.three (6/2/2011)
LutzM (6/2/2011)
Also, I will start to participate on the site more often. It has always been useful and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 4:07 pm
Randy Doub (6/2/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 3:57 pm
Elliott Whitlow (6/2/2011)
opc.three (6/2/2011)
Elliott Whitlow (6/2/2011)
Actually that is pretty easy and opc.three is on the right track.CEWII
Gee, thanks CEWII :blush:
I had already started my response when I noticed you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 3:55 pm
Elliott Whitlow (6/2/2011)
Actually that is pretty easy and opc.three is on the right track.CEWII
Gee, thanks CEWII :blush:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 3:21 pm
XSLT might be a good option for you. It can do transformation work (the 'T' in XSLT) and can be easily integrated into an SSIS process using the XML Task...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 2:44 pm
LutzM (6/2/2011)
Also, I will start to participate on the site more often. It has always been useful and seems to be very helpful...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 2:28 pm
If I am understanding correctly you want to use a CTE containing the ROW_NUMBER() function where you PARTITION the data by name, order by your date column in descending order...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 1:41 pm
Randy Doub (6/2/2011)
...but I was hoping to not use xp_cmdshell.
+1 😀
I put a SQL Task in front of my Data Flow Task to check for data, but I can't figure...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 1:32 pm
Ever get to the bottom of it?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 1:25 pm
gordon.davis (6/2/2011)
I'm looking for is their any Best and Easy possible way of it.
I think you have all the bases covered but you'll have to be more specific about what...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 2, 2011 at 1:03 pm
Viewing 15 posts - 6,256 through 6,270 (of 7,164 total)