Hello,
I would like to be able to perform a count and also display multiple values (tests) from a table.
PSSA_STUDENTS Table:
student_id int PK
firstname varchar
lastname varchar
...
So here's a crazy idea. Would it be feasable to email SQL transaction logs for a small SQL database to an outside email address for offsite backup purposes. I'm kinda hoping that this is a d...
Experts,
An outsourced office of ours is currently using handwritten forms to submit for approval. I intend to convert the submission and tracking of these forms electronically through a da...
We have an ASP classic website and SQL Server 2000 database with IIS6.
Somehow, our members are being spammed from a Russian chick claiming she got their email address from our site. We nev...
I have a field value on a form titled Biddate.
I also have a field value titled FollowupDate.
Both date fields are in the datetime datatype
I am using SQL server 2000 database and Visual...
I am developing an MS Access database application to interact with a SQL Server based accounts package. Every now and then I take a copy of the live data onto my local pc to become my test dat...
I'm trying to create a stored procedure that will create a view based upon 3 values passed as parameters. Stored procedure:
CREATE PROCEDURE spCreateRandomingView
@PubID varchar(50), @...
I have the following view - and its giving me duplicates..
I was wondering if there was a way of re-writing this without using a distinct ?
Thanks
Mo
Hi,
I am unable to see any of my databases with enterprise manager.
This has only just started to happen - and i have no idea why.
If I select the database tab then I am presented with a ...
Hi,
I was wondering if anyone knows how to layout a table structure that would allow someone to search for properties with certain features without having to store features in a table such ...
I have a temp table as followed:
Create Table #TempTable
(
column1 int
, column2 varchar(20)
.
.
.
)
I want to save the result of my stored procedure into thi...
I keep getting this error intermittently: Autogrow of file 'seed16_log' in database 'P21' took 61922 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file." O...
SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated
I asked a question about how to make the below sql code easer yesterday and the suggestion was to use ROW_NUMBER function as i am on MS SQL 2005.
so now my question is, can anyone give me a...
Hi all,
Is it possible to use a single stored procedure to insert an entry into multiple tables?
For example, once a user logs in for the first time I want to add their ID to a number o...
I got a phone number column display on my C# window application. I found out some of the phone numbers are null but it shows () - on the grid. Now if I want to change the () - to blank, how ...
Hi All,
I have the following query which gives me results of two rows. I need to delete these two rows from the table evv_eng_var
SELECT isnull(b.evv_envardesc,a.engvardesc) as col1,isnu...
hi guys, i have a csv file that use looks like this
"INVOICE#,""CUSTOMER#"",""CUSTOMER CITY"",""ORDER"",""SHIP DATE"",""PO NUMBER"",""INVOICE DATE"",""INVOICE AMT"",""CASH DISC %"",""CASH DIS...
Hi All
I'm designing a SSIS package where I'm accepting a datetime as a package-wide parameter.
Question: How do I incorporate that parameter into various SQL statements used in OLE DB...
I am building a report with SSRS. The report includes 2 parameters, which encompass a date range: @startdate and @enddate. These date parameters can be null and by default are null. They a...
Hi All,
I am looking for help for some views which has already created by previous dba in my company.
I want to add a primarykey type key to my view which is unique for that particular v...
Following a Hard Drive failure, I have had the data recovered from the drives, and the important files are
.bak /
data.mdf & log.mdf these files have the required file size however when i ...
We use a replacement function on SQL Server 2000 to replace certain characters with certain Unicode-characters. We found an error in the function output because SQL Server considers 'þ' to be ...
We have an MS Access table in which one field is the path to an image. We then regularly upload that data into a corresponding SQL table. But rather than just uploading the path to the image...
Does anyone know how to setup a Sql cluster (Active, Passive) to use sql mail to send out some jobs that process each day. Do i need to install Outlook on the cluster servers? Can i relay it...
