Red Gate forums :: View topic - received the following error message any ideas?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

received the following error message any ideas?

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jl45



Joined: 14 Jun 2013
Posts: 2
Location: United Kingdom

PostPosted: Fri Jun 14, 2013 1:28 pm    Post subject: received the following error message any ideas? Reply with quote

only things that stands out about the file in question is that it contains 2012 specific code (LAG and lead function), no other file in the database does.


Errors occurred whilst parsing file C:\Users\jsmith3\AppData\Local\Red Gate\SQL Source Control 3\Transients\pkauocpy.d1y\FU_Catalog\Views\sales.vw_SSRS_overlapping_contracts.sql

'' at line 12, column 7

'' at line 29, column 20

'' at line 29, column 68

'' at line 34, column 38


EDIT: files uploaded here: https://www.dropbox.com/s/jqtvpn56rkpobt9/sales.vw_SSRS_overlapping_contracts.sql
Back to top
View user's profile Send private message AIM Address
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Mon Jun 17, 2013 6:50 pm    Post subject: Reply with quote

Thanks for your post.

I created a very trimmed down view still containing lag/lead based on your example and it seems to work OK based on a quick commit / get to a different database.

What version of SQL Source Control are you working with? Are you able to supply the relevant table definitions needed by your example view so I can come up with a full working example? (please feel free to mail these to support@red-gate.com quoting F0074030 in the subject line if so)
Back to top
View user's profile Send private message
jl45



Joined: 14 Jun 2013
Posts: 2
Location: United Kingdom

PostPosted: Thu Jun 20, 2013 10:00 am    Post subject: Reply with quote

Thanks just sent it Very Happy
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group