Transact SQL :: Ensure Code Non Regression By Keeping Consistent Signature For Procedure / Views And Function

Jul 28, 2015

In the 70-461 objectives it says: Ensure code non regression by keeping consistent signature for procedure, views and function (interfaces); security implications...I think I understand what this means in general. They want us to be able to create a view that will still be able to call the original data even if the table is modified.  In other words, the view table shouldn't easily be broken. ie, type a code that does NOT ensure non regression, then change the code so that it does ensure non regression. 

View 4 Replies


ADVERTISEMENT

Transact SQL :: Encrypt Java Code Using With Encryption Clause From Server Stored Procedure Or Function

Nov 3, 2015

How to encrypt the java application code using the 'with encryption' clause from sql server stored procedure or function.

View 3 Replies View Related

Make Sql Function To Modify Data Like Sql Procedure To Improve Code Structure And Readability.

Aug 27, 2007

Now Sql Function can not modify data as Sql Procedure like other database, it's very troublesome at most case!
in most case, Sql Function is used to improve code structure then it can be maintanced easy! BUT only because it can not modify data, there are 2 troublesome way:

1. Make all callers in the path from Sql Functions to Sql Procedure. and the coder will cry, the code will become very
confusional , and very difficult to maintance.

2. Divide the Sql Function into a thin CLR wrapper to call a Sql Procedure, can only use another connection, BUT can not be in the same transaction context And the code is ugly and slow.

You should not give limitation to Sql Function, should just limit the using context of Sql Function!

