Can you post the execution plans as .sqlplan file attachments for both the queries?

I don't see any issues with the statements, but I think you can try changing the NOT EXISTS clause to EXISTS clause and see if there's any performance improvement.

There are many methods by which you can delete duplicate rows from one table. Here is one of the ways you can do it.

It can also be done using...

Ya, I know CLR rocks with file handling, string manipulations etc., but I never really liked those .NET languages, 'cause I never succeeded...

Check out the following code.

DECLARE@year INT, @month INT

IF ( OBJECT_ID( 'tempdb..#test' ) IS NOT NULL )

DROP TABLE #test

CREATE TABLE #test

(

IncidentMode VARCHAR(100) NOT NULL,

CreatedDate DATETIME NOT NULL

)

INSERT#test( IncidentMode, CreatedDate )

SELECT'kunal',...

When the calling procedure expects a UNICODE value

To support international language support

pankaj.baluni (5/19/2009)

---

.... what...

:hehe:And I am hoping that Active-X should die with T-SQL.

I never was a...

I think this code COUNT(CASE WHEN Ethnic_Origin = '' THEN 0 ELSE 1 END) will always return COUNT(*) instead of COUNT(NonBlanks). Change the function COUNT to SUM

( SUM(...

Can you post the query/view which you are currently using?

Don't cross post, continue discussions here

First of all, for all your future posts read this article on how to post questions to getter better responses[/url]

Read this article on What is a Tally Table and how...

Using bcp or sqlcmd command utility in conjunction with xp_cmdshell procedure. For e.g.

EXECUTE master.dbo.xp_cmdshell 'sqlcmd -Q "SELECT * FROM AdventureWorks.Person.Contact" -o

MyOutput.txt'

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT FirstName, LastName FROM AdventureWorks.Person.Contact...

When you say "some of the features don't work", do you get any errors when trying to work with those features. If yes, can you post those errors and...

It can be done both the ways, but since you are already using the script component to do some parsing, its better to add the new column to the script...

By prefixing a constant string with "N", you are letting SQL to know that the string is a UNICODE string.