Viewing 15 posts - 3,121 through 3,135 (of 7,631 total)
Padam Kumar Tripathi (3/31/2009)
01008,03072,0045,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,-1701008,03072,0046,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,311
01008,03072,0048,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,12336
01008,03072,0049,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,986
01008,03072,0056,C,,,,,,,-1057
01008,03072,0057,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,5320
01008,03072,0069,C,,,,,,,-4109
01008,03072,0071,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,2180
01008,03072,0078,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1
Like this:
Replace(Replace(Replace(Replace(strCol, ',,,,,,,', ','), ',,,,,', ','), ',,,', ','), ',,', ',')
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:42 pm
Jeff Moden (3/31/2009)
... does anyone know what "sleep" means? :hehe:
Oh, definitely a bad idea. I discovered that if you let it become a habit then the hallucinations start to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:34 pm
Bruce W Cassidy (3/29/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 7:53 pm
OK, in that case I would recommend two things: first when there are multiple values for the same potential ordering key, they should be combined. And secondly, when you...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 1:50 pm
Yes, that is OK.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 1:07 pm
torpkev (3/31/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 12:40 pm
Santiago E. Perez (3/31/2009)
order by
Case when @SortBy = 'roadway' then roadtobeclosed_Name End,
CAse...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 12:38 pm
What you need to watch out for here are DB settings like TRUSTWORTHY and CROSS-CHAINING. These will allow (to some extenet) the database principals (users & schemas) to assume...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:47 am
ExcelMonkey (3/31/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:36 am
Hmm, there should be more to that error message.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:30 am
Have you disabled macros or javascript?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:22 am
Looks good to me. I am using Firefox 3.0.8.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 11:21 am
Second thoughts: I am not sure if the XL automation technique can extract the macros or not. I've never tried that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 10:40 am
If you can get the uncompressed XML format of the Excel file, then you can import and shred that.
Alternatively, you can use Excel automation outside of SQL Server to open...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 10:29 am
Derek Dongray (3/31/2009)
RBarryYoung (3/30/2009)
[ code ] for SQL,
[ code="csharp" ] for C#
[ code="vb" ] for VB.net
[ code="xml" ] for XML
bit i still have...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 31, 2009 at 7:41 am
Viewing 15 posts - 3,121 through 3,135 (of 7,631 total)