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 @sql = 'SELECT...

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...