Viewing 15 posts - 121 through 135 (of 1,082 total)
ah sorry I must have miss read the spec...
if you need more help just shout
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 29, 2009 at 9:21 am
I know it may not help but please could you post the two graphical execution plans ?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 29, 2009 at 2:10 am
something like this:
CREATE TABLE Client
(ClientId INT IDENTITY(1,1),
LastName VARCHAR(100),
FirstName VARCHAR(100),
MiddleName VARCHAR(100))
CREATE TABLE ClientAccount
(AccountId INT IDENTITY(1,1),
ClientId INT,
AccountNumber VARCHAR(100))
--TEST DATA
INSERT INTO Client
SELECT 'Stobbs', 'Chris' , 'Terence' UNION ALL
SELECT 'Joe', 'Blogs' , 'Middle' UNION...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 10:22 am
would it not be possible to enter you various search items into a temp table/table variable with 1 col and do various left joins onto your main table and take...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 10:12 am
jamie (5/27/2009)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:53 am
As far as I know by default this data is not sorted.
You may need to implement some sort of Auditing in your db
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:41 am
Marcus why don't you try the supplied solution and just add a where clause?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:39 am
no problem at all 😉
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:27 am
As I understand it , you always specify ON DATABASE and simple make sure that you run it on the correct DATABASE
if that make sense?
USE [MyDB]
GO
CREATE TRIGGER ddl_log ON DATABASE
FOR...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:20 am
try and remove the "1" from DATABASE1 and just have it say ON DATABASE
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:15 am
could you post the exact error and all the code for the trigger please
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 9:08 am
Having you tried looking into the ROW_NUMBER() function and or the GROUP BY function for this type of problem.
If you need more help just shout
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 8:58 am
Hi there,
Could you psot the execution plan a .sqlplan to this thread makes it easier to read.
The second thing is that if might be good to have an index that...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 28, 2009 at 8:48 am
no correct answers to choose from ::::
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 27, 2009 at 5:56 am
what do you mean by reseed?
Truncate is going to remove all your data!
What about DBCC CHECKIDENT (tableName,reseed, ?)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 10:31 am
Viewing 15 posts - 121 through 135 (of 1,082 total)