Viewing 15 posts - 61 through 75 (of 112 total)
My Dah! So simple... Thanks!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 16, 2012 at 2:46 pm
Thanks Jeff! Briefly looked it over and looks like it has many nuggets of golden information to extract!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 14, 2012 at 5:42 pm
Thanks for your reply CEWII
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 14, 2012 at 9:45 am
Thanks SSCrazy. Was pretty sure of that but down to a few volts in the powerhouse at the moment 🙂
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 13, 2012 at 7:09 pm
Found this article/post that looks pretty close to my required needs.
http://www.sqlservercentral.com/articles/powershell/73460/
Anyone with others great links or comment on person experience please reply. Thanks!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 10, 2012 at 8:25 pm
Great stuff. Thanks very much!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 6, 2012 at 9:14 am
I happened alone the below function that gets the job done. Your article referral looks to be a great resource too. Thanks!
Function fnFormatDate(dtDate, strFormat)
Dim yyyy, mm, dd
mm = Month(dtDate)
yyyy=Year(dtDate)
dd=Day(dtDate)
If (Len(dd)<2)...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 3, 2012 at 9:42 am
Thank you so much! 🙂
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 2, 2012 at 2:27 pm
Really no reply? I am getting the same error message. If you got this figured out how does it work?
Thanks
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 1, 2012 at 10:23 am
Thank you for all the great responses. The thread took on a life of its own which is cool 🙂
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
January 19, 2012 at 2:44 pm
SQL Prompt is pretty nifty 🙂
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
January 13, 2012 at 2:20 pm
Your right no business logic documented. I have been tasked with doing that.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
January 13, 2012 at 2:05 pm
Thank bunches. It is code used within our application I support. It is pretty ugly no doubt but really cool how you broke it down. It boggled my mind. Thanks!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
January 13, 2012 at 1:49 pm
That is the ticket Elliot! Thanks so much!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
December 6, 2011 at 1:59 pm
I appreciate all you responses. Thanks
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
August 19, 2011 at 8:29 pm
Viewing 15 posts - 61 through 75 (of 112 total)