I am currently experiencing slowness with an application that I am running on various workstations. I have run a SQL Profile on it and for the most part the results are good. In other words,...
Using SQL 2005 Reporting Services. We are getting the following error in the Reporting Services Configuration:
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual directory ...
I am running Veritas Netbackup 6.5. I have a couple of sql servers with multiple databases on them. I've heard that Netbackup can backup sql databases directly. I'm not sure if there are custo...
I have a SQL SELECT statement that has a clause:
"WHERE filename LIKE " & sFileSpec
and when sFileSpec is "4_03" it returns a match for filename = "4303". Does the underscore character act...
Is is possible to pass more than 1 input/output paramater to a stored procedure from within another stored procedure?
I want to pass in parameters into a stored proc lets say X = 5, Y= 10, ...
Im running Windows XP and cant get sql server express 2005 to install.
The installation fails at the "SQL Server Database Services" component. I get this message
"The SQL Server service fa...
How can I use SSIS to insert AND delete rows in a SQL Server table based on an an action code contained in each row of a flat file? Each row in the flat file contains an ACTION_CODE, an ID, a...
how to pass the numeric(12,0) data type to variable in SSIS? what kind of variable data type should I choose?
if i select int32, it keep giving me an error:
Error: 0xC001F009 at Row by Row p...
I'm told that the version number of SQL Server 2005 (9.0.3068) must be matched by the SQL Native client version in ODBC drivers. Mine was at one point 2005.90.00.3042, but after some upgrade a...
Based on my data structure below I am trying to return one record for every person , if a person has non unique values in Column1 or Column2, I just want to return the first record found alon...
Is it pobbile to us a variable in a MS SQL query like this:
DECLARE @ChrgTot MONEY
SELECT tre1.*,
(SELECT @ChrgTot = ISNULL(SELECT SUM Amt FROM Charges WHERE tre1.TreatId = Charges.Tre...
We have been using a vendor in an ASP environment for some time now. We have decided to move to an inhouse server and the vendor has sent us our data in a .bak format. They said it was a bac...
Hi,
I have a sql database table with information below to calculate US sales tax using zip code. Any ideas how to proceed. How is the calculation done for US sales tax? This information is ...
Drop everything in database B, copy everything in database A into database B.
Note: Avoiding restoring database A as database B
Hi, I am successfully able to set report parameters and use them in the data parameters on a main report I want to pass all the values now to the drilldown report. I went to the properties of ...
Hi,
Is there any way in Transact-SQL (MSSQL 2005) to format the
output of datetime fields into Australian date format (DD/MM/YYYY)?
I have written a function to do this (see Code Snippe...
Hi
I am working on migrating to a Warehouse Management System, which has an SQL Server 2005 back end
At the moment, i have an external program which creates carrier labels, based on a fi...
Hi
I've to insert and retrieve a graphic to/from SQL Server 2005 dbase for use on ASP.net 2.0 page.
I've tried some links but never quite got there.....so code would be better this time
...
Hi,
I need to create a SSRS report that shows data from 2 different Stored Procedures that expect the same two parameters. How do I do this please? One Stored Procedure will return 3 or 4 l...
Hi Guys
I think what I am asking is simple.
But I can not work it out.
I have a Microsoft SQL table.
It is one column. Example below.
Product
-------------
Microsoft XP.
Windows 2...
I am running a stored procedure with a VarChar as parameter. when i run the SP it gives me the error
execute Sp_Insert "2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2...
Background:
Developing a script to replicate two databases from one SQL Server 2005 Express to another on a nightly basis. The approach I am taking to achieve this is to perform a nightly...
I would like to set up a SQL query to include records that have a field value LIKE "%test%" but exclude records that have a field LIKE "%Exclude%"
Something like
SELECT NAME, ADDRESS FRO...
I'm trying to import an Excel 2003 datasheet into SQL Server 2005 SP3, with SSIS installed and reinstalled. I get the folllowing error:
Error 0xc00470fe: Data flow task: The product level i...
Hello,
I am using SQL 2005 Express on a machine. I think by default on Express setup the autoclose property is set true for all databases. But now I want to change them to true. Can I have ...