The sql code is more difficult to read and maintance than norm code(C#), then the improving code structure and readability should be one of your most important task, that's why microsoft!


View 6 Replies View Related

Transact SQL :: Keeping Tabs Open In 2014?

May 28, 2015

I had to re-image my computer and reinstall SQL 2014.  Now, when I open a table (edit top 200 rows) a tab opens (of course).  But if I do not hit something like Show Criteria Pane and try to open another tab the first tab is replaced by the second table's tab.  

How do I keep both open before hitting Show Criteria Pane?

View 2 Replies View Related

LogRegHelper - A Scorecard For Logistic Regression Models Does Not Match Logistic Regression Favors Score

Jun 24, 2007

Hello,



This question is regarding the LogRegHelper - "A scorecard for Logistic Regression models" example in sqlserverdatamining Tips and Tricks page. I launched TestLogReg (Analysis Services Database associated with the project) and ran Logistic Regression over that. While the LogReg shows the highest score for IQ (107 - 121), a score of 558, the Logistic Regression shows that Parent Encouragement has the highest score for the case College Plans = 'Plans to Attend'. Can someone verify this and clarify?



I have a few other questions with LR



- In SQL Server 2005 LR Mining Model Viewer "favors" chart, what algorithm is used for generating Scores?



- Can I use this score as a feature selector? Higher score => stronger predictor (input)



- Is the coefficient weight algorithm used in LogReg wrong ?



Thanks



MA

View 1 Replies View Related

Transact SQL :: Splitting Column Value While Keeping Existing Data

Jun 22, 2015

Currently I have a column with multiple postcodes in one value which are split with the “/” character along with the corresponding location data. What I need to do is split these postcode values into separate rows while keeping their corresponding location data.

For example
PostCode            Latitude               Longitude
66000/66100       42.696595            2.899370
20251/20270       42.196471            9.404951

Would become
PostCode            Latitude               Longitude
66000                    42.696595            2.899370
66100                    42.696595            2.899370
20251                    42.196471            9.404951
20270                    42.196471            9.404951

View 6 Replies View Related

Keeping Trailing Spaces On Function Returning Nvarchar(4000)

Mar 21, 2008

I'm trying desparately to write a PadRight function in SQL Server 2005. I seem to be failing miserably because the trailing spaces disappear when the data is returned. First of all, why does SQL Server think I want my string trimmed? And second, how do I overcome this? Code below:




Code Snippet
CREATE FUNCTION [dbo].[PadRight]
(

@sourceString NVARCHAR(4000),
@length INT,
@padCharacter NCHAR(1) = ' ',
@trimBeforePadding BIT = 1
)
RETURNS NVARCHAR(4000) AS
BEGIN

DECLARE @returnStringLength AS INT, @toReturn AS NVARCHAR(4000)
SET @toReturn = LEFT(@sourceString, @length)


IF @trimBeforePadding = 1

SET @toReturn = RTRIM(LTRIM(@toReturn))
SET @returnStringLength = LEN(@toReturn)
IF @returnStringLength < @length

SET @toReturn = @toReturn + REPLICATE(@padCharacter, @length - @returnStringLength)
RETURN @toReturn
END
GO

View 8 Replies View Related

Regression Testing A Stored Procedure That Produces Multiple Rowsets

Nov 1, 2006

How do I write a regression test for a stored proc that produces multiple rowsets via multipl e select queries? E.g.
CREATE PROCEDURE myProc AS
SELECT 'Some stuff', GETDATE()
SELECT 'Some more stuff'

For single-select procs, I can create a temp table and INSERT #temp EXEC myProc, then evaluate the contents of the table to verify correct behavior, but that doesn't work in this case.

View 1 Replies View Related

Function In Views

Jul 13, 2001

I am migrating an application from Oracel to SQL7. There is a view
in Oracle which uses a user-define function to generate a column.
Since SQL7 does not support user-defined functions in SQL, I wonder
if there is a workaround. Any suggestion is welcome. Thanks in advance.
Ray

View 2 Replies View Related

Many Lines Of Code In Stored Procedure && Code Behind

Feb 24, 2008

Hello,
I'm using ASP.Net to update a table which include a lot of fields may be around 30 fields, I used stored procedure to update these fields. Unfortunatily I had to use a FormView to handle some TextBoxes and RadioButtonLists which are about 30 web controls.
I 've built and tested my stored procedure, and it worked successfully thru the SQL Builder.The problem I faced that I have to define the variable in the stored procedure and define it again the code behind againALTER PROCEDURE dbo.UpdateItems
(
@eName nvarchar, @ePRN nvarchar, @cID nvarchar, @eCC nvarchar,@sDate nvarchar,@eLOC nvarchar, @eTEL nvarchar, @ePhone nvarchar,
@eMobile nvarchar, @q1 bit, @inMDDmn nvarchar, @inMDDyr nvarchar, @inMDDRetIns nvarchar,
@outMDDmn nvarchar, @outMDDyr nvarchar, @outMDDRetIns nvarchar, @insNo nvarchar,@q2 bit, @qper2 nvarchar, @qplc2 nvarchar, @q3 bit, @qper3 nvarchar, @qplc3 nvarchar,
@q4 bit, @qper4 nvarchar, @pic1 nvarchar, @pic2 nvarchar, @pic3 nvarchar, @esigdt nvarchar, @CCHName nvarchar, @CCHTitle nvarchar, @CCHsigdt nvarchar, @username nvarchar,
@levent nvarchar, @eventdate nvarchar, @eventtime nvarchar
)
AS
UPDATE iTrnsSET eName = @eName, cID = @cID, eCC = @eCC, sDate = @sDate, eLOC = @eLOC, eTel = @eTEL, ePhone = @ePhone, eMobile = @eMobile,
q1 = @q1, inMDDmn = @inMDDmn, inMDDyr = @inMDDyr, inMDDRetIns = @inMDDRetIns, outMDDmn = @outMDDmn,
outMDDyr = @outMDDyr, outMDDRetIns = @outMDDRetIns, insNo = @insNo, q2 = @q2, qper2 = @qper2, qplc2 = @qplc2, q3 = @q3, qper3 = @qper3,
qplc3 = @qplc3, q4 = @q4, qper4 = @qper4, pic1 = @pic1, pic2 = @pic2, pic3 = @pic3, esigdt = @esigdt, CCHName = @CCHName,
CCHTitle = @CCHTitle, CCHsigdt = @CCHsigdt, username = @username, levent = @levent, eventdate = @eventdate, eventtime = @eventtime
WHERE (ePRN = @ePRN)
and the code behind which i have to write will be something like thiscmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eName", ((TextBox)FormView1.FindControl("TextBox1")).Text);cmd.Parameters.AddWithValue("@ePRN", ((TextBox)FormView1.FindControl("TextBox2")).Text);
cmd.Parameters.AddWithValue("@cID", ((TextBox)FormView1.FindControl("TextBox3")).Text);cmd.Parameters.AddWithValue("@eCC", ((TextBox)FormView1.FindControl("TextBox4")).Text);
((TextBox)FormView1.FindControl("TextBox7")).Text = ((TextBox)FormView1.FindControl("TextBox7")).Text + ((TextBox)FormView1.FindControl("TextBox6")).Text + ((TextBox)FormView1.FindControl("TextBox5")).Text;cmd.Parameters.AddWithValue("@sDate", ((TextBox)FormView1.FindControl("TextBox7")).Text);
cmd.Parameters.AddWithValue("@eLOC", ((TextBox)FormView1.FindControl("TextBox8")).Text);cmd.Parameters.AddWithValue("@eTel", ((TextBox)FormView1.FindControl("TextBox9")).Text);
cmd.Parameters.AddWithValue("@ePhone", ((TextBox)FormView1.FindControl("TextBox10")).Text);
cmd.Parameters.AddWithValue("@eMobile", ((TextBox)FormView1.FindControl("TextBox11")).Text);
So is there any way to do it better than this way ??
Thank you

View 2 Replies View Related

TempDB , Consistent Connection

Sep 12, 2005

In MSSQL2000 I want to know how to make a user have a constant connection even if the the Server restarts . Im aware that tempDB clears itself everytime the server restarts, but still wanna know if i can have users/applicaitons connected even though the server restarts

View 4 Replies View Related

Data Corruption Consistent

Jun 13, 2007

Hi paul,
Can you help me solve this issue? I do backups everyday.
Do you think dropping and restoring the DB will solve this issue?

---------------------------------------------------------------------

DBCC results for 'dyacovel_db'.
DBCC results for 'sysobjects'.
There are 1044 rows in 20 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 5182 rows in 305 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 16780 rows in 499 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 659 rows in 296 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 67 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 23 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 9692 rows in 57 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'Luc_47Skus_Top100_Order_Counts'.
There are 45 rows in 1 pages for object 'Luc_47Skus_Top100_Order_Counts'.
DBCC results for 'DOMB_1MM'.
There are 0 rows in 1 pages for object 'DOMB_1MM'.
DBCC results for 'PROD_COMP_PROD2'.
There are 39218 rows in 405 pages for object 'PROD_COMP_PROD2'.
DBCC results for 'ST_DATE'.
There are 1 rows in 1 pages for object 'ST_DATE'.
DBCC results for 'Currency_CAD_to_USD_2004_2005'.
There are 731 rows in 2 pages for object 'Currency_CAD_to_USD_2004_2005'.
DBCC results for 'DOMB_1MW'.
There are 0 rows in 1 pages for object 'DOMB_1MW'.
DBCC results for 'DW_INVENTORY_COFILLRATEFULL'.
There are 58963 rows in 1235 pages for object 'DW_INVENTORY_COFILLRATEFULL'.
DBCC results for 'ST_MASTER_LOOP'.
There are 0 rows in 962 pages for object 'ST_MASTER_LOOP'.
DBCC results for 'DOMC1_PICK_TYPE'.
There are 158562 rows in 2742 pages for object 'DOMC1_PICK_TYPE'.
DBCC results for 'ml_xpdex_final_sold_rev'.
There are 66 rows in 1 pages for object 'ml_xpdex_final_sold_rev'.
DBCC results for 'temp_jumbo'.
There are 494973 rows in 14559 pages for object 'temp_jumbo'.
DBCC results for 'DOMB_1RK'.
There are 0 rows in 1 pages for object 'DOMB_1RK'.
DBCC results for 'michaelfor007'.
There are 2189 rows in 23 pages for object 'michaelfor007'.
DBCC results for 'SW_ORDER_FILLRATE_DL'.
There are 704131 rows in 42479 pages for object 'SW_ORDER_FILLRATE_DL'.
DBCC results for 'Sales_History_2005'.
There are 706373 rows in 141280 pages for object 'Sales_History_2005'.
DBCC results for 'DOMB_1RL'.
There are 0 rows in 1 pages for object 'DOMB_1RL'.
DBCC results for 'SOLD_SKUS_DL'.
There are 543293 rows in 1740 pages for object 'SOLD_SKUS_DL'.
DBCC results for 'DOMB_OUT'.
There are 317 rows in 16 pages for object 'DOMB_OUT'.
DBCC results for 'DOMC_PICK_TYPE'.
There are 158525 rows in 2791 pages for object 'DOMC_PICK_TYPE'.
DBCC results for 'DOMB_1TF'.
There are 0 rows in 1 pages for object 'DOMB_1TF'.
DBCC results for 'LUC_DAILY_FLASH_SALES_60DAYS'.
There are 13100 rows in 252 pages for object 'LUC_DAILY_FLASH_SALES_60DAYS'.
DBCC results for 'weekly_subclass_TOP10'.
There are 263 rows in 8 pages for object 'weekly_subclass_TOP10'.
DBCC results for 'DW_COFILLRATE_DL_PM'.
There are 80 rows in 3 pages for object 'DW_COFILLRATE_DL_PM'.
DBCC results for 'CURRENCY_CAD_USD'.
There are 701 rows in 7 pages for object 'CURRENCY_CAD_USD'.
DBCC results for 'LUC_SALES_ORDERDETAIL_2004'.
There are 688727 rows in 27611 pages for object 'LUC_SALES_ORDERDETAIL_2004'.
DBCC results for 'WEEKLYS_SUBCLASS_SALESly'.
There are 269906 rows in 8188 pages for object 'WEEKLYS_SUBCLASS_SALESly'.
DBCC results for 'Luc_47Skus_Top100_Step1'.
There are 3597 rows in 164 pages for object 'Luc_47Skus_Top100_Step1'.
DBCC results for 'DOMB_1TU'.
There are 0 rows in 1 pages for object 'DOMB_1TU'.
DBCC results for 'PROD_COMP_SKULIST'.
There are 12219 rows in 121 pages for object 'PROD_COMP_SKULIST'.
DBCC results for 'LUC_DAILY_FLASH_SALES_YESTERDAY'.
There are 326 rows in 8 pages for object 'LUC_DAILY_FLASH_SALES_YESTERDAY'.
DBCC results for 'WEEKLY_SUBCLASS_TOP20QTD'.
There are 290 rows in 10 pages for object 'WEEKLY_SUBCLASS_TOP20QTD'.
DBCC results for 'CO_DTL_DL_CA'.
There are 554 rows in 14 pages for object 'CO_DTL_DL_CA'.
DBCC results for 'DOMD1_PICK_TYPE'.
There are 158783 rows in 2895 pages for object 'DOMD1_PICK_TYPE'.
DBCC results for 'LUC_INVOICEDETAIL_2004'.
There are 732349 rows in 61395 pages for object 'LUC_INVOICEDETAIL_2004'.
DBCC results for 'DOMB_1W1'.
There are 0 rows in 1 pages for object 'DOMB_1W1'.
DBCC results for 'LUC_DAILY_FLASH_SALES_WEEKEND'.
There are 0 rows in 13 pages for object 'LUC_DAILY_FLASH_SALES_WEEKEND'.
DBCC results for 'Sales_Hist_Part_2004'.
There are 722121 rows in 144430 pages for object 'Sales_Hist_Part_2004'.
DBCC results for 'Luc_47Skus_Top100_Sku_Avgcost_Step1'.
There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Sku_Avgcost_Step1'.
DBCC results for 'swidziun.victory$'.
There are 492 rows in 8 pages for object 'swidziun.victory$'.
DBCC results for 'DOMB_1W4'.
There are 0 rows in 1 pages for object 'DOMB_1W4'.
DBCC results for 'mlehn.MLEHN_675_ADDRESS'.
There are 642 rows in 3 pages for object 'mlehn.MLEHN_675_ADDRESS'.
DBCC results for 'weekly_subclass_TOP10_RESALE'.
There are 20 rows in 1 pages for object 'weekly_subclass_TOP10_RESALE'.
DBCC results for 'cradtke.cr_intl_test2'.
There are 28062 rows in 939 pages for object 'cradtke.cr_intl_test2'.
DBCC results for 'Sales_History_2004'.
There are 722121 rows in 144431 pages for object 'Sales_History_2004'.
DBCC results for 'Weekly_Subclass_Forecast'.
There are 2652 rows in 51 pages for object 'Weekly_Subclass_Forecast'.
DBCC results for 'DOMB_1W5'.
There are 0 rows in 1 pages for object 'DOMB_1W5'.
DBCC results for 'ML_675_ADDR_MISS'.
There are 24 rows in 2 pages for object 'ML_675_ADDR_MISS'.
DBCC results for 'swidziun.UPLOAD$'.
There are 40 rows in 1 pages for object 'swidziun.UPLOAD$'.
DBCC results for 'DOM_BOL_S1'.
There are 366531 rows in 10488 pages for object 'DOM_BOL_S1'.
DBCC results for 'WEEKLY_SUBCLASS_BF_GBOOKED'.
There are 94017 rows in 2946 pages for object 'WEEKLY_SUBCLASS_BF_GBOOKED'.
DBCC results for 'SW_DS_BOOKED_ECP_PRISM_FINAL'.
There are 8 rows in 2 pages for object 'SW_DS_BOOKED_ECP_PRISM_FINAL'.
DBCC results for 'DOMB_SUMRRATE'.
There are 0 rows in 1 pages for object 'DOMB_SUMRRATE'.
DBCC results for 'mlehn.MLEHN_925_ADDRESS'.
There are 642 rows in 3 pages for object 'mlehn.MLEHN_925_ADDRESS'.
DBCC results for 'DANVILLE_TO_OUT'.
There are 10570 rows in 183 pages for object 'DANVILLE_TO_OUT'.
DBCC results for 'ECP_MARKET_SEGMENTS'.
There are 40 rows in 1 pages for object 'ECP_MARKET_SEGMENTS'.
DBCC results for 'Luc_47Skus_Top100_Sku_AvgCost'.
There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Sku_AvgCost'.
DBCC results for 'SW_DS_YESTERDAYS_SALE_ECP_PRISM_FINAL'.
There are 6 rows in 2 pages for object 'SW_DS_YESTERDAYS_SALE_ECP_PRISM_FINAL'.
DBCC results for 'DOMB_1TN'.
There are 0 rows in 1 pages for object 'DOMB_1TN'.
DBCC results for 'ML_925_ADDR_MISS'.
There are 88 rows in 4 pages for object 'ML_925_ADDR_MISS'.
DBCC results for 'weekly_subclass_TOP10_ALL'.
There are 20 rows in 1 pages for object 'weekly_subclass_TOP10_ALL'.
DBCC results for 'SW_DS_MTD_ECP_PRISM_FINAL'.
There are 10 rows in 2 pages for object 'SW_DS_MTD_ECP_PRISM_FINAL'.
DBCC results for 'Weekly_Subclass_Cancellation'.
There are 15991 rows in 799 pages for object 'Weekly_Subclass_Cancellation'.
DBCC results for 'ML_FAX_PMT_par'.
There are 6785 rows in 108 pages for object 'ML_FAX_PMT_par'.
DBCC results for 'LUC_ADHOC_SUBCLASS_04'.
There are 132823 rows in 4585 pages for object 'LUC_ADHOC_SUBCLASS_04'.
DBCC results for 'SALES_YESTERDAY'.
There are 1738 rows in 290 pages for object 'SALES_YESTERDAY'.
DBCC results for 'Luc_Top20_Invoices_Units_Step1'.
There are 123944 rows in 3756 pages for object 'Luc_Top20_Invoices_Units_Step1'.
DBCC results for 'SW_DS_BACKLOG1_ECP_PRISM'.
There are 224 rows in 4 pages for object 'SW_DS_BACKLOG1_ECP_PRISM'.
DBCC results for 'FREIGHT_FOR68'.
There are 16 rows in 1 pages for object 'FREIGHT_FOR68'.
DBCC results for 'WEEKLY_SUBCLASS_BF_GBOOKED_FINAL'.
There are 8806 rows in 152 pages for object 'WEEKLY_SUBCLASS_BF_GBOOKED_FINAL'.
DBCC results for 'DOMB_LOWEST_SUM_RATE'.
There are 0 rows in 1 pages for object 'DOMB_LOWEST_SUM_RATE'.
DBCC results for 'ML_FAX_FG09_Fg10_final'.
There are 444 rows in 6 pages for object 'ML_FAX_FG09_Fg10_final'.
DBCC results for 'DOMB_1CI'.
There are 0 rows in 1 pages for object 'DOMB_1CI'.
DBCC results for 'temp_stan_cost_m2_lb'.
There are 181694 rows in 1932 pages for object 'temp_stan_cost_m2_lb'.
DBCC results for 'ml_FAX_pmt_par_FINAL'.
There are 615 rows in 7 pages for object 'ml_FAX_pmt_par_FINAL'.
DBCC results for 'SALES_DATA_2006_2007'.
There are 0 rows in 1 pages for object 'SALES_DATA_2006_2007'.
DBCC results for 'Weekly_Sales_Sublcass_top20_bookings'.
There are 283 rows in 8 pages for object 'Weekly_Sales_Sublcass_top20_bookings'.
DBCC results for 'SALES2006_REPORT_1'.
There are 558623 rows in 13303 pages for object 'SALES2006_REPORT_1'.
DBCC results for 'DANVILLE_TO_RDCW1'.
There are 249 rows in 5 pages for object 'DANVILLE_TO_RDCW1'.
DBCC results for 'Luc_Top20_Invoices_Units_Step2'.
There are 123944 rows in 4274 pages for object 'Luc_Top20_Invoices_Units_Step2'.
DBCC results for 'SW_DS_BACKLOG_ECP_PRISM'.
There are 10 rows in 2 pages for object 'SW_DS_BACKLOG_ECP_PRISM'.
DBCC results for 'cr_expense_data'.
There are 74184 rows in 5268 pages for object 'cr_expense_data'.
DBCC results for 'SW_DS_MTDLY_ECP_PRISM_FINAL'.
There are 10 rows in 2 pages for object 'SW_DS_MTDLY_ECP_PRISM_FINAL'.
DBCC results for 'Weekly_Subclass_Cancellation_Sum'.
There are 622 rows in 12 pages for object 'Weekly_Subclass_Cancellation_Sum'.
DBCC results for 'mlehn.MLEHN_PMT_ADDRESS'.
There are 63 rows in 1 pages for object 'mlehn.MLEHN_PMT_ADDRESS'.
DBCC results for 'weekly_sale_lytop20qtd'.
There are 293 rows in 10 pages for object 'weekly_sale_lytop20qtd'.
DBCC results for 'SW_FOR10'.
There are 100085 rows in 1934 pages for object 'SW_FOR10'.
DBCC results for 'Luc_top20_Invoices_Units_Step3'.
There are 29017 rows in 1382 pages for object 'Luc_top20_Invoices_Units_Step3'.
DBCC results for 'SW_DS_YESTERDAYS_SALE_ECP_PRISM'.
There are 6 rows in 2 pages for object 'SW_DS_YESTERDAYS_SALE_ECP_PRISM'.
DBCC results for 'SW_DS_QTD_ECP_PRISM_FINAL'.
There are 12 rows in 2 pages for object 'SW_DS_QTD_ECP_PRISM_FINAL'.
DBCC results for 'ML_FAX_FG09_Fg10'.
There are 3587 rows in 54 pages for object 'ML_FAX_FG09_Fg10'.
DBCC results for 'DOMC_MASTERRATER'.
There are 1593 rows in 35 pages for object 'DOMC_MASTERRATER'.
DBCC results for 'DOM_BOL_S16A'.
There are 13785 rows in 657 pages for object 'DOM_BOL_S16A'.
DBCC results for 'DOMB_LOCATIONS'.
There are 15 rows in 1 pages for object 'DOMB_LOCATIONS'.
DBCC results for 'ML_PMT_ADDR_MISS'.
There are 126 rows in 5 pages for object 'ML_PMT_ADDR_MISS'.
DBCC results for 'LEmond.Danville_Rancho$'.
There are 191 rows in 17 pages for object 'LEmond.Danville_Rancho$'.
DBCC results for 'Luc_Top20_Invoices_Units_Sum_Total'.
There are 20 rows in 1 pages for object 'Luc_Top20_Invoices_Units_Sum_Total'.
DBCC results for 'SW_DS_MTD_ECP_PRISM'.
There are 11 rows in 2 pages for object 'SW_DS_MTD_ECP_PRISM'.
DBCC results for 'SW_DS_QTDLY_ECP_PRISM_FINAL'.
There are 10 rows in 1 pages for object 'SW_DS_QTDLY_ECP_PRISM_FINAL'.
DBCC results for 'TEMP_W4'.
There are 307 rows in 10 pages for object 'TEMP_W4'.
DBCC results for 'LUC_DAILY_FLASH_BOOKED_NET_SUM_60DAYS'.
There are 81232 rows in 5084 pages for object 'LUC_DAILY_FLASH_BOOKED_NET_SUM_60DAYS'.
DBCC results for 'Weekly_Sales_Sublcass_top20_CANCELLATIONS'.
There are 3315 rows in 30 pages for object 'Weekly_Sales_Sublcass_top20_CANCELLATIONS'.
DBCC results for 'DOM_BOL_S16B'.
There are 13785 rows in 657 pages for object 'DOM_BOL_S16B'.
DBCC results for 'VP_DETAIL_DL_TEMP'.
There are 67047 rows in 988 pages for object 'VP_DETAIL_DL_TEMP'.
DBCC results for 'DOM_JUMBO_BOL_TOT'.
There are 92 rows in 1 pages for object 'DOM_JUMBO_BOL_TOT'.
DBCC results for 'ML_FAX_ALL'.
There are 14999 rows in 256 pages for object 'ML_FAX_ALL'.
DBCC results for 'Luc_Top20_Report'.
There are 20 rows in 1 pages for object 'Luc_Top20_Report'.
DBCC results for 'SW_DS_MTDLY_ECP_PRISM'.
There are 10 rows in 2 pages for object 'SW_DS_MTDLY_ECP_PRISM'.
DBCC results for 'SW_DS_YTD_ECP_PRISM_FINAL'.
There are 12 rows in 2 pages for object 'SW_DS_YTD_ECP_PRISM_FINAL'.
DBCC results for 'TEMP_W41'.
There are 446 rows in 14 pages for object 'TEMP_W41'.
DBCC results for 'DOMC_WHSE_RANK'.
There are 1 rows in 1 pages for object 'DOMC_WHSE_RANK'.
DBCC results for 'WEEKLY_SUBCLASS_CANCEL_CHART'.
There are 432 rows in 4 pages for object 'WEEKLY_SUBCLASS_CANCEL_CHART'.
DBCC results for 'FPR101_Compare_Report'.
There are 68426 rows in 22814 pages for object 'FPR101_Compare_Report'.
DBCC results for 'RM_JANUARY_2007'.
There are 7563 rows in 281 pages for object 'RM_JANUARY_2007'.
DBCC results for 'WEEKLY_SUBCLASS_BF_CAN'.
There are 2343 rows in 18 pages for object 'WEEKLY_SUBCLASS_BF_CAN'.
DBCC results for 'SW_DS_YTDLY_ECP_PRISM_FINAL'.
There are 11 rows in 2 pages for object 'SW_DS_YTDLY_ECP_PRISM_FINAL'.
DBCC results for 'Weekly_Subclass_SalesChart'.
There are 224 rows in 5 pages for object 'Weekly_Subclass_SalesChart'.
DBCC results for 'FPR101_Compare_Report_Final'.
There are 68426 rows in 9885 pages for object 'FPR101_Compare_Report_Final'.
DBCC results for 'ML_FAX_aLL_final'.
There are 231 rows in 7 pages for object 'ML_FAX_aLL_final'.
DBCC results for 'Temp_Booking_dl'.
There are 166084 rows in 6681 pages for object 'Temp_Booking_dl'.
DBCC results for 'TEMP_W411'.
There are 454 rows in 15 pages for object 'TEMP_W411'.
DBCC results for 'Value_Test_Freight_Data1_BolSum'.
There are 51332 rows in 634 pages for object 'Value_Test_Freight_Data1_BolSum'.
DBCC results for 'Archive_Holds'.
There are 9182 rows in 185 pages for object 'Archive_Holds'.
DBCC results for 'TOP100_EDI'.
There are 100 rows in 4 pages for object 'TOP100_EDI'.
DBCC results for 'FREIGHT_FOR13_AVG_DISC'.
There are 1 rows in 1 pages for object 'FREIGHT_FOR13_AVG_DISC'.
DBCC results for 'LUC_ADHOC_SUBCLASS_04_Open'.
There are 689 rows in 28 pages for object 'LUC_ADHOC_SUBCLASS_04_Open'.
DBCC results for 'FPR101_COMPARE_REPORT_FINAL_ARCHIVE'.
There are 83792 rows in 11976 pages for object 'FPR101_COMPARE_REPORT_FINAL_ARCHIVE'.
DBCC results for 'LUC_adhoc_joe'.
There are 84643 rows in 1924 pages for object 'LUC_adhoc_joe'.
DBCC results for 'TEMP_W5'.
There are 5814 rows in 183 pages for object 'TEMP_W5'.
DBCC results for 'DW_Sales2006'.
There are 299 rows in 2 pages for object 'DW_Sales2006'.
DBCC results for 'INVENTORY_SUM'.
There are 209426 rows in 2411 pages for object 'INVENTORY_SUM'.
DBCC results for 'ORDERS_CODE9'.
There are 453 rows in 17 pages for object 'ORDERS_CODE9'.
DBCC results for 'SKU_ABC'.
There are 17627 rows in 114 pages for object 'SKU_ABC'.
DBCC results for 'Sales_History_2007'.
There are 230381 rows in 46083 pages for object 'Sales_History_2007'.
DBCC results for 'DOM_BOL_s5rk'.
There are 367500 rows in 8971 pages for object 'DOM_BOL_s5rk'.
DBCC results for 'RM_DECEMBER_2006'.
There are 7262 rows in 269 pages for object 'RM_DECEMBER_2006'.
DBCC results for 'DW_INVENTORY_AVAILABILITY'.
There are 37253 rows in 217 pages for object 'DW_INVENTORY_AVAILABILITY'.
DBCC results for 'temp_prod'.
There are 29640 rows in 682 pages for object 'temp_prod'.
DBCC results for 'Weekly_Subclass_Booking_Sum'.
There are 391 rows in 11 pages for object 'Weekly_Subclass_Booking_Sum'.
DBCC results for 'DOMC_BOL_FREIGHTCALC'.
There are 1 rows in 1 pages for object 'DOMC_BOL_FREIGHTCALC'.
DBCC results for 'INVENTORY_CANADIAN_LOCS'.
There are 44 rows in 1 pages for object 'INVENTORY_CANADIAN_LOCS'.
DBCC results for 'TEMP_SALES_2004_2007'.
There are 391800 rows in 17811 pages for object 'TEMP_SALES_2004_2007'.
DBCC results for 'FREIGHT_MINCHG'.
There are 1 rows in 1 pages for object 'FREIGHT_MINCHG'.
DBCC results for 'LUC_DAILY_FLASH_CANCEL'.
There are 20882 rows in 280 pages for object 'LUC_DAILY_FLASH_CANCEL'.
DBCC results for 'FRM10'.
There are 183488 rows in 6335 pages for object 'FRM10'.
DBCC results for 'DOMB_NUMDAYS'.
There are 1 rows in 1 pages for object 'DOMB_NUMDAYS'.
DBCC results for 'FREIGHT_WHSE'.
There are 15 rows in 1 pages for object 'FREIGHT_WHSE'.
DBCC results for 'SW_DS_QTDLY_ECP_PRISM'.
There are 11 rows in 2 pages for object 'SW_DS_QTDLY_ECP_PRISM'.
DBCC results for 'ml_cancel_dollar_reason_desc'.
There are 1723 rows in 31 pages for object 'ml_cancel_dollar_reason_desc'.
DBCC results for 'Temp_can_dl'.
There are 7530 rows in 163 pages for object 'Temp_can_dl'.
DBCC results for 'mlehn.MLEHN_FG09_FG10_ADDRESS'.
There are 643 rows in 3 pages for object 'mlehn.MLEHN_FG09_FG10_ADDRESS'.
DBCC results for 'INVENTORY_CANADIAN_EXRATE'.
There are 1 rows in 1 pages for object 'INVENTORY_CANADIAN_EXRATE'.
DBCC results for 'Luc_Top20_Step1'.
There are 132991 rows in 2342 pages for object 'Luc_Top20_Step1'.
DBCC results for 'DOM_BOL_MAR'.
There are 122100 rows in 4218 pages for object 'DOM_BOL_MAR'.
DBCC results for 'cr_expense_group'.
There are 28 rows in 1 pages for object 'cr_expense_group'.
DBCC results for 'SHIPPING_INFO_SHELDON'.
There are 9706 rows in 157 pages for object 'SHIPPING_INFO_SHELDON'.
DBCC results for 'SW_DS_QTD_ECP_PRISM'.
There are 13 rows in 2 pages for object 'SW_DS_QTD_ECP_PRISM'.
DBCC results for 'Calendar_2007'.
There are 365 rows in 3 pages for object 'Calendar_2007'.
DBCC results for 'ML_fg09_fg10_ADDR_MISS'.
There are 2 rows in 1 pages for object 'ML_fg09_fg10_ADDR_MISS'.
DBCC results for 'LUC_Top20_Step2'.
There are 2465 rows in 42 pages for object 'LUC_Top20_Step2'.
DBCC results for 'LEmond.Sku_Top20$'.
There are 45 rows in 1 pages for object 'LEmond.Sku_Top20$'.
DBCC results for 'FDP05_all'.
There are 3714 rows in 39 pages for object 'FDP05_all'.
DBCC results for 'DOMB_DATES'.
There are 1 rows in 1 pages for object 'DOMB_DATES'.
DBCC results for 'LUC_DAILY_FLASH_INVENTORY'.
There are 9690641 rows in 364196 pages for object 'LUC_DAILY_FLASH_INVENTORY'.
DBCC results for 'DOM_BOL_S9W1'.
There are 367500 rows in 18388 pages for object 'DOM_BOL_S9W1'.
DBCC results for 'Orders_Code9_Report'.
There are 453 rows in 10 pages for object 'Orders_Code9_Report'.
DBCC results for 'SW_DS_YTD_ECP_PRISM'.
There are 13 rows in 1 pages for object 'SW_DS_YTD_ECP_PRISM'.
DBCC results for 'ML_XPDEX_Sold_to_prices'.
There are 0 rows in 1 pages for object 'ML_XPDEX_Sold_to_prices'.
DBCC results for 'cradtke.cr_sdm_inv'.
There are 14780 rows in 296 pages for object 'cradtke.cr_sdm_inv'.
DBCC results for 'cr_sdm_combined'.
There are 28296 rows in 838 pages for object 'cr_sdm_combined'.
DBCC results for 'Open_Orders_Status_10_Tape_Film'.
There are 3313 rows in 165 pages for object 'Open_Orders_Status_10_Tape_Film'.
DBCC results for 'LEmond.Luc_47Skus_Top100'.
There are 100 rows in 3 pages for object 'LEmond.Luc_47Skus_Top100'.
DBCC results for 'Open_Order_Pastdue_Report'.
There are 3008 rows in 150 pages for object 'Open_Order_Pastdue_Report'.
DBCC results for 'SW_DS_YTDLY_ECP_PRISM'.
There are 12 rows in 2 pages for object 'SW_DS_YTDLY_ECP_PRISM'.
DBCC results for 'SE_CUSTOMERS_M'.
There are 3 rows in 1 pages for object 'SE_CUSTOMERS_M'.
DBCC results for 'Open_Order_Report'.
There are 11686 rows in 532 pages for object 'Open_Order_Report'.
DBCC results for 'SW_DS_FINAL_SUM_ECP'.
There are 17 rows in 2 pages for object 'SW_DS_FINAL_SUM_ECP'.
DBCC results for 'TEST_bin'.
There are 2863 rows in 40 pages for object 'TEST_bin'.
DBCC results for 'SKU_AVGWGHTSUBC'.
There are 39 rows in 1 pages for object 'SKU_AVGWGHTSUBC'.
DBCC results for 'cr_sdm_item'.
There are 38065 rows in 1530 pages for object 'cr_sdm_item'.
DBCC results for 'Open_Schedules_Query'.
There are 2358 rows in 37 pages for object 'Open_Schedules_Query'.
DBCC results for 'cr_sdm_prodgrp_invsls'.
There are 23300 rows in 207 pages for object 'cr_sdm_prodgrp_invsls'.
DBCC results for 'Luc_47Skus_Top100_Skulist'.
There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Skulist'.
DBCC results for 'LJ_FISCAL_DATE'.
There are 1 rows in 1 pages for object 'LJ_FISCAL_DATE'.
DBCC results for 'LUC_DAILY_FLASH_CANCEL_SUM'.
There are 2827 rows in 222 pages for object 'LUC_DAILY_FLASH_CANCEL_SUM'.
DBCC results for 'temp_sh2'.
There are 171165 rows in 2063 pages for object 'temp_sh2'.
DBCC results for 'DOMA_INVENTORY'.
There are 23816 rows in 505 pages for object 'DOMA_INVENTORY'.
DBCC results for 'cr_sdm_orhdr'.
There are 19793 rows in 2234 pages for object 'cr_sdm_orhdr'.
DBCC results for 'SW_DS_YESTERDAY_FLEX'.
There are 7 rows in 2 pages for object 'SW_DS_YESTERDAY_FLEX'.
DBCC results for 'ML_CANCELLATION'.
There are 1495 rows in 61 pages for object 'ML_CANCELLATION'.
DBCC results for 'Sales_History_Driver'.
There are 816914 rows in 163383 pages for object 'Sales_History_Driver'.
DBCC results for 'SW_DS_BOOKED_ECP_PRISM'.
There are 8 rows in 1 pages for object 'SW_DS_BOOKED_ECP_PRISM'.
DBCC results for 'cr_sdm_ordet'.
There are 30303 rows in 2339 pages for object 'cr_sdm_ordet'.
DBCC results for 'SW_DS_MTD_FLEX'.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0.
There are 10 rows in 2 pages for object 'SW_DS_MTD_FLEX'.
DBCC results for 'Claim_Weekly'.
There are 18796 rows in 227 pages for object 'Claim_Weekly'.
DBCC results for 'LUC_APRIL2007'.
There are 4080 rows in 51 pages for object 'LUC_APRIL2007'.
DBCC results for 'DOMB_MINORDDATE'.
There are 1 rows in 1 pages for object 'DOMB_MINORDDATE'.
DBCC results for 'cr_openord_test'.
There are 1170 rows in 16 pages for object 'cr_openord_test'.
DBCC results for 'cr_sdm_cust1'.
There are 4417 rows in 108 pages for object 'cr_sdm_cust1'.
DBCC results for 'asp_data'.
There are 325752 rows in 23268 pages for object 'asp_data'.
DBCC results for 'ml_cancel_dollar'.
There are 731 rows in 7 pages for object 'ml_cancel_dollar'.
DBCC results for 'GERRY_APRIL_2007'.
There are 1915 rows in 37 pages for object 'GERRY_APRIL_2007'.
DBCC results for 'DOMA_INVENTORY_SUM'.
There are 7408 rows in 48 pages for object 'DOMA_INVENTORY_SUM'.
DBCC results for 'CLAIMS_AUDIT_TRAIL'.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 41. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 41. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 55. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 55. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 62. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 62. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 104. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 104. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 111. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 111. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 118. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 118. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 126. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 10. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 10. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 28. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 28. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 31. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 31. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 61. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 61. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764331), row 66. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764331), row 66. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 94. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 47. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 47. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 78. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 78. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 122. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 122. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 49. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 49. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 78. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 78. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 113. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 113. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 2. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 72. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 72. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 87. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 87. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 37. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 37. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 112. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 112. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 75. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 75. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 64. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 64. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 88. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 88. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 108. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 108. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 56. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 56. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 97. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 97. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 119. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 119. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764340), row 0. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764340), row 0. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 2. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 39. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 39. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 48. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 48. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 56. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 56. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 72. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 72. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 101. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 101. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 115. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 115. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 1. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 1. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 37. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 37. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 44. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 44. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 89. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 89. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 98. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 98. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 7. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 14. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 14. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 40. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 40. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 54. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 57. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 57. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 77. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 93. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 93. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 13. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 13. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 33. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 33. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 52. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 52. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 91. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 91. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 108. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 108. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line

