Actually, if you read the discussion of the article, you can see performance comparisions for several methods. Your code should be faster than mine (which was recommended by the article)...

I don't understand your last comment.

You could find this article useful

http://www.sqlservercentral.com/articles/T-SQL/88244/

SELECT AttribID

FROM MyTable

WHERE FormatID IN (12,15)

GROUP BY AttribID

HAVING COUNT(DISTINCT FormatID ) = 2

EXCEPT

SELECT AttribID

...

Hi George,

You should really be trying to figure out this yourself by using BooksOnLine (BOL or SQL Server help) but I'll try to explain.

REVERSE will do exactly what it says,...

I hadn't noticed that the...

I suppose that you mean using a graphic interface.

You can right click on the views folder and choose the option New View..., that will give you a designer.

For the permissions,...

Hi, you're asking for something that might be very simple but we need somee DDL and if possible some sample data to work with. Read the article linked on my...

Last week I came up with this option. I haven't made performace tests. Maybe you could help me with that.

DECLARE @test-2TABLE(

myintint)

INSERT INTO @test-2 VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9);

WITH CTE AS(

SELECT myint,

NTILE( 2) OVER( ORDER...

Then it's a lot easier.

WITH CTE AS(

SELECT 'Jim k Smith' [FullName] UNION ALL

SELECT 'Robert K Lin' UNION ALL

SELECT 'Chris Tim'

)

SELECT LEFT( FullName, CHARINDEX( ' ', FullName)),

RIGHT( FullName, CHARINDEX( ' ',...

We need more information to see what's happening. Please read the article linked in my signature to find out what we need.

You need to create a view (reference) and then grant permissions only on that view (reference)

EDIT: Corrected language for the links.

You need to realize that you might have names that can change the logic. The most common example would be spanish names (which can appear even in an English speaking...

There's no need to have a variable for that, simply use a date calculation. 😉

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0)

You mean this?

LEFT(Value,charindex('.',Value)-1)

There are some IFCode tags available to the left of your screen when you're replying. For SQL you need to use [ code="sql"][ /code] (without space).