Hi,
I have a matrix report in SSRS, I'm trying to set the color of subtotal value based on it's value (Positive numbers balck and negative numbers red).
=IIF(Subtotal>=0,"Black","Red")
...
In SQL 2005 I created a Backup Device that points to the backup location
I this scripted the following:
BACKUP DATABASE Database
TO DISK = N'BackupDeviceName\TrackIT.bak'
WITH Descript...
I am trying to pass a variable to a sql statement....select * from table where idnumber in (?). My variable is a string from a table. It is in the format... 3373, 3232, 3433 However...
My objective is this:
I want to be able to set one of my variables in my Stored Procedure to equal an exact value, i.e. "DISABLED".
Second, I want to be able to pass in a specific workstati...
I am currently importing data back into a database after it was accidently deleted. However the source that I am importing from also contains data that still exists in the destination database...
Hi Experts,
Can someone please post a function for MSSQL Server that splits the following string into integers:
300,400,900,1200
Thanks
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
...
I have a SQL 2005 server hosting a DB in DOMAINXYZ. I am trying to acces the DB remotely through a VPN connection using the vendor provided client. Once connected to DOMAINXYZ throught the V...
I am attempting to kill a rouge Trace in SQL 2005 without success!
I have attempted:
exec sp_trace_setstatus 1,0
With the result of:
You do not have permission to run 'SP_TRACE_SETSTAT...
Hi,
I am hoping someone can help me here.
I am trying to take certin text out of one text field in a table. This one table holds account history.
By using Substring and Patindex i have b...
Drop everything in database B, copy everything in database A into database B.
Note: Avoiding restoring database A as database B
I have a SSRS report that works like a charm, only there is no print button on the report viewer control!!!! I have been reading in forums and I have seen anything from it can't be done to yo...
We have a server that we are trying to migrate to new hardware. We are testing the new HW before switching over to it. On the new server, I installed SQL 2005 & patched it to the same versio...
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...
While buying one of the product, seller is informing that it is 2000 compliant. According to seller, there are few stored procedure in the database which are not compliat with SQL Server 2005 ...
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,
Can anyone explain the difference between a SQL Server 2005 conversion from varchar and nvarchar to datetime or smalldatetime? Look at the following example:
SELECT DISTINCT HEDT...
I know there have been plenty of people asking the same question, and I have tried to follow instructions and do what have worked for others. Problem is I dont seem to get it to work. It shoul...
The following code does not work, and I need to know why. All I want to do is get the .Text value of each ListViewItem in the ListView's CheckedItems and store it in a SQL CE database.
For...
I have an Execute SQL task first and the query is Begin Transaction. I then have a dataflow that uses a Flat File Source, goes through a Derived Column transform, and loads into a table. After...
I know this is simple for a lot of you ... it's an Argghhh for me.
I have a two tables. One called MasterTable with the following columns:
ListNumber
Active
and a secondary ...
Receiving this in the SQL log files for over two weeks now..unsure where the problem lies.
Date 10/31/2007 3:20:45 PM
Log SQL Server (Current - 10/31/2007 3:23:00 PM)
Source Logon
...
When I exec to search, I am getting an error message:
"Conversion failed when converting datetime from character string."
Which I couldn't understand. I checked everything and make sure that...
Iam using .NET reportViewer control to display the report in Web Application. I created a Reports project and deployed it on the Report Server.
My Application talks to the Oracle as well as S...
Greetings;
I'm using Microsoft SQL 2005.
I am attempting to store text in a column defined as varchar(2048). The text contains line feed and carriage return characters. After examining t...