View 11 Replies View Related

Transact SQL :: Is Table Will Be Extracted When Querying To DB Views

Sep 15, 2015

I wonder how the query will be executed when querying to views.Is database engine will be extract the tables that are used to create the view and query for the result ?

View 5 Replies View Related

Transact SQL :: Combine Two Views Into One Statement Or One View

Oct 15, 2015

I'd like to get results from ZTest_Contract being my result set, and would like to combine the subquery (which gets the Max) into the primary view ZTest_Contract.

CREATE VIEW [dbo].[ZTest_Contract] AS
Select
M.CUSTNMBR,
M.ADRSCode,
M.Contract_number,
M.MaxWSCONTSQ,
M.Equipment_id,

[Code] ......

View 3 Replies View Related

Transact SQL :: Output Views In Dependency Order

Jun 25, 2015

Using t-sql, how to list all views in dependency order? I'm trying to script out the creation of views, but need to make sure they are in the correct order when i execute them. 

View 2 Replies View Related

Digital Signature

Oct 30, 2006

Hi I have created a Client/Server application. The Client connects remotely to the SQL 2005 server using thier unique user name and password.

The client application allows the users to update a form.

I need to add to the database a digital signature for that user when they update that form. This is intended to be a replacement for a physical signature that would appear on a paper form.

