error

[maryam_jamshid]

سلام دوستان
من یه view ساختم وقتی اجراش میکنم این error رو می ده.
چرا؟؟؟؟

[whitehat]

شما یک اشکال نحوی در view دارید، کد ویو را اینجا قرار دهید

[حمیدرضاصادقیان]

شما در view تون میخواهید مقدار ستون تاریخ رو که به صورت nvarchar هست و یک مقدار عددی خالص نیست رو به یک مقدار عددی تبدیل کنید. یا به ستونی اختصاص بدید که مقدارش عددی هست.
و برای راهنمایی دقیقتر لطف کنید کد مربوطه رو قرار بدید.

[maryam_jamshid]

SELECT dbo.tarekh_moshavereyetahseli.tarekh, dbo.tarekh_moshavereyetahseli_olompaye.moshavereye tahseli_tedadeolompaye,
dbo.tarekh_moshavereyetahseli_keshavarzi.moshavere yetahseli_tedadekeshavarzi,
dbo.tarekh_moshavereyetahseli_fani.moshavereyetahs eli_tedadefani, dbo.tarekh_moshavereyetahseli_ensani.moshavereyeta hseli_tedadeensani,
dbo.tarekh_moshavereyetahseli_doctori.moshavereyet ahseli_tedadedoctori,
dbo.tarekh_moshavereyetahseli_karshenasiarshad.mos havereyetahseli_tedadekarkarshenasiarshad,
dbo.tarekh_moshavereyetahseli_karshenasi.moshavere yetahseli_tedadekarkarshenasi,
dbo.tarekh_moshavereyetahseli_kardani.moshavereyet ahseli_tedadekardani,
dbo.tarekh_moshavereyetahseli_shahed.moshavereyeta hseli_tedadeshahed,
dbo.tarekh_moshavereyetahseli_azad.moshavereyetahs eli_tedadeazad,
dbo.tarekh_moshavereyetahseli_organha.moshavereyet ahseli_tedadeorganha,
dbo.tarekh_moshavereyetahseli_razmandegan.moshaver eyetahseli_tedadrazmandegan,
dbo.tarekh_moshavereyetahseli_mojarad.moshavereyet ahseli_tedademojarad,
dbo.tarekh_moshavereyetahseli_mard.moshavereyetahs eli_tedademard, dbo.tarekh_moshavereyetahseli_tahol.moshavereyetah seli_tedadetahol,
dbo.tarekh_moshavereyetahseli_zan.moshavereyetahse li_tedadezan,
dbo.tarekh_moshavereyetahseli_manategh.moshavereye tahseli_tedademanategh,
dbo.tarekh_moshavereyetahseli_manzel.moshavereyeta hseli_tedademanzel,
dbo.tarekh_moshavereyetahseli_khabgah.moshavereyet ahseli_tedadekhabgah,
dbo.tarekh_moshavereyetahseli_valedeyn.moshavereye tahseli_tedadevaledeyn,
dbo.tarekh_moshavereyetahseli_ravansanji.moshavere yetahseli_tedaderavansanji,
dbo.tarekh_moshavereyetahseli_moshavere.moshaverey etahseli_tedademoshavere,
dbo.tarekh_moshavereyetahseli_ravandarmani.moshave reyetahseli_tedaderavandarmani,
dbo.tarekh_moshavereyetahseli_ravanpezeshki.moshav ereyetahseli_tedaderavanpezeshki
FROM dbo.tarekh_moshavereyetahseli_moshavere RIGHT OUTER JOIN
dbo.tarekh_moshavereyetahseli ON dbo.tarekh_moshavereyetahseli_moshavere.tarekh = dbo.tarekh_moshavereyetahseli.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ravansanji ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ravansanji.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ravanpezeshki ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ravanpezeshki.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ravandarmani ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ravandarmani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_valedeyn ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_valedeyn.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_manzel ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_manzel.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_khabgah ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_khabgah.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_manategh ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_manategh.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_tahol ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_tahol.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_zan ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_zan.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_mard ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_mard.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_mojarad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_mojarad.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_azad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_azad.moshavereyetahs eli_tedadeazad LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_shahed ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_shahed.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_organha ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_organha.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_razmandegan ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_razmandegan.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_kardani ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_kardani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_karshenasi ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_karshenasi.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_karshenasiarshad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_karshenasiarshad.tar ekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_doctori ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_doctori.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_fani ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_fani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ensani ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ensani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_olompaye ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_olompaye.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_keshavarzi ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_keshavarzi.tarekh

[حمیدرضاصادقیان]

