Newbi (1/8/2017)

ALTER PROCEDURE [dbo].[uspInvoiceLines]

(

--@InInvoiceNbr int

@InLinesPerPageint

)

AS

DECLARE @TotalRows int

DECLARE @Remainder int

DECLARE @NumPages int

DECLARE @NextPageRows int

set @TotalRows= 0

SELECT

ROW_NUMBER() OVER( ORDER BY InvProduct)as InvoiceRow,

CoID,

InvNo,

InvProduct,

InvDesc,

InvQuantity,

InvUOM,

...

Matthew Darwin (1/4/2017)

I think some of the...

You may struggle to get a proper answer from anyone here as SSC is a SQL Server Community, meaning many people may not have (much) knowledge of many RDBMSs other...

I only have VS 2015 installed at home, so if this doesn't work let me know and I'll check when I get to the office tomorrow (I have VS2010 there).

Tools->Options...->Text...

If your aim is to continue from a "checkpoint" after a failure, I would suggest 1 of two ideas.

1. Log what you have processed thus far, then, when the process...

Ok, so I spent a little time and attempted to turn the OP's sample data into something "usable", which gave me this (which doesn't work):

USE TESTDB;

GO

INSERT INTO VehicleAnalysis_Header

VALUES('2563','CC','P',NULL,'FS','TE WANANGA O...

That sample text file really isn't, for lack of a better words, digestible. Looking at your DDL you've got 4 tables, but have combined your Sample data into one table.

You...

The error clearly implies that a string in the report, somewhere, it trying to be set to 14px, which is an invalid font size (as it should read 14pt).

When are...

I wanted to mention that this table structure doesn't follow 1st normal form?

If this is a database of your own design, I would suggest updating your tables to do so....

I wasn't brave enough to open that file on a Windows PCm, however, on my Linux PC was a different story (Gotta love the lack of malware out there, and...

Phil Parkin (1/6/2017)

WHERE ct > 10

I suspect the...

I'm assuming that the query you provided is not your query which isn't running, as that's fine.

I don't think that using a variable is really the answer you need. Are...

Sounds like the same issue in the topic here: http://www.sqlservercentral.com/Forums/Topic1847487-3740-1.aspx

There's a link to the drivers the link.

That's the missing piece of information we needed 🙂

Does this work for you?

Update DP

SET DP.ProjectNumber = DP2.ApplicationNumber

FROM dbo.tblDataPermit DP

JOIN dbo.tblDataPermit DP2 ON DP.RefNo = DP2.RefNo

WHERE...

Your image shows that these are two different rows. We're missing a piece of logic here that connects the two. Your statement above will update a column with the value...