Hi,

There are 2 reasons,

1. You are not executing the 2nd and 3rd. only you assign the value to stmt3.

2. in your query, there is miss sequence of Begin - End

Use Row_Number OVER(ORDER BY (Select 0)) and based on row_number run query. It is very faster than Cursor.

Hi,

I wrote following syntax:

exec 'Create proc sarvesh as Begin Select 0 end'

but it gives error, pls run this and send me right syntax.

Hi,

I made one sp like as:

Create proc sarvesh

as

Begin

Select 0

end

I want to run this script at client side from my side. I send this as an...

Hi peso,

Ok if u r right then give me a query by using group by clause for removing duplicate values from a table. and without using a aggregate function.

Regards

Sarvesh Kumar...

Hi,

Thanx, This is working right. what do you tell me abt coalesce().

Sarvesh:)

Hi,

Group By clause is used for grouping the data with one of the field whereas distinct is used for removing duplicate values.

Sarvesh Kumar Gupta 😎

Hi,

What have you used cursor and split function for this work, if not then use both of these and get your result. I m sure that it will give result...

Hi,

Following are the some Features in Sql Server 2005:

1. integration of your back-end systems and data transfer across firewalls using XML.

2. Scale your applications up to 32 CPUs and 64...

Hi,

You are right that cursor is not a good idea for this but when you are using frontend language and backend.

If there is any such type of work that we...

Hi,

If you are fetching data from a table and want change on each row at a field then you can use cursor. it runs once time for each row.

Below is...

Hi,

you are updating date value which have varchar datatype then use

same datatype of parameter value in usp.

if you are using query window to write a query then pass value in...

Hi all of you,

Full Info regarding my topic:

I have multiples tables in my database and i have taken backup of these tables in my folder where are multiple .csv...

Hi,

Thanks.

Regards

Sarvesh Kumar Gupta:satisfied:

Hi,

I am using following query to use db mail sending and this is not giving any error:

EXEC msdb.dbo.sp_send_dbmail @recipients= @EMail_ID ,

@subject = 'New Job Post'...