View 1 Replies View Related

Signature Error

Jul 18, 2007

I'm putting together a demo for signing a stored procedure and I'm coming up blank as to why it is failing. Below is the code:



USE master

GO

--Create a pair of logins

CREATE LOGIN TestLogin WITH PASSWORD = 'P@55w0rd'

GO

CREATE LOGIN DummyLogin WITH PASSWORD = 'P@55w0rd'

GO

--Create a demo database

CREATE DATABASE SignatureDemo

GO

USE SignatureDemo

GO

--Create a low privileged user in the database

CREATE USER TestLogin FOR LOGIN TestLogin

GO

CREATE USER DummyLogin FOR LOGIN DummyLogin

GO

CREATE SCHEMA Test AUTHORIZATION DummyLogin

GO

--Create a dummy table and add data to it

CREATE TABLE Test.MyTable

(ID INT IDENTITY(1,1),

TestVal VARCHAR(10) NOT NULL)

GO

INSERT INTO Test.MyTable

(TestVal)

VALUES ('Test1')

GO

INSERT INTO Test.MyTable

(TestVal)

VALUES ('Test2')

GO

--Create a procedures to access test table

CREATE PROCEDURE Test.asp_Proc1

AS

SELECT ID, TestVal FROM Test.MyTable

GO

CREATE PROCEDURE dbo.asp_SignatureTest

