My apologies this is not intended to be in this forum.

If the text is around 8000 characters than you can decalre the @stmt VARCHAR(8000)

AND use EXEC(@stmt) as well.

insert into Countries (CountryCode, CountryName)

 values (5, 'Cote D''Ivoire')

Should do it.

I do have write permission for the temp dir, I actually am testing with Admin Login with full access writes and all other formats work fine with the export -...

Thanks Steve, it worked for me with the setting on config file.

If you just want to use the

select substring('\\server\test\folder1\do1.doc',

charindex ('test\','\\server\test\folder1\do1.doc') + len('test1'),

charindex ('\do1','\\server\test\folder1\do1.doc')-(charindex ('test\','\\server\test\folder1\do1.doc')+len('test1')))

and

select substring('p:\test\folder10\doc20.doc',

charindex ('test\','p:\test\folder10\doc20.doc') + len('test\'),

charindex ('\doc20','p:\test\folder10\doc20.doc')-(charindex ('test\','p:\test\folder10\doc20.doc')+len('test\')))

Will also work if you just want to use the functions...

This also works,

CREATE  FUNCTION LastIndexOf

 (@strValue VARCHAR(4000),

 @strChar VARCHAR(50))

RETURNS INT

AS

BEGIN

DECLARE @index INT

SET @index = 0

WHILE  CHARINDEX(@strChar, @strValue) > 0

 BEGIN

  SET @index = @index + CASE WHEN CHARINDEX(@strChar, @strValue) > 1...

Please let me know if it works after you try it out.

Thanks

This could be something to do with the security issues , did you check accessing the reports on your PC from the second PC, if it does not work, give...

I think you can use the import feature of the SQL Server for migrating your data from your dbf files.

Thanks

You can create a view to hold the output of the two queries as

CREATE VIEW MYUNIONDATE AS

(SELECT     Name, MaxOfDateQC

  FROM         vw_vendor_current_mech

  UNION ALL

  SELECT     Name, MaxOfDateQC

  FROM         vw_vendor_current_elec)

If you are getting (0 row(s) affected) as your message then obviously your update statement is itself not satisfied, if you are getting (1 row(s) affected) but the values are...

The dates mentioned in the example are just for example and the period is dynamically picked and it as has the time concatenated to it.

It is always a best practice to have a backup policy on Production Servers, incase your log file is full and you want to shrink database.

First backup the transactional Log,...

I also had similar problem with the excel export and I found that when the number of characters in a cell of a matrix is more than 4110 characters this...