Re: Error converting data type varchar to numeric - Database Discussion Boards

First Prev Next

Re: How to create an audit table?

jschell14-Jul-14 9:05

jschell

14-Jul-14 9:05

Eddy Vluggen wrote:
Try the one I painted.

You have a customer with two different employees. Both of them call the service desk at 8:50am on Tuesday June 6th. Both want to do wildly different things to the same thing.

This means the customer has tasked them both with the same task. And that both reached wildly different outcomes with regard to what should happen.

No that doesn't seem like a scenario which is likely to occur and in fact is wildly unlikely to occur. Thus prioritizing this even to the extent of writing the requirement much less implementing it seems very unlikely.

Eddy Vluggen wrote:
But then again, we already noted that adding a record, as opposed to editing one, would solve that.

But again that is not the point. There are valid, probable and needful reasons for adding a record versus update that have nothing to do with the highly likely scenario that you have posited.

Re: How to create an audit table?

jschell11-Jul-14 9:11

jschell

11-Jul-14 9:11

Mycroft Holmes wrote:
Personally I don't consider that an audit solution, I say solution because audit is a whole lot of objects.

However that should depend on business needs. If you need to track every change in the system then something like your solution is required.

But there can be a much lower need so less of a solution might be sufficient.

Mycroft Holmes wrote:
In a vast number of years building LOB apps and some of them transactional I have never been hit by the condition of 2 users editing the same record

I have seen a number of developers and QA people come up with that situation.

Took me quite a few years to realize that I should start asking them what their business case was for the scenario.

Re: How to create an audit table?

Mycroft Holmes11-Jul-14 14:19

Mycroft Holmes

11-Jul-14 14:19

jschell wrote:
However that should depend on business needs

Always, this is the mantra I repeat at the start of every requirements meeting, I want it tattoo'd on the foreheads of every BA, I want "it is your job to interpret their requirements CORRECTLY" tattoo'd on their buts!

I'm old I've been doing this for a bloody long time, the number of times I have had this ~~argument~~ discussion with BAs and user are innumerable. I just hate it when I have to pound it into the head of a senior dev.

Mind you I'm delighted when they (the BAs and senior devs) come up with some novel concepts especially when they work.

Never underestimate the power of human stupidity
RAH

SQL Server Express Setup Command Line Problem

Amr Muhammed9-Jul-14 11:25

Amr Muhammed

9-Jul-14 11:25

I need to setup SQL Server Express using the command line and also make the installation unattended I tried many command lines however each one of them did not work here is the last one:

Setup.exe /ADDCURRENTUSERASSQLADMIN="True" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVIC" /AGTSVCSTARTUPTYPE="Disabled" /ASBACKUPDIR="Backup" /ASCOLLATION="Latin1_General_CI_AS" /ASCONFIGDIR="Config" /ASDATADIR="Data" /ASLOGDIR="Log" /ASPROVIDERMSOLAP="1" /ASSVCSTARTUPTYPE="Automatic" /ASTEMPDIR="Temp" /BROWSERSVCSTARTUPTYPE="Disabled" /ENABLERANU="True" /ENU="True" /ERRORREPORTING="False" /FARMADMINPORT="0" /FEATURES="SQLENGINE,REPLICATION" /FILESTREAMLEVEL="0" /HELP="False" /INDICATEPROGRESS="False" /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server\" /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server\" /INSTANCEDIR="C:\Program Files\Microsoft SQL Server\" /INSTANCEID="SQLExpress" /INSTANCENAME="SQLExpress" /ISSVCACCOUNT="NT AUTHORITY\NetworkService" /ISSVCSTARTUPTYPE="Automatic" /NPENABLED="0" /QUIET="True" /QUIETSIMPLE="False" /ROLE="AllFeatures_WithDefaults" /RSINSTALLMODE="FilesOnlyMode" /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /RSSVCSTARTUPTYPE="Automatic" /SECURITYMODE="SQL" /SQLCOLLATION="Arabic_CI_AS" /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCSTARTUPTYPE="Automatic" /SQMREPORTING="False" /TCPENABLED="0" /UIMODE="" /X86="False" /IACCEPTSQLSERVERLICENSETERMS /ACTION="Install"

But also it did not work. Could any one tell the correct syntax to install the SQL Server Express 2008 x64

Re: SQL Server Express Setup Command Line Problem

Bernhard Hiller9-Jul-14 21:11

Bernhard Hiller

