How can I do this another way. I try to create an xml file with 2000.

how to assingn the results of a FOR XML query to a variable?

Kind...

Thank you very much.

Kind Regards

Aysegül

Hi,

I modified my query as below

select

KB.KartelaNo as KBBarkod,

KB.HambezStokAnmaKodu as KBHambezStokAnmaKodu,

SH.StokAnmaAdi as KBHambezStokAnmaAdi,

KB.ZeminRenkKodu,

KB.En,

KB.EnTolerans,

KB.GramajGrm2,

KB.GramajTolerans,

KB.Konstruksiyon,

(select

K.Aciklama as 'Aciklama'

,KD.DosyaID as 'KDBarkod',

KD.DesenNo as 'DesenNo',

KD.VaryantNo as 'VaryantNo',

KD.HambezStokAnmaKodu as 'KDHambezStokAnmaKodu'...

Thank you very much.

I works.

Kind regards

Aysegül

Hi,

I am trying to show a report from a server by clicking a button.

I do these things as

Microsoft.Reporting.WebForms.ReportViewer form = new ...

Hi,

I doesn't work.the parameter is datetime.

Hi,

I can't do the example.

How can i do? I couldn't find the window in the first picture ( IN sql 2005 management studio)

these are the my SQL Server informations.

Microsoft SQL Server Management Studio Express 9.00.3042.00

Microsoft Data Access Components (MDAC)6.0.6000.16386 (vista_rtm.061101-2205)

Operating System6.0.6000

I install SP2.

There is any problems between Visual Studio and...

Thank you very much .

Hi. With your help I wrote this sql as below.

But it doesn't work as I want.

I want to filter by with dbo.fDetermineStartDate return value when

fDetermineEndDate is null.

if...

Thank you for your help.

Thank you for your help.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER     PROCEDURE sel_genelsatifiyat2

 (

  @urunid int ,

  @ozelkategori nvarchar(10),

  @fiyatgrup nvarchar(30),

  @miktar float,

  @bfiyat float output,

  @pbirim float output,

  @tutar  float output

&nbsp

Thank you very much for your help.

Thanks for your warnings.

Can you give an example in connection with these warnings. I will understand better with an example.