AS

EXEC Test.asp_Proc1

GO

GRANT EXECUTE ON dbo.asp_SignatureTest TO TestLogin

GO

--Verify that TestLogin can not select from the table

EXECUTE AS LOGIN = 'TestLogin'

EXEC asp_SignatureTest

REVERT

GO

--Create a database master key

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P@55w0rd'

GO

CREATE CERTIFICATE TestCert WITH SUBJECT = 'Test Certificate'

GO

--Sign the procedure, remove the private key, and backup to a file

ADD SIGNATURE TO Test.asp_Proc1 BY CERTIFICATE TestCert

GO

ALTER CERTIFICATE TestCert REMOVE PRIVATE KEY

GO

BACKUP CERTIFICATE TestCert TO FILE = 'TestCert.cer'

GO

--Create a user in the database mapped to the certificate

CREATE USER CertLogin FROM CERTIFICATE TestCert

GO

--Grant permissions to the user

GRANT EXECUTE ON Test.asp_Proc1 TO CertLogin

GO

--Verify that TestLogin can now select from the table (I'm still receiving an execute permissions error on Test.asp_Proc1 for some reason.)

EXECUTE AS LOGIN = 'TestLogin'

EXEC asp_SignatureTest

REVERT

GO

USE master

GO

DROP DATABASE SignatureDemo

DROP LOGIN TestLogin

DROP LOGIN DummyLogin

DROP LOGIN CertLogin

DROP CERTIFICATE TestCert

GO

View 3 Replies View Related

Fast, Consistent Way To Bulk Insert?

Oct 17, 2006

I'm looking for a way to insert 50k records into a SQL Server table, and need to get it done faster. right now using BULK INSERT takes 5-10 seconds, but faster would be better, and even better if it were a consistent amount of time.

I've heard of DTS but don't know quite how to use it - would be offer any performance gains? any clue what the bottleneck is for BULK INSERT? hard drive speed? amount of RAM (this was on a 512mb machine)? parsing the fields?

thanks for any ideas.

View 7 Replies View Related

Maintain A Consistent DB Connection Through Application Lifecycle

Nov 10, 2006

Hey everyone, I'm new to .NET and I've recently inheirited a rather large and busy asp.net website.  I was asked to add a testimonials section on each page that will randomly pull a testimonial out of the db.  This is fine, however, I'm getting random errors about the DB connection either being closed or connecting.  Here is the code for the testimonials class: 1 public SqlDataReader GetTestimonials(ref SqlDataReader reader, int iCatID, string sLanguageType)2 {3 SqlCommand cmd = new SqlCommand("sp_DVX_Testimonials_Fetch", Connection);4 cmd.CommandType = CommandType.StoredProcedure;5
6 cmd.Parameters.Add(new SqlParameter("@Cat_ID", iCatID));7 cmd.Parameters.Add(new SqlParameter("@LanguageType", sLanguageType));8
9 reader = cmd.ExecuteReader();10
11 return reader;12 } I know this isn't the best way to do this (especially for each page[this site averages about 1000 hits a day]), so I was wondering was--is there a way to maintain a single DB connection that's set up in the Application_Start that will maintain the connection so I don't have to worry about this error.  If not, does anyone and any ideas as to what would help? Thanks in advance! 

