Nice article, Keep is up.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

1. You are looking for something which is based on grouping of Multiple records, so in this case you have to use HAVING,GROUP BY with out this there is no...

Hi,

You can;t do this with PIVOT table. You need to define the mapping table between the environemnts then only you can do this.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

Glad to see that you have the answer to your question and which is perfect with the experience that i have on architecture side.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Method 1 - INFORMATION_SCHEMA.ROUTINES

This approach uses INFORMATION_SCHEMA.ROUTINES to search through the definition of the routine such as the stored procedure, trigger, etc...

Method 2 - sp_depends

This approach uses the system...

Hi,

Are you looking for last day of the month in genral or last day of the month with in the table? By looking at your description, it looks like you...

Hi,

Yo uhave the answer to your question, but i would like to know why do you want to display two records for same Employee? Shouldn't it be only one record...

Hi

Check out the below link

http://support.microsoft.com/kb/q139444/

http://www.sql-server-performance.com/articles/dev/dv_delete_duplicates_p1.aspx

Thanks -- VJ

http://dotnetvj.blogspot.com

Hi

At times, it is needed that you encrypt the text of stored procedures containing sensitive information. SQL Server provides the WITH ENCRYPTION to encrypt the text of the stored procedure.

CREATE...

hi

r u getting any errors.

thanks -- vj

http://dotnetvj.blogspot.com

Hi,

Finally when you are ready test ur-self against TestKing. This will tell you where do stand in.

Thanks -- Vj

http://dotnetvj.blogspot.com

Try removing the IF conditions and see whether trigger are firing or not and after that add one by one.

Thanks -- Vj

Hi,

It is completely depends on the Port number.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

SQL Black Book is also good.

http://www.amazon.com/Microsoft-Server-Black-Book-Administrators/dp/1576101495

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

select count(*) from master..sysprocesses where spid > 50 will give you

a rough number. This will include logins from SQL Agent. Note that the

same user can be using multiple connections from...