[font="Verdana"]

Mark (1/16/2009)

---

Mahesh Bote (1/16/2009)

---

[font="Verdana"]No, you are right. I have not mentioned the Delete statement.

Delete From Store

Where Store.Metadata.exist('/author[not(contains(., "Per Bothner"))]') >= 0

It should delete those elements whos author is other...

[font="Verdana"]No, you are right. I have not mentioned the Delete statement.

Delete From Store

Where Store.Metadata.exist('/author[not(contains(., "Per Bothner"))]') >= 0

It should delete those elements whos author is other than "Per Bothner".

Mahesh[/font]

[font="Verdana"]Can't you use any reporting tools such as Crystal Report. I would suggest, queries should be to retrive data from DB and all the processing should be done at FE...

[font="Verdana"] instead you can try below method:

If Exists (Select * From dbo.SysObjects Where id = object_id(N'[dbo].[TempTest]') And OBJECTPROPERTY(id, N'IsTable') = 1)

Drop Table [dbo].[TempTest]

Go

Create Table TempTest (

Field! VarChar(10),

...

)

Go

Mahesh

[/font]

[font="Verdana"]such syntax will work with Oracle only. so it won't work in any version with SQL server

Mahesh[/font]

[font="Verdana"] try ..

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032278648&CountryCode=US

Mahesh[/font]

[font="Verdana"]Check the user credentials, other than SA, whether it has equivalent with SA.

Mahehs[/font]

[font="Verdana"]

Try

Create PROCEDURE NN

@OPT varchar(100) OUTPUT

AS

Select @OPT = replicate('A', 10)

Go

declare @OP varchar(15)

exec NN @OPT = @OP output

select @OP

Mahesh

[/font]

[font="Verdana"]Try this ...

Create Table Pivot_Tab

(FullNameVarChar(10)

,TeamVarChar(2)

,VolumeInt

,RangeVarChar(15))

Go

Insert Into Pivot_Tab

Select 'brian', 'G1', 1, '0 to 100' Union All

Select 'randy', 'G1', 2, '0 to 100' Union All

Select 'brian', 'G1', 3, '101 to 200' Union...

[font="Verdana"]

vasaharshit (11/4/2008)

---

hi,

i want some recursive function or stored procedure for the following purpose.

...

[font="Verdana"]I am not sure, but I think your servers must be linked servers. First link them and then try. (May be I guess right)

Mahesh[/font]

[font="Verdana"]you don't need another function to generate serial number. with some workaround you can generate serial number in the same query. if possible post your functions.

Mahesh[/font]

[font="Verdana"]

Here, if you wants to return Y in case of...

[font="Verdana"]Its not possible to execute proc inside DML statements. Instead you go for UDF.

Mahesh[/font]

[font="Verdana"]Restart SQL Server, because TempDB is recreated whenever SQL server restarts

Mahesh

[/font]