Grant Fritchey (12/6/2011)

---

LutzM (12/6/2011)

---

I guess I know...

I guess I know why neither Gail...

I would start with replacing the table variables with indexed temp tables.

Then I would replace the c.u.r.s.o.r. *cough* by adding the #DateRanges table using CROSS APPLY to each of the...

Ninja's_RGR'us (12/6/2011)

---

ChrisM@Work (12/6/2011)

---

Ninja's_RGR'us (12/6/2011)

---

There's noone I recognize from this site, period....

Changing subject: Does anyone know one of the DBAinSpace finalists?

There's no name I recognize as one of the Threadizens....

If you worry about posting the code in public but you're looking for help then you might consider to hire a consultant.

Of course, this would involve money.

But the "major...

After cleaning up the schema name as well as filegroup reference all I could figure out is an obviously not exsiting column PortfolioKey in table DimPortfolio (called by [sp_TradeDetail]).

Gave up...

Spam. Reported. No replies please.

What do you consider as "limitations"?

Would the fact count, that a query with a WHERE clause that covers more than one partition might run significantly slower than against a properly...

amigoface (12/4/2011)

---

i think that i have found what was wrong in my script

the date format was DD.MM.YYYY , it should be MM.DD.YYYY

so date like 01.01.1984 was insert fine unlike dates...

Slightly different:

Inside the sproc you'd have multiple TRY CATCH blocks. One per block of statements you want to control separately.

There are several option you could use:

1) instead of sending the large script from your app, store it in SQL Server (as a stored procedure) and just call the sproc....

Here's a short example how to use the DATEADD/DATEDIFF approach:

DECLARE @tbl TABLE

(

DateFrom DATETIME

)

INSERT INTO @tbl

VALUES(

'2011-09-30'),

('2011-10-31')

SELECT

DATEADD(hh,8,DATEADD(dd,DATEDIFF(dd,0,DateFrom),0)) AS HourFrom,

DATEADD(hh,32,DATEADD(dd,DATEDIFF(dd,0,DateFrom),0)) AS HourTo

FROM @tbl

In your query, you'd use >=...

Maybe using EXCEPT migt be better here. Not sure without table def, sample data and expected result... (see the first article in my signature for details on how to post...

If I'd only know the expected result based on the sample data I might be able to provide an alternative solution (using ROW_NUMBER() and/or CROSS APPLY)...