This behaviour is one of the reasons why you should never rely on default length. Errors caused by incorrect use of default length are often hard to find and truncation...

From the standard card games, I prefer FreeCell over Solitaire, but I don't play this type of games much. When there are just a few minutes to while away, I...

Well, did you try it? There are lots of options you can set when creating the script from EM - you can include indexes, triggers, defaults, constraints and other things....

In most cases it isn't a good idea to add columns dynamically to a table - but it can be useful sometimes when creating a report, so I'll skip that...

If you plan to send mail based on a trigger, be sure to implement it so that the trigger sets a flag in some table, and then some other process...

It depends on how the rest of the code is written and how are you getting the values to be inserted.

You can not use selects when using VALUES keyword.

You...

Maybe this will do what you want?

select COUNT(DISTINCT pollingplace)

from votes

WHERE votecount > 0

It will give you all places that have reported at least something... not all that have reportes all...

The function was posted above by Ray.

CREATE FUNCTION RemoveDecimalsWithoutRounding ( @InputValue Float, @Decimals Int)

-- Get the rounded value

DECLARE @ReturnValue Float;

SET @ReturnValue = Round(@InputValue, @Decimals);

-- If the value is too high...

You could try to search these forums for "crosstab" or "pivot". There are lots of similar questions, but I have to say that with your 500 or more columns in...

Ahhh... a test environment and lazy users. Been there, too...

If you want to do it, maybe you could use something in the way Lowell posted - transferring just the few...

I'm glad it worked - but I guess a little warning is in place. This method uses triangular join on StartDate column, so under certain circumstances it could perform badly....

Yeah, well I had to do some similar things when we were migrating from old system to SQL Server... try this. It creates the test table, inserts data and then...

This should be correct definition of test data:

SET DATEFORMAT dmy

CREATE TABLE #Sample(Account VARCHAR(10), Product VARCHAR(10), StartDate DATETIME, EndDate DATETIME, Bonus INT)

INSERT INTO #Sample

SELECT '20943','A','26/01/2005', NULL, 10 UNION

SELECT '20943','A','01/02/2005', NULL, 10...

Now, if I get it right, since the bonus does not change, the second row is not necessary (nothing would change if you delete it). I suppose the system has...

Lowell,

I'm afraid you probably got it wrong. It is "Account", "Product", "StartDate", "EndDate" and "Bonus"... at least I think so. Unfortunately the values are not delimited in any way and...