Viewing 15 posts - 46 through 60 (of 112 total)
Thanks very much. Rather then continuing to go in circles I turned to C# to get this to work. However, now that I have something to chew on I will...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 22, 2012 at 3:46 pm
Thanks Eugene, that solution worked great with the update I needed to make:
Here is what ultimately did the trick...
select ID, GroupNumber
into #LogFileTracker
from dbo.logfiletracker
where groupnumber = 4441
and statusbit is null
;with cte
as
(
...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 12, 2012 at 3:47 pm
This appears to work for my purposes:
DECLARE @count int
BEGIN
SET @count = (select count(groupnumber) from dbo.tbl4441 where groupnumber = 4441 and statusbit is null)
WHILE @count <> 0
BEGIN
UPDATE t
SET t.GroupNumber= 4441, statusbit...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 11, 2012 at 8:20 pm
Thank for the suggestion. Found something that looks promising:
UPDATE t
SET t.GroupNumber= 4445, statusbit = 1
FROM
(SELECT ROW_NUMBER() OVER (ORDER BY groupnumber) AS Seq,*
From dbo.tbl4441)t
WHERE t.Seq IN (1)
and t.statusbit is null
Note there...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 11, 2012 at 7:32 pm
Thank you very much opc.three. It does help a great deal!
opc.three (3/8/2012)
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 8, 2012 at 8:56 pm
The nested Replace statements worked great! Thanks Phil and Shawn!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 29, 2012 at 10:17 am
Thanks Koen. I will check with the Admin to see if I am in the Distributed COM Users group.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 27, 2012 at 12:06 pm
Thanks for the reply. Unfortunately the package was run manually outside a job. Thre is no logging in the package and no auditing configured on the server. It was also...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 20, 2012 at 4:56 pm
I might add that this was a manual run of the package. Not scheduled through Jobs nor is there any configured logging in the package itself.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 20, 2012 at 2:39 pm
This tool you reference looks very promising :). I haven't yet tried to install it but if it works then no more messy external PowerShell files to deal with. At...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 19, 2012 at 8:51 pm
Great advise! Again thanks so much!
opc.three (2/18/2012)
TeraByteMe (2/18/2012)
Sorry about the name confusion :-S. I must say that both the solutions (PowerShell & T-SQL) are very elegantly done.
You are correct...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 18, 2012 at 6:37 pm
Sorry about the name confusion :-S. I must say that both the solutions (PowerShell & T-SQL) are very elegantly done.
I do like PowerShell because it is so integrated with...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 18, 2012 at 5:53 pm
You guys appear to have a great grasp on working with Regular Expressions and PowerShell. Any resources (books, articles, etc...) that you can recommend?
BTW, SSCrazy that was cool how you...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 17, 2012 at 4:41 pm
Thank you both so much for your help!
SSCrazy, that script is guenius. I will learn a lot from that script. Life saver!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 17, 2012 at 2:27 pm
Good FYI and thanks! That will most definitely help me in the future.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 16, 2012 at 6:26 pm
Viewing 15 posts - 46 through 60 (of 112 total)