View 4 Replies View Related

The Value You Entered Is Not Consistent With The Data Type Of The Column.

Jun 6, 2005

Hi..

I am trying to add new record to any table in my database.
But I can't.

I am tryting to add a value (1500 character) and it gives the message below

"The value you entered is not consistent with the data type of the column."



I have tried alot.
The result is my columns in my table accept maximum 900 character.

But the type of my column I try to add a value is text..

I am too angry with SQL

Please help

View 10 Replies View Related

Retrieving Digital Signature From Memory?

Apr 27, 2006

Would like to use the digital signature (i.e. PKI) from a smart card to authorize a PDF document. Is it possible to retrieve the PKI from Windows once its read in via the smart card using some sort of C++ or Java API call to apply it to the PDF form?

View 1 Replies View Related

RMO ERROR : No Signature Was Present In The Subject.

Jun 7, 2007

Hi !

I have such a message after trying to do replication with SQL Server 2005 using custom Business Logic Handler for a Merge Article (RMO Programming).

Message Replication-Replication Merge Subsystem: agent 'job' failed. No signature was present in the subject.

I am using C# with RMO, merge replication.

Any ideas ? How to solve this problem ?

Thanks.

View 2 Replies View Related

The Value You Entered Is Not Consistent With The Data Type Or Length Of The Column

