Viewing 15 posts - 16 through 30 (of 30 total)
Thanks a lot R.P.Rozema...! your query snippet helped a lot to fix the issue.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
June 10, 2015 at 5:27 pm
Thanks for your reply,
we didn't get any specific exception that's why I'm not able to share. while opening it throwing the not able to open the excel.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
May 13, 2015 at 2:20 pm
Client not able to open the download excel sheet, out assumption it's not downloaded properly. Problem we not able replicate in our environment. It happening in their client environmentetwork.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
May 13, 2015 at 10:02 am
I'm using VS 2008 BIDS.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 1, 2014 at 12:23 pm
Thanks Guys for your guidance...
I have overcomes this problem using XQuery functionality.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
July 30, 2014 at 11:47 am
Yeah.. I tried that too.. but getting the same exception
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
July 24, 2014 at 2:14 pm
Yes Evil, 0x+@Column. Currently File is extract with the following data "3C436C696E6963" after DT_Text conversion but it has be prefixed with Hex String 0x3C436C696E6963
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
July 24, 2014 at 11:56 am
Hi Evil,
Thanks for your reply, when i prepend 0x in script it's working. But when i tried the same in SSIS using derived column I'm getting exception(i have attached the...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
July 24, 2014 at 9:34 am
Hi Kendal Van Dyke,
"How To Get Table Row Counts Quickly And Painlessly" really helpful and crisp snippet to find the rowcount of the table, my doubt while we are...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
November 16, 2009 at 4:52 am
I Found the solution
declare @STR varchar(1000)
set @STR = 'aSample_1_scrShot_2009-01-02_09-15-51.png^aSample_2_scrShot_2009-01-12_09-00-07.png^ASAMPLE_3_scrShot - _2009-01-23_10-51-19.png^ASAMPLE_4_scrShot_2008-12-31_17-58-17.png^ASAMPLE_5_scrShot_2009-01-02_09-15-06.png^ASAMPLE_6_scrShot - _2009-03-05_09-56-31.png^ASAMPLE_7_scrSht-_2009-04-10_10-37-53.png^'
select REPLACE(@str, 'ASAMPLE_5_scrShot_2009-01-02_09-15-06.png^', '')
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
October 12, 2009 at 6:09 am
Thanks Grant Fritchey & kruti, i Got the solution from your guidance
once again thanks
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
September 1, 2009 at 10:14 pm
Hey Lowell & Matt u both rocks,
thanks for your guidance
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
July 26, 2009 at 10:35 pm
hi Matt,
thanks for your kind reply,
when i created that function, and executed it like this,
CREATE FUNCTION dbo.testFunction
(@STARTDATE datetime,@EntDt datetime)
RETURNS TABLE
AS
RETURN
with DateList as
(
select cast(@STARTDATE as...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
July 26, 2009 at 9:54 pm
IF object_id('tempdb..#tmpTBL') is not null
DROP TABLE #tmpTBL;
select distinct * into #tmpTBL from exampletable
truncate table exampletable
insert exampletable select * from #tmpTBL ORDER BY Name
drop table #tmpTBL
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
January 7, 2009 at 4:14 am
How to send e-mail without using SQL Mail in SQL Server
Sending SMTP Mail using a Stored Procedure
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
January 7, 2009 at 2:40 am
Viewing 15 posts - 16 through 30 (of 30 total)