I recently completed a trial of MS SQL 2000 server.
I have purchased a licence for the software and would like to upgrade. How do I upgrade the trial version without installing a new versio...
SQL Server 2005
Service pack 2 installed
Originally setup for windows NT authentication
need to add mixed mode SQL authentication
i found knowledge base ariticle 925744 requiring a special...
I am trying to embed a stored procedure into a query. The stored procedure has to return a value as a pseudo column in the query. The stored procedure requires an input parameter and an outp...
pm frequency unit due
1 30 days 1-1-8
1 30 days 31-1-8
1 30 days 2-3-8
1 30 days 1-4-8
2 30 days 2-8-8
2 30 ...
I created a ssrs report with drilldown capabilities. When I export report to XL the XL document does not give me those drilldown feature and opens up all drilldowns. I believe I did get drilld...
I seen in several work environments ... sql server and ms access got integrated..what is the need for that?
I am trying to create some generic scripts that are not supposed to be bound to a database or to a schema. Everything works fine with table creation, view creation, function and procedure crea...
i don't know what happened. I think it had something to do with me installing sourcegear on that sql server. I can connect fine through the manager, and my normal windows program, but the se...
hi everyone,
i want to calculate NET SALES, CP value for every store only for SUNDAY, we work on weekly basis and our week starts from SUNDAY to SATURDAY
is there any way i can do it?
...
hi,
I need to export results from a rs using tsql to excel, it all works fine, is there a way to make it display horizontally ?
ex.
1/30/2008 5
2/28/2008 6
3/30/2008 2
4/30/2008 ...
If currency codes within a group are mixed, I need to show the word MIX as the currency code otherwise I need to to show the single currency code for that group (CAD or USD). So I need the cod...
yesterday i put a piece together for a summation, worked just fine. today i tried to add one more sum into it, and it keeps failing with msg 8114 -- error converting data type varchar to bigi...
Hello, SQL newbie here. I have a couple of basic questions.
I have a table named Table_1 with 3 columns and 2000 rows:
Email First Last
xx@xx.com Mike A
zz@...
I have a need to make sure that either all or no statements get committed in a series of two statement. There is a regular table and a table that is meant to work as an audit table, keeping t...
I recently downloaded and installed SQL Server 2005 Express onto a file server. Now I am trying to figure out how to start Express in order to create a new database and some tables.
In SQL...
I have a solution here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23621910.html#a22160370
I need the statement to be conditional, so if the log file does not ...
Hi,
I wrote an ASP script that scans all of our databases to find any SQL Injection issues (such as */ngg.js); however, what I really want to know is how to find the source. I've already tr...
I am using sp_transform which creates cross-tab result set for one of my reporting requirements. Here's the transform: http://www.itrain.de/knowhow/sql/tsql/pivot/pivotsample.asp
I actual...
I have the following SQL query:
strSQL1 = "SELECT DISTINCT Operations_Day AS OpDay FROM Daily_MOP_Tb WHERE (Operations_Day >= CONVERT(DATETIME, '2008-08-01 00:00:00', 102)) AND (Store_Numb...
i have a quad core xeon server with
4gb ram
2 70gb sas hhd raid one via raid controller card
IP SAN
server 2003 R2
I am installing veitas 9.1 on this machine. As this has sophos enterp...
I want to be able to create duplicate records in the return of my query based on a value with the return set.
example
Select OrderID, Units From Orders Where BatchID= 123456
RETURN:
...
I have 2 SQL servers, Server1 is on the domain, and Server2 is in the DMZ
I can do a remote logon to both servers, and I have registered both servers in Enterprise Manager (I.e. I can see s...
I have a table with about 50 columns in it... is there a way that I can execute a query that will only return those columns that are NOT NULL (without doing a literal check... "where col_x is ...
Hi
We have a column call Shortdesc, I would like to take the first work and place it in a column called Noun and the second word into Modifier. They are seperated by a '_' .
eg
Shortdesc ...
I am working on migrating several packages from DTS to SQL Server 2005 SSIS. I do not want to run them as a DTS packages in the new environment. I have an ActiveX Script task that I know I n...