Feb 3, 2001

I keep getting this error:

'The value you entered is not consistent with the data type or length of the column'

when trying to enter data into a feild, the feild type is char and the length
is 100 i'm entering text 3 words long but no where near a 100 characters long
any one know why this is happening?

View 1 Replies View Related

Access To Table Blocked Signature Is Not Valid

Aug 3, 2007

I created sqlexpress database and .net app, everything was fine on my local machine.

When I moved the app to my server, I detached the database with SMSS express, moved the MDF file over along with the app files and I attached to the database with SSMS to make sure everything went over ok but when I try to open a table I get the error,


SQL Execution Error
Executed statement: Select x, x, x, x,x from tblFile
Error source: .Net SqlClient Data Provider
Error Message: Access to table dbl.tblFile is blocked because the signature is not valid.

I can open the stored procedures fine by choosing modify from the context menu.

Any ideas here?

View 1 Replies View Related

Nested Procedures &&amp; Using Signature Based Security

May 17, 2006

I am currently developing a project that requires a server level permission for one stored procedure (ALTER ANY LOGIN)

To this effect, I plan to create a certificate, sign the stored procedure with it, import the certificate into the master DB and assign privileges.

I also understand that modification to the code invalidates the signature (after all thats the point of signing something).

But what about user defined functions and stored procedures referenced by the signed procedure? Does SQL server follow the dependancy chain and include referenced procedures in the signature? Or does the privilege assigned to the certificate not apply when the nested procedure is executed?

If this is not the case couldn't a restricted database user just alter a nested stored procedure they have been granted ALTER access to and make themselves SA or something?

So to sum up, do you have to duplicate the functionality of otherwise nested procedures into a certificate signed procedure to protect server security?





View 3 Replies View Related

Converting Some VBA Code To SQL Function

Sep 6, 2006

Hi,
I'm new to this SQL thing, and I need some help with s stored procedure/function.
First, the scenario:
We are a social service agency, and like all such organizations, we have requirements for perodic reports about our clients. There are lots of them, but if I figure how to do one, I think I can apply the theory to the others.

First, this is some sample VBA code I've tested and which proved satisfactory for the basic task, just for a form. It is passed a date (dteDOP), then adds 3 months, (quarterly report)and loops until it exceeds the current date, thus generating the a due date for the the next report.

'initialize the due date
dteDueDate = dteDOP

'Add quarterly intervals, starting with (DOP + 3 months), until
'you exceed today's date
Do Until dteDueDate > Date
dteDueDate = DateAdd("m", 3, dteDueDate)
Loop
'set a text box to the next due date after today
Me.txtNextQuarDue = dteDueDate

Obviously, this isn't really a function at the moment, but it worked as a test of the logic, with instantly visible results.

This works, but I'd like to do it on the server end, so I can send out notifications. How would this be accomplished as an SQL stored procedure/function? Obviously, for that I'll need to again do a comparison of the current date with the due date for timing concerns, but that should be relatively simple. Also, I know that the '@' symbol is somehow part of variables in SQL Procedures/functions, could you give me a very basic explanation of this, especially the difference between @xxx and @@xxx?

Thanks in advance,
Stephen

-----------------------------------------------
-----------------------------------------------
Gary Getsum: What happened to my mule?
DM: It's dead; It got stung by a giant wasp.
Gary: Can't I heal it?
DM: I'm sorry, I know you were fond of the mule, but it just got attacked by a wasp the size of a Volkswagen!
Gary: So?
DM: Dude, look- you're going to have to carry all your own treasure now... Your mule gives new meaning to the term "Puff Daddy".

View 17 Replies View Related

Errors In Function Code

Feb 2, 2007

Hi,

I'm pretty new to SQL and I'm having trouble with a function, probably just syntax. I'm trying to consolidate several rows of data into a single row text field.
The calling program can use views but not functions so I need to get a table into a view with the consolidated lines.

Also, I would think this could be consolidated to a single view that calls one function. Is that possible, how would I do it?

Thanks for any help,
Steve


VIEW WHERE DATA COMES FROM:
CUST_ORDER_ID | LINE_TEXT
number1 | first line item text
number1 | Second line item text
number1 | Third line item text
number2 | first line item text
number2 | Second line item text
...


VIEW I WANT:
CUST_ORDER_ID | CO_LINES_TEXT
number1 | Second line item text 'crlf' Third Line item text
number2 | Second line item text


FUNCTION CODE: This is the function code with errors

CREATE FUNCTION dbo.tvf_NC_CO_LINES_TEXT (@ORDER_ID VARCHAR(20))

