DECLARE @T Table (ID int , name varchar(50))

INSERT INTO @T

Select 1,'br' UNION

Select 1,'er' UNION

Select 2,'rt' UNION

Select 3,'yh' UNION

Select 2,'uj' UNION

Select 3,'iu' UNION

Select 3,'ol'

Select ID,Name From

(SELECT ID,Name,Row_Number() OVER ( Partition...

You can replace SUM by COUNT

Hi Santosh,

A new feature in SQL Server 2005, Database Mail, is an enterprise solution for sending e-mail messages from the Microsoft SQL Server 2005 Database Engine.

To use Database Mail, you...

Pleased to help you 🙂

Hi Sol,

Try this

DECLARE @a varchar(10),@b varchar(10)

SET @a='1'

SET @b-2='1 '

if QUOTENAME(@a) = QUOTENAME(@b)

print 'True'

else

print 'False'

Hey,

Report Item means any control like TextBox in which you want the required format.

IF this is text box then go to the property window of TextBox and just type £#,##0.00...

Yeah,

I agree with nigel

As simple as it is:

-- Query

USE [MyDataBase]

GO

TableName -- Bold shows that it is selected

-- Now Press Alt+F1

I think it is very easy and self explanatory.

See the attachment

Hi,

Set the Imaze sizing property "Clip" and try again.

Hi,

I think Jeffrey Williams is right.

Your parameters have casecade dependecy. So you need to set the proper order of parameter.

e.g there are 3 parameters: Country, State, and City.

And State is...

Hi Kurt,

You can use Row grouping in your table.

Add one Group for ID

Now Drag and drop ID and Name fields in Group Hearder. You can hide Group Footer.

You can place...

Hi Ravi,

Its a better idea of having three Groups in your table. You can take only Group Header( Group Footer is not required in your case)

First Group for Country

Second Group...

How many rows are there in Detail section?

Hi Shahbaz,

Yes, you can check the query execution plan of every statement/line using "Display Estimated Query Plan". Just Select all the queries and click on the button "Display Estimated Query...

ALTER PROCEDURE dbo.Proc (@PARAM4 nvarchar )

AS

Create table TEST (id int identity(1,1) , RowNum nvarchar(100))

EXEC('insert TEST(RowNum)

(Select Count (1)RowNum

...