Viewing 15 posts - 5,776 through 5,790 (of 8,416 total)
lmu92 (2/28/2010)
Paul White (2/27/2010)
I compared your solution and mine using exec plan and mine is about 10-15 times faster (based on that limited sample data).
Really? I did run both...
February 28, 2010 at 4:05 am
chip8 (2/26/2010)
February 28, 2010 at 2:45 am
tabrez.test (2/28/2010)
i have used the following query but its also displaying the policies which have trans in between add and can and policies with only add
When you say "policies which...
February 28, 2010 at 1:52 am
RBarryYoung (2/28/2010)
Cool. That would be my choice, simpler.
Quite. The pooled keys would be allocated from a Sequence Table, naturally 🙂
February 28, 2010 at 1:25 am
You can find the pre-2008 SP1 CU5 version of Erland's article at another location on his site: Dynamic Search Conditions in T-SQL
The conclusion of the article is:
February 28, 2010 at 12:52 am
RBarryYoung (2/28/2010)
February 28, 2010 at 12:15 am
USE tempdb;
GO
DECLARE @SampleData
TABLE (
id INTEGER IDENTITY NOT NULL,
...
February 28, 2010 at 12:11 am
tabrez.test (2/27/2010)
also ihave tried above sql they are also displaying policies which have trans add and trans can and in between other trans like ren,adj,,,(which should not )
No they...
February 27, 2010 at 11:45 pm
tabrez.test (2/27/2010)
yes there is another column trn_id which has numbers 1,2,3 ..10
Thanks for that information, late as it is 🙁
tabrez.test (2/27/2010)
February 27, 2010 at 11:06 pm
CirquedeSQLeil (2/6/2010)
Would a sequential guid work in place of an int?
Yes, but they have problems of their own. Quite apart from the issues of key width and getting the...
February 27, 2010 at 11:02 pm
--
-- Use a view instead of the CTE:
--
CREATE VIEW dbo.BaseData
WITH SCHEMABINDING
AS
SELECT ...
February 27, 2010 at 10:48 pm
This is just for fun:
USE tempdb;
GO
DECLARE @SampleData
TABLE (
id INTEGER IDENTITY NOT NULL,
...
February 27, 2010 at 10:32 pm
RBarryYoung (2/27/2010)
February 27, 2010 at 10:00 pm
Viewing 15 posts - 5,776 through 5,790 (of 8,416 total)