SELECT dbo.tarekh_moshavereyetahseli.tarekh, dbo.tarekh_moshavereyetahseli_olompaye.moshavereye tahseli_tedadeolompaye,
dbo.tarekh_moshavereyetahseli_keshavarzi.moshavere yetahseli_tedadekeshavarzi,
dbo.tarekh_moshavereyetahseli_fani.moshavereyetahs eli_tedadefani, dbo.tarekh_moshavereyetahseli_ensani.moshavereyeta hseli_tedadeensani,
dbo.tarekh_moshavereyetahseli_doctori.moshavereyet ahseli_tedadedoctori,
dbo.tarekh_moshavereyetahseli_karshenasiarshad.mos havereyetahseli_tedadekarkarshenasiarshad,
dbo.tarekh_moshavereyetahseli_karshenasi.moshavere yetahseli_tedadekarkarshenasi,
dbo.tarekh_moshavereyetahseli_kardani.moshavereyet ahseli_tedadekardani,
dbo.tarekh_moshavereyetahseli_shahed.moshavereyeta hseli_tedadeshahed,
dbo.tarekh_moshavereyetahseli_azad.moshavereyetahs eli_tedadeazad,
dbo.tarekh_moshavereyetahseli_organha.moshavereyet ahseli_tedadeorganha,
dbo.tarekh_moshavereyetahseli_razmandegan.moshaver eyetahseli_tedadrazmandegan,
dbo.tarekh_moshavereyetahseli_mojarad.moshavereyet ahseli_tedademojarad,
dbo.tarekh_moshavereyetahseli_mard.moshavereyetahs eli_tedademard, dbo.tarekh_moshavereyetahseli_tahol.moshavereyetah seli_tedadetahol,
dbo.tarekh_moshavereyetahseli_zan.moshavereyetahse li_tedadezan,
dbo.tarekh_moshavereyetahseli_manategh.moshavereye tahseli_tedademanategh,
dbo.tarekh_moshavereyetahseli_manzel.moshavereyeta hseli_tedademanzel,
dbo.tarekh_moshavereyetahseli_khabgah.moshavereyet ahseli_tedadekhabgah,
dbo.tarekh_moshavereyetahseli_valedeyn.moshavereye tahseli_tedadevaledeyn,
dbo.tarekh_moshavereyetahseli_ravansanji.moshavere yetahseli_tedaderavansanji,
dbo.tarekh_moshavereyetahseli_moshavere.moshaverey etahseli_tedademoshavere,
dbo.tarekh_moshavereyetahseli_ravandarmani.moshave reyetahseli_tedaderavandarmani,
dbo.tarekh_moshavereyetahseli_ravanpezeshki.moshav ereyetahseli_tedaderavanpezeshki
FROM dbo.tarekh_moshavereyetahseli_moshavere RIGHT OUTER JOIN
dbo.tarekh_moshavereyetahseli ON dbo.tarekh_moshavereyetahseli_moshavere.tarekh = dbo.tarekh_moshavereyetahseli.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ravansanji ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ravansanji.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ravanpezeshki ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ravanpezeshki.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ravandarmani ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ravandarmani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_valedeyn ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_valedeyn.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_manzel ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_manzel.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_khabgah ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_khabgah.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_manategh ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_manategh.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_tahol ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_tahol.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_zan ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_zan.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_mard ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_mard.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_mojarad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_mojarad.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_azad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_azad.moshavereyetahs eli_tedadeazad LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_shahed ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_shahed.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_organha ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_organha.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_razmandegan ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_razmandegan.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_kardani ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_kardani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_karshenasi ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_karshenasi.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_karshenasiarshad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_karshenasiarshad.tar ekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_doctori ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_doctori.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_fani ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_fani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_ensani ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_ensani.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_olompaye ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_olompaye.tarekh LEFT OUTER JOIN
dbo.tarekh_moshavereyetahseli_keshavarzi ON dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_keshavarzi.tarekh

[SYNDROME]

دوست عزیز من که نتوانستم کل View شما را بخوانم(تا حالا View به این بزرگی ندیده بودم)
پیغام خطایی که شما گذاشتید مربوط به یکی از فیلدهای تاریخی است که به صورت Nvarchar ذخیره کرده اید و حالا فکر کنم دارید به یک فیلد از نوع int برابر قرار می دهید مه اگر دقت کنید نمی تواند مقدار فوق را به int تبدیل کند.
یا View خود را از اول کم کم اضافه کنید تا به Error برسید.
یا کل مقادیر بانکتان ا خالی کنید و بعد View را اجرا کنید و به ترتیب که به هر Table یک رکورد اضافه می کنید View را اجرا کنید و تا به Error برسید.
موفق باشید

[maryam_jamshid]

مشکل حل شد.
من بین دو view ارتباطی گذاشتم که یکی از نوع nvarchar , و دیگری int بود.
دقیقا در این قسمت کد:
dbo.tarekh_moshavereyetahseli_azad ON
dbo.tarekh_moshavereyetahseli.tarekh = dbo.tarekh_moshavereyetahseli_azad.moshavereyetahs eli_tedadeazad
از کمکهاتون ممنونم.