Hello,
I have a stored procedure that I run that imports data from one table to another. The table it imports from/to is a criteria passed in the stored procedure call.
I have another S...
Please could you provide me with a code example of how to index a table variable.
Hey all,
I having an issue getting error trapping to work correctly using sp_executesql in conjunction to a xp_cmdshell script. I've been asked to error trap an exiting stored procedure (w...
We currently use a field that updates with the date and time and last user initial each time a record is saved.
We have written a trigger in SQL, however we have over 200 files that will ne...
The following error occurs even when the mentioned variable is declared
Msg 137 Must declare the scalar variable "@finyearid_fr"
I just moved the databases into th new server. The server is having 2 CPU (Quad core) and 8GB RAM. I would like to enable the AWE, however since AWE can only be used on SQL server 2000 Enterpr...
Hi,
This is my table fields
select QuestionID,Product_MenuId,Question,UploadPath,Status from Tb_Questions
Here status is int field.
i want to check the value of status here.
if value...
I am enhancing an SSRS in VS2005. As I try to deploy the SSRS, I get errors saying:
Error 18 [rsFieldInPageSectionExpression] The Value expression for the textbox po_ctrl_int refers to a...
Does anyone know how to restore an SQL 2005 .BAK file to a new server in a new location????
I recieve an error 21: device is not ready. In the error message is also lists the ORIGINAL full...
Hello, I am trying to convert some oracle code to sql server and am having problems.
Here is the original oracle code:
SELECT sort_hour,
CHAR(TO_DATE( sort_hour, 'HH24' ),'FMHH')||' - '||C...
Hi,
I have two columns 'serial' and 'type' in table 'bills'
I want to get the max serial +1 where type = x
the standard statement:
"SELECT ISNULL(MAX(serial), 0) + 1 FROM bills
WHERE t...
how do I enter date/time value via sql statement as follows:
UPDATE [table]
SET DateTimeStamp = '19/06/2008 23:03:06'
WHERE [parameters]
the SET statement is not being accepted by SQL ...
Hi Experts,
I would like to think through what is involved in Replicating a database in SQL 2005 SP2 from one server to another in an AD environment. The reason for the move would be to use...
I am using SQL Server 2005 and trying to import data from an Excel 2007 file into my SQL Server database. Previously, when importing from Excel 2003 it was very simple (just specify Microsoft...
I need to set up a Service Broker endpoint that includes an AES setting so that I will get confirmation that
we are using FIPS compliant encryption.
I used the following code
CREATE ENDPO...
I have an SSIS package in SQL Server 2005. When I deployed the package to the SQL Server and execute the package manually in Integration Services. The package executes without a problem. Howev...
I have been tasked to create a report that compares the sum of values from the previous year, the current month and ytd in three columns. In my first stab at it, I created a ytd function and ...
Trying to read files stored as Varbinary(max) on my asp.net page.
Database schema is:
id int
fileName varchar(100)
fileSize varchar(20)
fileContent varbinary(MAX)
dateAdded smallda...
Hi
I have this data
Serial Number Service_Order
X000701 1511293
X000701 1511293
X000701 1510831
X000701 1510831
X0008...
I have a table in my database called crmAfterCareData. I've also created a View that holds some info from another table (crmApplicationData_ToUse) and some data from crmAfterCareData. My View ...
On microsoft site it says upgrading from Developer to Enterprise edition is easy. I cannot find where to do this or how?
We have a database in which the updates are done using stored procedures, having the form given below. The question is, once this is compiled as a stored procedure, are the apparent multiple u...
I would like to hide a total line on a group if the result is only one row.
So for instance, I have:
Group 1
Item 1 $40
Item 2 $30
Item 3 $30
Total $100
It...
Hi All
SSIS - I am trying to insert the results of a ole db source/stored proc, into a ole db destination/table.
In the ole db source object, Connection Manager, I have SQL Command/ my SP...
could someone walk me through the process of getting this script out to a text file in sql server 2005?
i thought i could just do SQLCMD mode ... but that doens't work. its just the adventur...
