Viewing 15 posts - 811 through 825 (of 5,502 total)
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...
December 6, 2011 at 10:23 am
Ninja's_RGR'us (12/6/2011)
ChrisM@Work (12/6/2011)
Ninja's_RGR'us (12/6/2011)
LutzM (12/6/2011)
Changing subject: Does anyone know one of the DBAinSpace finalists?There's no name I recognize as one of the Threadizens....
There's noone I recognize from this site, period....
December 6, 2011 at 10:14 am
Changing subject: Does anyone know one of the DBAinSpace finalists?
There's no name I recognize as one of the Threadizens....
December 6, 2011 at 10:02 am
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...
December 6, 2011 at 10:01 am
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...
December 5, 2011 at 12:50 pm
jonangela571 (12/4/2011)
Hello all my friend. I am new member
Spam. Reported. No replies please.
December 4, 2011 at 10:01 am
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...
December 4, 2011 at 9:36 am
amigoface (12/4/2011)
the date format was DD.MM.YYYY , it should be MM.DD.YYYY
so date like 01.01.1984 was insert fine unlike dates...
December 4, 2011 at 9:11 am
Slightly different:
Inside the sproc you'd have multiple TRY CATCH blocks. One per block of statements you want to control separately.
December 4, 2011 at 9:02 am
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....
December 4, 2011 at 8:35 am
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 >=...
December 4, 2011 at 2:39 am
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...
December 3, 2011 at 11:04 am
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)...
December 3, 2011 at 9:45 am
You might find this link helpful, too.
Unfortunately, Microsoft decided to "hide" all online licencing documentation for SQL 2008. All links refer to 2008R2....
But the best option would be to contact...
December 3, 2011 at 7:54 am
Please provide table def, sample data and expected result as decribed in the first link in my signature. It will be much more helpful than a verbal description...;-)
December 3, 2011 at 5:34 am
Viewing 15 posts - 811 through 825 (of 5,502 total)