Here is in clear manner and in short...

Source Data:-

TICKET NO----NET AMOUNT

1809828094----84270

----0

...

Agreed with tosscrosby

Kindly provide the Source details...

regards

Palash Gorai

Hi,

Composite Index is used when you want to have only the Unique Records in a combination of more than one column..

For Instance, in Email DB, you want to have unique...

Correct, it should be Name not REGION.

regards

Palash Gorai

Hi,

What i understood is that you need to retrieve the data from bbc tbl where regions are India and Iran.

If i am right, then try this one:-

SELECT *

FROM BBC

WHERE...

Hi,

Try the following logic (NOT EXISTS)

Here EMPID is the Primary key.

INSERT INTO TBL1

SELECT *...

Hi,

This code will run only if you are sure that "/" won't appear prior to Date.

Declare @a as nvarchar(200)

Set @a = 'Your item was delivered...

Agreed!!!

You have to focus more on the joins, where clauses , sub-queries, temp tables to speed up the procedures.

regards

Palash Gorai

I would appreciate if you can provide the DDL and DML for creating Sample data, so that we can workout...

regards

Palash Gorai

Greetings!!

Try this:-

select sum(isnull([check],0)) as sum_check, sum(isnull(cash,0)) as sum_cash,

sum(isnull([check],0))+sum(isnull(cash,0)) as Total

from #tbldata

Regards

Palash Gorai

Hi,

If i am not wrong, you are looking for this:-

SELECT DATEPART("YYYY",GETDATE())-2

regards

Palash Gorai

Hi,

In SSRS, in the report parameter section, you can define the default value either by hardcoding the values or via T-SQL.

regards

Palash Gorai

Sorry, still we are not getting what is the requirement?

regards

Palash Gorai

Hi Guys,

Here is the Solution:-

1. For Searching Date of Birth, put DOB in 'yyyymmdd' format

DECLARE @FIELDNAME NVARCHAR(200)

DECLARE@SEARCHTEXT NVARCHAR(200)

DECLARE@sql VARCHAR(2000);

SET @FIELDNAME = 'DateOfBirth'

SET @SEARCHTEXT = '20100601' --yyyymmdd format

set

Hi,

NOT EXISTS is the most optimized way of coding.

Run on huge DB and check the execution plan. The CPU time of the LEFT OUTER JOIN will be higher than...