RETURNS @NC_CO_LINES TABLE
(
CUST_ORDER_ID VARCHAR(20) PRIMARY KEY NOT NULL,
CO_LINES_TEXT VARCHAR(1000) NULL
)
AS
BEGIN
DECLARE @COLinesString VARCHAR(1000);
SET @ORDER_ID = CUST_ORDER_ID;
SELECT @COLinesString = COALESCE(@COLinesString + Char(13) + Char(10), '') + LINE_STRING
FROM NC_CO_LINES_STRING
WHERE NC_CO_LINES_STRING.CUST_ORDER_ID = @ORDER_ID
SET @COLinesString = CO_LINES_TEXT
RETURN
END;

GO


ERROR MESSAGES:
Msg 207, Level 16, State 1, Procedure tvf_NC_CO_LINES_TEXT, Line 16
Invalid column name 'CUST_ORDER_ID'.
Msg 207, Level 16, State 1, Procedure tvf_NC_CO_LINES_TEXT, Line 20
Invalid column name 'CO_LINES_TEXT'.


VIEW CODE:
SELECT dbo.CUST_ORDER_LINE.CUST_ORDER_ID, CAST(CAST(dbo.CUST_ORDER_LINE.ORDER_QTY AS INT) AS VARCHAR(2))
+ ' ' + dbo.CUST_ORDER_LINE.PART_ID + ' ' + dbo.PART.DESCRIPTION AS LINE_STRING
FROM dbo.CUST_ORDER_LINE INNER JOIN
dbo.PART ON dbo.CUST_ORDER_LINE.PART_ID = dbo.PART.ID
WHERE (dbo.CUST_ORDER_LINE.LINE_NO > 1)

Steve Bermes
Novae Corp.

View 2 Replies View Related

Need Transact-SQL Code

Aug 21, 2006

Is there any transact code for sql server that I can type out to view all of the relationship Definments of the current database or even an individual table.

View 4 Replies View Related

Stop Spell Check Of Outlook 2003 Signature

Jan 12, 2007

Hi All,



I have a user who's spell check always checks her signature - is there a way to prevent this? I know how to stop it on an individual email, but I want every email she creates to automatically NOT check the signiture file.

Running - Exchange 2003 and Outlook 2003.



Thanks!

View 1 Replies View Related

How To Ensure Date Are Handle As It Should

Jan 21, 2008

I was wondering if SQL SERVER 2005 has a function to specify what date format you are using ex: in a where clause.

I'm looking for something like this

WHERE FORMAT(my_date, "yyyy/mm/dd")<= @my_date

So what's in red is what I'm looking for.

Thanks in advance!

Or Tho

View 14 Replies View Related

Help With TSQL Stored Procedure - Error-Exec Point-Procedure Code

Nov 6, 2007

I am building a stored procedure that changes based on the data that is available to the query. See below.
The query fails on line 24, I have the line highlighted like this.
Can anyone point out any problems with the sql?

------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
This is the error...


Msg 8114, Level 16, State 5, Procedure sp_SearchCandidatesAdvanced, Line 24

Error converting data type varchar to numeric.

------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
This is the exec point...


EXEC [dbo].[sp_SearchCandidatesAdvanced]

@LicenseType = 4,

@PositionType = 4,

@BeginAvailableDate = '10/10/2006',

@EndAvailableDate = '10/31/2007',

@EmployerLatitude = 29.346675,

@EmployerLongitude = -89.42251,

@Radius = 50

GO

------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
This is the STORED PROCEDURE...


set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go



ALTER PROCEDURE [dbo].[sp_SearchCandidatesAdvanced]

@LicenseType int = 0,

@PositionType int = 0,

@BeginAvailableDate DATETIME = NULL,

@EndAvailableDate DATETIME = NULL,

@EmployerLatitude DECIMAL(10, 6),

@EmployerLongitude DECIMAL(10, 6),

@Radius INT


AS


SET NOCOUNT ON


DECLARE @v_SQL NVARCHAR(2000)

DECLARE @v_RadiusMath NVARCHAR(1000)

DECLARE @earthRadius DECIMAL(10, 6)


SET @earthRadius = 3963.191


-- SET @EmployerLatitude = 29.346675

-- SET @EmployerLongitude = -89.42251

-- SET @radius = 50


SET @v_RadiusMath = 'ACOS((SIN(PI() * ' + @EmployerLatitude + ' / 180 ) * SIN(PI() * p.CurrentLatitude / 180)) + (COS(PI() * ' + @EmployerLatitude + ' / 180) * COS(PI() * p.CurrentLatitude / 180) * COS(PI()* p.CurrentLongitude / 180 - PI() * ' + @EmployerLongitude + ' / 180))) * ' + @earthRadius




SELECT @v_SQL = 'SELECT p.*, p.CurrentLatitude, p.CurrentLongitude, ' +

'Round(' + @v_RadiusMath + ', 0) AS Distance ' +

'FROM ProfileTable_1 p INNER JOIN CandidateSchedule c on p.UserId = c.UserId ' +

'WHERE ' + @v_RadiusMath + ' <= ' + @Radius


IF @LicenseType <> 0

BEGIN

SELECT @v_SQL = @v_SQL + ' AND LicenseTypeId = ' + @LicenseType

END


IF @PositionType <> 0

BEGIN

SELECT @v_SQL = @v_SQL + ' AND Position = ' + @PositionType

END


IF LEN(@BeginAvailableDate) > 0

BEGIN

SELECT @v_SQL = @v_SQL + ' AND Date BETWEEN ' + @BeginAvailableDate + ' AND ' + @EndAvailableDate

END


--SELECT @v_SQL = @v_SQL + 'ORDER BY CandidateSubscriptionEmployerId DESC, CandidateFavoritesEmployerId DESC, Distance'


PRINT(@v_SQL)

EXEC(@v_SQL)


-----------------------------------------------------------------------------------------------------------------

View 4 Replies View Related

Custom Code Error With VB Function

Apr 26, 2007

Hello, I am about out of hair from pulling it out. If someone could please show me what I'm doing wrong I would really appreciate it. I have this function for a SSRS 2005 report:



Public Function funAdditions(pFields As Fields) As Double
if pFields !FA00902_AMOUNT.Value > 0 and
pFields !FA00902_TRANSACCTTYPE.Value = 3 and
pFields !FA00902_DEPRTODATE.Value > Parameters!BeginDate.Value and
pFields !FA00902_DEPRTODATE.Value <= Parameters!CutOffDate.Value and NOT
instr(pFields !FA00902_SOURCDOC.Value, "FACHG")=1
then return pFields !FA00902_AMOUNT.Value
end
else if pFields !FA00902_TRANSACCTTYPE.Value = 3 and
pFields !FA00902_DEPRTODATE.Value > Parameters!BeginDate.Value and
pFields !FA00902_DEPRTODATE.Value <= Parameters!CutOffDate.Value and
instr(pFields !FA00902_SOURCDOC.Value, "FACHG")=1
then return pFields !FA00902_AMOUNT.Value
end
End Function



...and after much research cannot figure out the solution to this error:

[rsCompilerErrorInCode] There is an error on line 1 of custom code: [BC30201] Expression expected.



I'm new to SSRS so is there a syntax error I'm missing?



Thanks in advance,

Buster

View 1 Replies View Related

Transact Sql 2005 Code Changes

Aug 28, 2006

Have there been any updates to sql 2005 transact codes, because I tried to use some transact code that I used in sql 8.0 and in sql 2005 on the same database and it did not work.

Here is the code I used



Select p.pub_name,
e.fname + ' ' + e.lname "Employee name",
e.job_lvl


from publishers P inner join employee e on p.pub_id = e.pub_id
where e.job_lvl > 200



View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved