I have a requirement in SSIS to connect to a remote ftp site, download all files to a local drive and then remove only the remote files that I've transferred. The file names will be different ...
I have the following query as attached below. Right now, if the story has 0 votes associated, instead or return voteN: 0 and voteB: 0 , it returns null or no results..
however if there is j...
Hi I Currently have a website that stores information like images and description of it to a database.
I can reterieve the image that is uploaded but what i want to do is reterieve multiple ...
while designing a table in SQL Server 2005, what data type should I give for a field with boolean values ? There does not seem to be a Boolean data type in SQL Server 2005 !
I am trying to import information from a spreadsheet for the first time in SQL 2005. I have done this many times in SQL 2000 with no issues. But now I am getting the following errors and I a...
Greetings Experts!
I have worked with MS.ACCESS 2007 and when desigining a table I can always make a field and designate it as my Primary Key and set its data type as "Autonumber", this makes...
How do I insert datetime text string into datetime column? I've done the following:
SELECT CONVERT(datetime,'select convert(datetime,convert(varchar(20),enter_time,106)) from access_log', 105...
Dear experts, I am trying to use Case logic to a where statement in my stored proc. I have a Messages table that has messages a user has sent to himself or other people. I need some kind of If...
I have a SQL Server table called Fund Details with a column named Annualised Return (%) of type float size 8.
I am using the below SQL to select the Annualised Return (%) value at 2 decim...
Hi,
I have a test table:
CREATE TABLE dbo.MyTable
(id INT NULL,
v CHAR(1000) DEFAULT 'aaa',
)
How do I add a NOT NULL constraint to the "id" column?
Thank you.
I have a trigger on a table that sends off a service broker message. This works fine if there is only a one row update to the table. If there are more than one row then the message will never ...
Hi,
I want to display the date like "Sun 19th Aug" or "Sun 19". Is there a way to do this? I searched for the sql date formats and there is no version that will allow to add the day of week...
I have a BirthDate Column which contains values such as 10/5/1960 12:00:00 AM and some records are NULL because there are employees like Temps where we do not track birthdays. I have a column ...
We have a database that has:
FirstName
LastName
ImageName: the name of the image file in the filesystem ex: "Fred Flintstone" < no extensions
Dept: Department number
Image: This is empty ...
We're using BIDS to create our report projects for SSRS 2005. Many of our reports need to compare data from disparate systems. Without importing data or creating a central repository, how do w...
Using Reporting Services in SQL Server 2005, is it possible to access the report's dataset(s) from within a function implemented in the report's custom code module?
The custom code module I...
I fetch data from SQL Sever 2005 through MS Access interface using SQL Pass-Through Queries (SPTQ). I have two queries with the same sql text inside (please see the code snippet) and connect t...
I ran through the sp2 install on my W2K3 SQL 2K5 Server and all completed successfully except the Client Tools. What are the ramifications of thes porblem? Here is the error portion of the log...
I want to import a files into a temp table and select a substring of the first record as the FileID. I then want to compare this FileID to the FileID column in my Pharmacy.PDEFileLog table. If...
I know that there are other posts on this forum concerning the SQL Server 2005 error message
"Too many backup devices specified for backup or restore; only 64 ar allowed."
However, I ha...
Hi,
I have a Table Variable and a Stored Procedure that returns a list of numbers.
DECLARE @tmpTableTABLE (int id)
How can I execute my Stored Procedure to put the values into the Tmp...
When my default.aspx page loads I get this error for the connection to my SQL 2005 DB.
An error has occurred while establishing a connection to the server. When connecting to SQL S...
Hi there I have a integer which is milliseconds representing a lap time
I would like to convert this to the hh:mm:ss.ms format to show the lap time properly using MSSQL or even vb.net
c...
I have a hosted SQL Server 2005 database on which there are several tables that I wish to defrag or compress or whatever is necessary. These tables get a lot of use - they temporarily hold row...
Just installed SQL 2005...I am trying to setup a user so that they have a default database that I will use in the connection string in my .net ASP code...I have created the login, gave them ac...
