Hi,
I have a small registration site that allows an individual to register then register up to 4 additional people. The site was built in a couple of days so tried to keep the
DB design...
Hello,
I just wondering if there is a way to get my data faster.
I call my Sql function with Check_Customer_Orders(SearchOrderNo, row)
SearchOrderNo= check this order-no row= the row from...
I have a stored procedure.and I want to insert the values directly into a textfile when I execute it(don't want to go into table).attached is the query I have for this.please help me out.
nex...
I am having some issues in Reporting Services with allowing the user to check the NULL box next to my date parameters.
When I check the null options for the start and end date and select m...
Hi, I have the following table:
Transaction { ID, Date }
I need SQL statement that find the total number(count) of transactions that done per date.
By the way my database engine is SQL Se...
when I use account administrater and I start outlook, Business Contact Manager work fine.
when i make same but I use account when level standard user i have error message "conection problem ...
Hello everyone, thanks in advance for your help. I'm trying without success to insert a 1 meg image into my database. I've looked at other solutions here and tried them, as well as MS's pres...
I created a function for user to calculate median, one parameter for the function @filter is actually used to filter the result so the median is calculated on those records which meets that co...
I have juliandate value 2007335 and,I have to change like 2007-12-01 in yyyy/mm/dd.
Can you please give me this.
I have the following trigger, I have two fields, Problem and Resolution. Is there a way to have it send only when these certain Fields are Inserted or Updated, Instead of when any field in the...
Statement:
TRUNCATE TABLE I5_LOCN_UPDATE
BULK INSERT I5_LOCN_UPDATE
FROM '\\WMOSAP01\C$\ItemlocationUpdate\itmfixloc.csv'
WITH (FORMATFILE = '\\wmosap01\C$\ItemlocationUpdate\Formatitmfixl...
I'm creating a simple Contact database and was wanting to capture Contact's Home Phone number OR Mobile Phone number. I don't care which one I get as long as I get one of them. How can this be...
I'm designing an automated letter using SQL Server Reporting Services. The letter uses an expression to populate relevant date values in the letter. If the due date for a car payment were 9/...
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...
Hi there - we've a database that has grown to 271GB in size due to bad growth/expansion policy but the main data file has approx 80GB free space. I'd like to SHRINK the database datafile down...
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...
Hi
I have a table full of contacts and it stored data like:
Contact_ID | Firm_ID | First_Name | Last_Name | Email_Address
Some email addresses are null or blank for whatever reason. W...
Hi,
We have an application that we deploy with SQL server express. The application contains three database files (ie three MDFs) and they are stored in the local application directory. Curr...
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:
...
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 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...
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...
Hi Guys
I have lengthy procedure which uses the join to fetch the data recently i have changed due to additional requirement but now i have another problem with this solution first it was ...
Hi.
A question in 2 parts
Part 1 - The problem
===============
Running an MSSQL 7 server.
I have added a stored procedure which changes some period numbers based upon a calendar. ...
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...
