Hi,

i cant test your statement if it's right.

But maybe i can help you to write the sql a little bit shorter and clearer.

You can join the sum's you needet within...

Hi Matt,

this can be done, using the Pivot syntax within SQL Select.

Examples found at BOL

Thank you for your reply's.

I tested some more with your informations. I think

SELECT 'THIS WORK'

, CONVERT(timestamp,2147483647)

, CONVERT(Bigint,CONVERT(timestamp,2147483647))

, 2147483647

UNION

SELECT 'DON''T WORK'

, CONVERT(timestamp,2147483648)

, CONVERT(Bigint,CONVERT(timestamp,2147483648))

, 2147483648

UNION

SELECT...

Hi,

to filter your result you can replace

[Posting Date].[Year - Month].ALLMEMBERS

by

DESCENDANTS( [Posting Date].[Year - Month].[<VALUE>])

Wole

Hi,

I guess there are two things you can try.

First: Put a index on Table #tempTitleDistinct.Title_Refrnc_Nbr

Second: in your last query at

-- ValidRequestOnQueueFlag

...

you can create the SQL statement as following

DECLARE @sql VARCHAR(MAX)

SET @sql = ''

SELECT @sql = @sql +'SELECT * FROM [' + name...

except the queryplans, in case of outer joins, there can be different results.

Try this

DECLARE @TestData1 TABLE (

vKey int,

vValue varchar(20)

)

DECLARE @TestData2 TABLE (

vKey int,

vValue varchar(20)

)

INSERT INTO @TestData1 VALUES (1,'VALUE 1')

INSERT INTO...

you can try to improve your where clauses by removing the function's.

There is a article at http://www.sqlservercentral.com/articles/T-SQL+Optimization/61809/[/url].

w.lengenfelder

Hi,

To get/update non matching records you can use following

update table_a

set row = b.xxx

FROM table_a left outer join table_a as b

on table_a.xxx = b.xxx

where b.xxx is null

W.Lengenfelder

Hi

this is not tested, but should be possible

UPDATE dbo.Census_Access_Status_DB

SET Older_Version_exists = iit.FileR

FROM dbo.Census_Access_Status_DB ot inner join

(SELECT SUBSTRING(it.FileName,1,19) AS NewFileName

, CONVERT(VARCHAR,COUNT(*)) +' File returned' AS FileR

FROM Census_Access_Status_DB...

Can you post little bit more informations, like the View Statement or table structures

w. lengenfeler

Microsoft provides an overview of new Features at Microsoft Technet

w.lengenfelder

Hi,

I checked you code and it works. But you must ensure, that the file book1.xls exists and the first row contains the column captions FirstName, LastName.

w Lengenfelder

Do you got problems with VB or SQL.

I think it is VB because 32000 is a magic number for VB (especially VB6).

SQL Datatype "VARCHAR(MAX)" can handle this.

WLengenfelder

Hi,

I guess you have a Table with item prices and want to update these with values from a Excel file.

If so, you can simply access the Excel-File with the...