Can't quite get my head around this Run-Once script, at the moment, appreciate any quick help, so I can get on with my favourite job, reviewing all the uploaded images, for approval. - LOL
ht...
We have a MySQL v5 database that sits behind a website on a web server.
A PHP script is used to take records and insert them into an SQL Server 2000 database that resides on another server....
I would like to export my results of a SQL Query in Excel is there a way of doing that in Sql server 2005
Hi,
I have a situation where I'm transferring data between two MS SQL 2005 servers and one of the tasks is to retrieve data from one SQL server [S1] (it is also a Linked Server) and export it...
How do I add a field to an existing table that be auto incrementing for all the records that are already in the table?
ideally in query analyser please
SQL server 2000
tia
Hello,
I am running SQL Server 2000. I made a T-SQL job that is supposed to count the number of results for a given query and if the result = 0 execute a select statement. It seems to be...
Hello.
Using the solutions found on EE, I've created a stored proc that takes each row of a fixed width text file and bulk inserts it as a single string in a row in a temp table. The proc the...
We are using MS SQL 2005 at work. The MS SQL 2005 is installed on a really high end new server (16 processors, TeraBytes of RAM, RAID hard drives etc.) What we are experiencing is that a cou...
Hi There
I am trying to import data into my SQL server from a csv file. I imported the file into a staging table on the SQL server, and all fields are varchar (8000).
I am using the code...
Hello Experts, I have a varchar column that contains both strings and integers stored as strings (see sample below). I would like to select the ones that can be easily converted to INT withou...
I am new to SSIS. I hope this is simple.
I have a flat file source that I am loading into a RecordsetDestination object. I want to use the first field in the record set as the value to per...
Hi Experts,
I'm building a report in Visual Studio (an rdl file) and my dataset is coming from a stored procedure.
I am putting the dataset into a table.
I would like to put the datas...
I am trying to call a stored procedure in a while loop but for some
reason it only returns 1 row whereas I am expectint 12 rows
Here is the stored procedure and the call
set ANSI_NULLS ON...
Hi,
I have a Procedure on As400 SQL called SM_PROC. I wish to execute(call) this from my microsoft SQl server. The AS400 stored procedure does not return any values it runs a number of inse...
In SQL, how does one prevent rounding off of numbers. Eg. If number is 47.8879 the round off to 2 decimal places returns 47.89 (using convert). I want 47.88 only as the output. i.e upto 2 deci...
I have a date string such as "Tuesday, December 04, 2007 8:41:38 AM" that needs to go into a datetime fields in SQL Server 2000. Is there an easy cast or convert statement to get this into t...
HI Guys, I have a question. I have to output 2 implied decimal amount fields (AJ_Dollar_Amount & AJ_Amount). I have defined they as decimal (13, 0) and decimal (17, 0) respectively. I was told...
I am writing a database script that will be run when my application is being installed. I have some insert and update statements that include subqueries, but I cannot get them to work in SQL ...
HI,
I have a default install of SQLEXPRESS installed on my worstation. The instance of course is named localhost\SQLEXPRESS. Is there a way to change the instance name to just "localhost"?
...
Good Day
Experts:
I am getting this error "SQL Server blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures". Using a db that I created here, I have no pr...
Hi, I need help in calcullating a percentage in sql using sql server 2000.
For example, I have a column:
column
red
red
red
blue
orange
green
and have an output
column column...
How can I calculate a percentage in SQL server without getting a divide by zero error when my data contains legitimate zeros. I would like to do this in a UDF
Experts,
I am using a batch file to execute OSQL, which executes an SP to extract data and place it in an CSV file. Then the batch file calls a vbscript file to relocate it and email it as ...
Hi,
I have three tables:
BulkMemberHeader - which has a cascade delete on BulkMemberDetail of any related records
BulkMemberDetail which has a DELETE trigger which gets the member ID fr...
I try to create UNIQUE INDEX on sql server table but I get an error massge becuase of the null in my key.
I have 3000 records in my table and I want to add this Unique index to the row and ...