9-Jul-14 21:11

Amr Muhammed wrote:
But also it did not work

That's a great statement. What was the result? Did you get any error messages? What does the log file of the installer tell you?

Re: SQL Server Express Setup Command Line Problem

Amr Muhammed11-Jul-14 3:28

Amr Muhammed

11-Jul-14 3:28

The installer every time was telling me that the installation failed and I did not know the reason however finally I got the solution the .exe package I was trying to install seems to be not complete as I download another one from microsoft site and when I tried again it worked fine.

Error converting data type varchar to numeric

Maideen Abdul Kader5-Jul-14 19:42

Maideen Abdul Kader

5-Jul-14 19:42

Hi

i have issue in stored procedure converting data type

Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type
But source table Z_tbl_Import_temp have VarChar Type

If I export data from source, I have error message

Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10
Error converting data type varchar to numeric.

Pls help to resolve this issue

Thanking you in advance

Maideen

Below is my store procedure

SQL

INSERT INTO dbo.Z_tbl_CirculationCopy_TEMP([MEMBER],[LANGUAGE],[TYPE],[PLATFORM],[CATEGORY],[MAINAREA],[STATE],[COPIES],
[MONTHNAME],[YEARNO],[REMARKS],[AVGISSUE_PAID],[AVGISSUE_FREE],[BCP_NTT],[BCP_50],[BCP_20],[BCP_20_Below],
[WP_TOTAL],[SABAH_TOTAL],[SARAWAK_TOTAL],[EM_Total])

SELECT [MEMBER],[LANGUAGE],[TYPE],[PLATFORM],[CATEGORY],[MAINAREA],[STATE],[COPIES],
[MONTHNAME],[YEARNO],[REMARKS],[AVGISSUE_PAID],[AVGISSUE_FREE],[BCP_NTT],[BCP_50],[BCP_20],[BCP_20_Below],
[WP_TOTAL],[SABAH_TOTAL],[SARAWAK_TOTAL],[EM_Total]

FROM (SELECT [MEMBER],[LANGUAGE],[TYPE],[PLATFORM],[CATEGORY],[MAINAREA],[MONTHNAME],[YEARNO],[REMARKS],
[AVGISSUE_PAID],[AVGISSUE_FREE],[BCP_NTT],[BCP_50],[BCP_20], [BCP_20_Below],
[WP_TOTAL],[SABAH_Total],[SARAWAK_Total],[EM_Total],
[Perlis],[Kedah],[Penang],[Perak],[Kelantan],[Terengganu],[Pahang],[Selangor],[WP],[NegriSembilan],[Melaka],[Johor],
[KotaKinaBalu],[sandakan],[Tawau],[Kudat],[Pendalaman],[Labuan],[SABAH_Other],
[Kuching],[Miri],[Sibu],[Bintulu],[SriAman],[KotaSemerahan],[Sarikei],[SARAWAK_Others],[Others]
FROM dbo.Z_tbl_Import_temp ) P

UNPIVOT (Copies FOR State IN ([Perlis],[Kedah],[Penang],[Perak],[Kelantan],[Terengganu],[Pahang],[Selangor],
[WP],[NegriSembilan],[Melaka],[Johor],
[KotaKinaBalu],[Sandakan],[Tawau],[Kudat],[Pendalaman],[Labuan],[SABAH_Other],
[Kuching],[Miri],[Sibu],[Bintulu],[SriAman],[KotaSemerahan],[Sarikei],[SARAWAK_Others],[Others]
))AS unpvt

Re: Error converting data type varchar to numeric

Mycroft Holmes6-Jul-14 13:01

Mycroft Holmes

6-Jul-14 13:01

Your excel sheet is probably formatted with comma.

You should split out your unpivot and inspect the results of the query to try and determine the invalid data, look for blanks, character and formatting (commans)

Never underestimate the power of human stupidity
RAH

Can not connect to my database from asp .net application

Stephen Holdorf5-Jul-14 0:15

Stephen Holdorf

5-Jul-14 0:15

I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string:

"Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" />

Please help

Steve Holdorf

Re: Can not connect to my database from asp .net application

Eddy Vluggen5-Jul-14 1:23

Eddy Vluggen

5-Jul-14 1:23

The CS does not say whether you want to use mixed mode or windows authentication. There's examples here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Can not connect to my database from asp .net application

Stephen Holdorf5-Jul-14 2:03

Stephen Holdorf

5-Jul-14 2:03

