Please check more rows, probably there's no opening or/and closing bracket in one or few rows.

select Name

from tmp_id

WHERE CHARINDEX('[',Name) = 0 OR CHARINDEX(']',Name) =0

Regards

Mike

Hi,

Imho you can extract in such way.

select SUBSTRING(Name,CHARINDEX('[',Name)+1,CHARINDEX(']',Name)-(CHARINDEX('[',Name)+1)) as result

from tmp_id

Regards

Mike

Hi,

I did database migration from MySql to MS Sql 2005, but it was small db, so I simply

used MySQL ODBC Connector and set it as linked server in...

Forgive me for my previous link, I've alerady changed for us-en.

Hi,

Please read this link:

http://technet.microsoft.com/en-us/library/cc280478(v=sql.100).aspx

It's clearly explained there.

Br.

Mike

Hi,

Imho you can do that in this way.

create table dbo.Entity (EntityId int, EntityTypeId smallint, Description varchar(25), ParentEntityId int);

insert into Entity

select 101,1,'UK',NULL

union all

select 102,1,'USA',NULL

union all

select 103,2,'SouthEast',101

union all

select 104,2,'SouthWest',101

union all

select 105,3,'Manager1',103

union all

select...

Hi

I simply use 7-zip for that:

Configure Execute Process Task with settings

Executable: C:\Program Files\7-Zip\7zG.exe

Arguments: -wc:\TEMP e \\SERVER\share\myfile.tgz

WorkingDirectory: \\SERVER\share

Ofc you need to run package on user account with proper permissions to...

Hi Jend

You gave too less details to allow judging what you are looking for but

imho you can do that like this:

;WITH ItemSrch AS (

SELECT Prev_Item_Code, Next_Item_Code

FROM YourTable

UNION ALL

SELECT...

Hi Dj

Please research article here

http://www.pythian.com/blog/sql-server-understanding-and-controlling-connection/

Regards

Mike

Hi

If remote table is a table on a database server other than the current server. The general syntax for accessing a table on another informix server is: database@server:[owner.]table, so...

Hi Arkiboys

Server Reporting Services treat page headers and footers differently then pdf browser, to avoid that try to add some white spaces from the top edge in SSRS.

Br.

Mike

Hi Jarrell

I migrated from Informix to MS SQL a few years ago and at the beginning I had similar dilemma.

I simply started using"

SELECT col1,col2

INTO #tmp_tbl

FROM some_table;

instead of...

Hi Harman

I've built quite similar solution to extract invoices for printing work. The main goal for me was to create stored procedure which casts

all parts (header, item details, subtotals,...

hi

Imho the [Rep_Accuracy_Achievement_Analysis_Report] returns different number of columns.

Br.

Mike

Hi Peacesells

To avoid network problems SSIS extracts data to flat files on first server and put on sftp, then next server transfer and

load to DB. Imho it's not the fastest...