Viewing 15 posts - 31 through 45 (of 48 total)
mahesh.dasoni (10/11/2012)
EXEC MSDB.DBO.SP_SEND_DBMAIL
@PROFILE_NAME = @MPOFILENAME, ...
October 11, 2012 at 4:40 am
Chrissy321 (10/10/2012)
http://msdn.microsoft.com/en-us/library/ms186238.aspx%5B/quote%5D
Sadly, this didn't work for me.
October 11, 2012 at 2:30 am
mahesh.dasoni (10/11/2012)
EXEC MSDB.DBO.SP_SEND_DBMAIL
@PROFILE_NAME = @MPOFILENAME, ...
October 11, 2012 at 2:18 am
Bhuvnesh (10/10/2012)
is it started happeinig at sudden ?and
are you using same location for CSV file by both the job and manual process? because there could be space issue :unsure:
I've...
October 11, 2012 at 2:17 am
Thanks, I'll give it a go tomorrow.
October 10, 2012 at 2:02 pm
durai nagarajan (10/10/2012)
can you provide the below details.are using excel to open the csv file?
what is the sql server and office version?
approximate no of rows for 2 or 3 days
I...
October 10, 2012 at 8:22 am
Cadavre (9/19/2012)
sqlrd22 (9/19/2012)
That worked great, thank you. I'm slowly learning..
Glad it worked. Check this link for other formatting options for datetimes. Bear in mind that this is generally slower than...
September 19, 2012 at 4:44 am
Cadavre (9/19/2012)
I guess the easiest thing to do would be to change your query to this: -
SELECT *FROM [dbo].[DATAFLOW_CLOB]
WHERE RAW_CLOB LIKE 'AAA|E0221002|_|'+CONVERT(VARCHAR(8),GETDATE(),112)+'%ecp%';
You should look into string splitting, as well.
That...
September 19, 2012 at 4:20 am
Cadavre (9/19/2012)
I guess the easiest thing to do would be to change your query to this: -
SELECT *FROM [dbo].[DATAFLOW_CLOB]
WHERE RAW_CLOB LIKE 'AAA|E0221002|_|'+CONVERT(VARCHAR(8),GETDATE(),112)+'%ecp%';
You should look into string splitting, as well.
Thanks...
September 19, 2012 at 4:08 am
Jayanth_Kurup (9/19/2012)
your looking for something like this , additional details available in BOL
edit :- sorry didnt read the question properly...
September 19, 2012 at 4:07 am
mbhandari (9/18/2012)
- Double click the job you created
- Click Steps and list...
September 19, 2012 at 3:25 am
Thanks for the suggestions everyone, I'll be trying out the methods you've mentioned today and I'll let you know how I get on.
🙂
September 19, 2012 at 2:03 am
Sean Lange (9/17/2012)
sqlrd22 (9/17/2012)
September 18, 2012 at 2:15 am
I have sent you the real data in a private message as I do not wish to post it on here. It should work from that, thanks.
September 4, 2012 at 4:47 am
Viewing 15 posts - 31 through 45 (of 48 total)