received the following error message any ideas?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

received the following error message any ideas?

Postby jl45 » Fri Jun 14, 2013 1:28 pm

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/jqtvpn56rkpob ... tracts.sql
jl45
 
Posts: 2
Joined: Fri Jun 14, 2013 1:26 pm
Location: United Kingdom

Postby james.billings » Mon Jun 17, 2013 6:50 pm

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)
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby jl45 » Thu Jun 20, 2013 10:00 am

Thanks just sent it :D
jl45
 
Posts: 2
Joined: Fri Jun 14, 2013 1:26 pm
Location: United Kingdom


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests