comment on

Yepp select 'foo' works like a charm. The failing table looks like this

USE [Market_Data_prod]
GO

/****** Object:  Table [dbo].[FXSpots]    Script Date: 11/20/2012 19:4
+6:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[FXSpots](
    [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    [LHSCurrencyID] [int] NOT NULL,
    [RHSCurrencyID] [int] NOT NULL,
    [TenorID] [int] NOT NULL,
    [BBTicker] [nvarchar](50) NOT NULL,
    [WMRic] [nvarchar](50) NULL,
    [CorrespondingSpotID] [int] NULL,
 CONSTRAINT [PK_FXSpots] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY
+ = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 9
+0) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[FXSpots]  WITH NOCHECK ADD  CONSTRAINT [FK_FXSpots_
+Currencies] FOREIGN KEY([LHSCurrencyID])
REFERENCES [dbo].[Currencies] ([ID])
GO

ALTER TABLE [dbo].[FXSpots] CHECK CONSTRAINT [FK_FXSpots_Currencies]
GO

ALTER TABLE [dbo].[FXSpots]  WITH CHECK ADD  CONSTRAINT [FK_FXSpots_Cu
+rrencies1] FOREIGN KEY([RHSCurrencyID])
REFERENCES [dbo].[Currencies] ([ID])
GO

ALTER TABLE [dbo].[FXSpots] CHECK CONSTRAINT [FK_FXSpots_Currencies1]
GO
[download]

and the working table looks like this:

USE [Market_Data_prod]
GO

/****** Object:  Table [dbo].[Indices]    Script Date: 11/20/2012 19:4
+8:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Indices](
    [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    [Description] [nvarchar](500) NOT NULL,
    [CurrencyID] [int] NOT NULL,
    [BBTicker] [nvarchar](50) NULL,
    [CRBTicker] [nvarchar](50) NULL,
    [ReutersRic] [nvarchar](50) NULL,
    [CloseTime] [datetime] NULL,
 CONSTRAINT [PK_EquityIndices] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY
+ = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 9
+0) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Indices]  WITH NOCHECK ADD  CONSTRAINT [FK_EquityIn
+dices_Currencies] FOREIGN KEY([CurrencyID])
REFERENCES [dbo].[Currencies] ([ID])
GO

ALTER TABLE [dbo].[Indices] CHECK CONSTRAINT [FK_EquityIndices_Currenc
+ies]
GO
[download]

In reply to Re^4: DBI don't fetch my data...or at least not all records by kurreburre
in thread DBI don't fetch my data...or at least not all records by Anonymous Monk

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


"be consistent"
	PerlMonks