Experts:
How many "different" RS Websites can you have with a SINGLE Server License of SQL Server 2005 ...?
I have one built....but we have 2 separate companies and wondering if I can sp...
Hello all,
I recently found the need to upgrade from SQL2000 to SQL2005. I need the ability to run some stored procedures; options which are not available with SQL2000. I would ultimately...
I have the following qry. I want to append the week duration to W1_cr, w2_cr etc.
For eg if the month is july2008 i want to have like w1_cr(1 to 7) , w2cr (8 to 14) etc.
The week duratio...
I'm currently sending an email using the sp_send_dbmail stored procedure,
I am using the @query param to send a query of data in the body of the email,
What i want to do is send the emai...
I need to create a query against two tables. The first table is a linked table with the a column of "OPEN_TIME" with this format:7/25/2008 8:25:09 AM. The second table has 2 columns. Column 1...
The attached file shows five records from a table. There are many such situations found in my table.
I ultimately need to find the invoicenumber (col af) associated with the record having ...
This should be an easy one.
But want to be thorough and pushed for time. I have to install MSSQL free version onto an Windows Server 2003 box in preparation for an installaton of another ap...
How do I stop this error from occuring:
Source: MSSQLSERVER
Category: (6)
Type: Error
Event ID: 17055
User: NT AUTHORITY\SYSTEM
Computer: SQLserver
Description: 18278:
Database log t...
folks
how do i exchange the oracle decode statment to sql server
DECODE(TO_CHAR(due,'MM'),TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'MM'),'X') month1,
all help will do
r
I have string with the following -
x26.33x55.13
What I need to do is to replace the first "x" with "-|-|" and the second "x" in the string with "|"
How would I do that?
I've got the following flow in SSIS - see attached.
My problem is that the Lookup appears to be doing a left join rather than an inner join
as the transfer of data it's doing into the OLE...
Ok, this is a really weird problem. I've got an application that I'm building that inserts records one at a time into a remote MS SQL database. I built error handling into the application so...
How do I execute a query with parameters and loop through the results?
When do I use a SqlCeResultSet, SqlCeDataReader, and SqlCeDataAdapter?
Is it possible to modify the audit level for an SQL Server instance using Transact-SQL?
I need help on coding the subquery associated to 'LastProcedure'. Currently, i am getting the same result in each record. I must have missed something obvious.
I am on a project and planning a move of a Sharepoint 2007 server to a data center.
I was wondering what is the recommeneded approach for moving the databases.
Plan A -> restore the data...
Hi
I have a query which returns a result set in:
Fund_ID......Year......Q1.......Q2.......Q3.......Q4
1 2001 1 4 5 6
1 ...
Is there a way to include a field in the middle of a text block with text already in it, without creating a separate textbox w/ the expression?
e.g. "Lorem ipsum su dolor First.(Fields!Fie...
I have a field that stores data in small datetime
I need a select statement that will return '' when that field in < getdate() - 183
I have a report that needs to be grouped by Department Name. I created a group and Grouped it by DeptName. However, as it is to show all the details per group...it shows that but doesnt make t...
I want to update two tables; however, if I'm updatting and something goes wrong then I want NOTHING to get updated.
Also, is there a way to somehow step through or print/echo out the values...
Hi Experts, I am having backup issues with a user db for 3 days in a row now. The error I get from the sqlserver error log is the following (In this order):
BackupMedium::ReportIoError: wri...
We are a small business and have MSQL Server (I believe Version 8) that has 2 databases on it.
The server is running 24/7. We are doing backups with Acronis Echo Server for Windows. Up until ...
We have a new client and have discovered their database server has no space on their "C" drive. We've deleted log files, docs/settings/etc and have about 50mb. On their data partition, there...
Hi,
I'm a novice to SQL Server but not to SQL and relational databases. Here's what I want to do but I'm not sure how to approach it in SQL Server:
I have a stored procedure (call it sp...