I tried this:

"Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=SSPI" providerName="System.Data.SqlClient"

and it still does not work?

Re: Can not connect to my database from asp .net application

Stephen Holdorf5-Jul-14 2:08

Stephen Holdorf

5-Jul-14 2:08

Sorry, I tried this:

"Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=True"

and it still doesn't work. One point is that this is the connection string that coexists with my Entity Framework model.

Re: Can not connect to my database from asp .net application

Stephen Holdorf5-Jul-14 2:26

Stephen Holdorf

5-Jul-14 2:26

OK. I think you were right on the DB connection string. Now, I'm getting this error:

An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

Here is my Entity Framework connection string:

<add name="EFDataModelEntities2" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=HOLDORF-PC\SQL_2008_R2;initial catalog=EFDataModel;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

And here is my Model connections:

<EntityContainer Name="EFDataModelEntities2" annotation:LazyLoadingEnabled="true">

<EntityContainerMapping StorageEntityContainer="EFDataModelModelStoreContainer" CdmEntityContainer="EFDataModelEntities2">

Re: Can not connect to my database from asp .net application

Eddy Vluggen5-Jul-14 22:46

Eddy Vluggen

5-Jul-14 22:46

I don't use EF; I've no idea what it epects beyond a normal SQL-server connection string. According to MSDN[^] your string looks correct.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Can not connect to my database from asp .net application

Jörgen Andersson6-Jul-14 11:23

Jörgen Andersson

6-Jul-14 11:23

lholdorf wrote:
Check the inner exceptions for details and ensure that the connection string is correct.

This is a good time to post the inner exceptions.

Wrong is evil and must be defeated. - Jeff Ello[^]

Re: Can not connect to my database from asp .net application

Bernhard Hiller6-Jul-14 21:01

Bernhard Hiller

6-Jul-14 21:01

Where does your asp.net application run - on the same machine? If not, configure the SQL Server to accept connections from other machines.
And what about the account the IIS is running with? Does that account have sufficient access rights to the database? I suggest SQL Server authentication instead of WIndows authentication - do not forget to configure your SQL Server to allow that.

Re: Can not connect to my database from asp .net application

Richard Deeming7-Jul-14 3:14

Richard Deeming

7-Jul-14 3:14

lholdorf wrote:
HOLDORF-PC\\SQL_2008_R2

Is the double back-slash between the machine name and the instance name a typo in your question, or a mistake in copying the connection string from a C# source file to the web.config file?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Can not connect to my database from asp .net application

Hemant Singh Rautela7-Jul-14 3:31

Hemant Singh Rautela

7-Jul-14 3:31

I think you have to provide user name and password also...!

I used As : Database Connection[^]

Complex SQL queries

data modeling guy3-Jul-14 5:14

data modeling guy

3-Jul-14 5:14

Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.

Re: Complex SQL queries

Richard MacCutchan3-Jul-14 5:22

Richard MacCutchan

3-Jul-14 5:22

Start at http://www.w3schools.com/sql/[^].

Re: Complex SQL queries

data modeling guy3-Jul-14 20:02

data modeling guy

3-Jul-14 20:02

Thanks

Re: Complex SQL queries

PIEBALDconsult3-Jul-14 5:53

PIEBALDconsult

3-Jul-14 5:53

Sure, try implementing a Turing Machine in SQL.

You'll never get very far if all you do is follow instructions.

Re: Complex SQL queries

data modeling guy3-Jul-14 20:03

data modeling guy

3-Jul-14 20:03

Thanks

Re: Complex SQL queries

Eddy Vluggen3-Jul-14 11:24

Eddy Vluggen

3-Jul-14 11:24

data modeling guy wrote:

Hello- can you give me any example
scenarios/questions for writing a complex SELECT statements? My intention is to
improve my SQL skills.

Calculate reputation points of a user.
Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
Fetch the ten members from the database that answered most questions last month.
Fetch the voting-percentages for the straw-poll result for all possible answers.
Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Complex SQL queries

Mycroft Holmes3-Jul-14 14:20

Mycroft Holmes

3-Jul-14 14:20

No no no these suggestions expect him to do the work and write the queries, it sounds like he wants YOU to write the queries and he will study them.

Good luck getting CM to lend out the database and schema Laugh | :laugh:

Never underestimate the power of human stupidity
RAH

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 19:07

Refresh

ᐊ Prev 1...181 182 183 184185186 187 188 189 190 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.