(with apology)

and i reckon, good programming skills are needed to understand this code.

Try it,

Grant View Server State To [userid/login]

hey,

here is the details,

1) inner join or join, its behavior is same, so there will be no effect if you replace inner join with join.

2) parenthesis will not change its...

can you provide table structure? if possible, provide some sample data.

If key is in sequence and there is no break in that sequence then you can use the current table values only, if there is break in key sequence, then...

Hi Nair,

I used two temporary tables just to show you the insertion from one temporary table to another table with different column names and default current date value,

Create Table #Temp1

(val1...

Hi Vetran,

Try below query.

select isnull(Name,'Total') ,count(name) from table1

group by name with rollup

Hi,

I appreciate the work by Jaya and i have also tried to look into it and here is another query that you can also try. - Good luck,

SELECT T1.StationDescription...

Try it,

DECLARE @product_name nvarchar(3)

SET @product_name = 'A'

SELECT * FROM dim_product

WHERE (CASE WHEN product_key = 2 and source_product_name='A' And @product_name<>'A' THEN 1 --A

WHEN product_key = 2 and...

first statement should be more efficient then 2nd one, because index does not participate or does not play role when any type of conversion is performed.

what was your outcomes by...

can you try using table level lock hint? e.g. with (nolock), i found some times non-ignorable outcomes by using this hint.

Can you check it in a way, by creating sql login on the 2nd server, and then map this sql login to the sql agent login on the instance where...