Viewing 15 posts - 6,256 through 6,270 (of 7,168 total)
PS I think it's odd that you can get away with this in SQL Server. I had a similar initial thought to what GSquared posted...a visceral "NO" to the premise...
June 3, 2011 at 10:17 am
lanky_doodle (6/3/2011)
Does this look sound?
That's the query structure I was thinking would work for you. You are using clock number, not name, which is a proper column to partition on...
June 3, 2011 at 10:01 am
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...
June 3, 2011 at 9:53 am
Happy to assist, thanks for posting back!
June 2, 2011 at 4:55 pm
Excellent! Thanks for posting back.
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...
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...
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...
June 2, 2011 at 4:07 pm
Randy Doub (6/2/2011)
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...
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:
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...
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...
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...
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...
June 2, 2011 at 1:32 pm
Viewing 15 posts - 6,256 through 6,270 (of 7,168 total)