Use this tag for questions specific to the 2008 version of Microsoft's SQL Server.
0
votes
1answer
19 views
How to increment a column based on two tables that are joined
I am trying to increment a column on a sql server table based on the join between the initial table and the joined table. The idea is to update tblForm10Objectives, set the ObjectiveNumber column to ...
1
vote
0answers
19 views
Error on calling a stored procedure from java - Invalid JDBC data type -10
I have a java class from which i am connecting to the SQL Server 2008 which is on a remote machine.I Can retrieve data using a class which means the connection is working fine.
But when i try to run a ...
2
votes
1answer
22 views
MS-SQL 2008 Whole Word Matches
I've spent a few hours researching this and am pretty stumped, probably due to my in-often use of RegEx expressions.
I am looking to match a whole word in either a VARCHAR or TEXT type column in ...
-4
votes
0answers
41 views
“Access violation” error when connecting to database
i have made a delphi 7 project using sql 2008 database engine but when the code runs and is in the point of connecting with my database the programm stops and say access violation at address ...
-1
votes
1answer
30 views
Converting Date Strings (in different formats) Into Data Type In SQL Server
I have a column of data in the below string formats
When I copy and paste the above into an Excel sheet and change the column to a date format, all of the above will be converted into the same ...
0
votes
1answer
37 views
What would cause parameter sniffing one one computer and not another?
I just came across parameter sniffing in MSSQL today and used OPTION RECOMPILE to speed up a query that took 2.5 seconds with a parameter vs instant without. On a different developers machine they ...
1
vote
0answers
15 views
import data from .txt for reporting purposes
I am running a query in Report builder that uses order numbers (approx. 100). Currently they are fixed and I have to change them each time. Is there a way that I can import those numbers to Report ...
0
votes
1answer
11 views
Cannot create Sql Compact DB programmatically
I am trying to create an MVC4 application that affords the user to create a SQL Server Compact database on the fly.
Here is my code straight out of MSDN:
string connStr = "Data Source = ...
-1
votes
0answers
12 views
Installing Microsoft SQL Server 2008 Express with Tools [closed]
I installed Visual studio 2010. I removed SQL server 2008 before installing separately Microsoft SQL Server 2008 Express with Tools.In installation rules step a Express server 2005 get failed .The ...
1
vote
1answer
34 views
Update datatype with mixed date and date and time
Our database with a data type of datetime has some entries that are just dates and some with dates and times. For the entries with just dates, can we run a script that will set the time portion to ...
-2
votes
1answer
15 views
aggregate data based on ID and groupID observations
Hey i have data such as:
id cashpayment total payment groupID
1 30.00 100.00 A
1 30.00 100.00 B
1 30.00 ...
0
votes
0answers
10 views
How to Print More than one report with one click using Crystal Report, ASP.NET, C#
I have developed a Crystal Reports report using ASP.Net, C#. It is working fine but my requirement is to print multiple report with the same Print button. Now my report is taking data from database ...
3
votes
2answers
61 views
How to create table in SYS schema in SQL Server?
Can one create table in sys schema SQL Server 2008 ?
I know it is possible to mark table as system, but not change the schema.
Any hacks for it ?
-4
votes
0answers
31 views
Is there any reporting software integrated with SQL Server? [closed]
I have database and I want to analyse it and make statistics depending on charts, so,
Is there any software integrated with SQL Server to generate reports and charts?
Any Open source tool, any paid ...
0
votes
0answers
9 views
AesCryptoServiceProvider Class Not Showing
I am trying to import the System.Security.Cryptography.AesCryptoServiceProvider class into a script task of a SQL Server 2008 SSIS package.
When I look at the available namespaces with the script ...
