I'm dealing with a database with tables that have freaking columns.
Partial DDL:
Create table [tbl IMN] ([Ave Cost-Mn] varchar(10))
-- yeah, this column contains string value

Using [b]rollup [/b]I want to count the number of rows of a table
called Table1 which is LEFT JOINED with a table called Table2.
The problem is that we can have [b]more[/b] than 1 rows in Table2 that
matched 1 row in Table1. As a consequence the count of rows in table1

We have created CSV files on HPUX 11.0 and transferred them via ASCII ftp
to our SQL Server machine file store to load large amounts for data using
the BULK INSERT command. This is the command:
BULK INSERT db..table FROM 'S:\path\filename.csv'

Does exist in SQL language "for" loop ? If yes, what syntax does it has ?
best wishes
Adam

I need to add expense types to various projects in our ERP database.  I
perform this query
select DISTINCT a.project_id
from project as a, project_cost_element as b

So here's my dilemma. I need an automated SQL Server (2000) job that
runs once once per hour.
This jobs should:
1) Retrieve unread email for the user "Le" from our Exchange Server,

Is it possible to interchange column & row data from the t-sql on
storing into a file?
Thanks

I have a stored procedure in SQL 7 which runs fine when called from Query
Analyzer, but fails when it is called as a scheduled job task.
The sp (Customer_UpdateLastEntry_All) gets the last "event" for each
customer from the CustomerEvents table using a cursor (curItems), then ...

I can't seem to get this procedure to work correctly. Here's my code:
DECLARE @PropertyDetails nvarchar (6)
      Select @PropertyDescription = PropertyDescription from Property where
ApplicationID = @applicationid

Hope someone can help on this - new to the area so here goes.
I've got an SQL stored procedure that checks a company name from an import
spreadsheet. If the first 35 characters of the company name are the same on
the spreadsheet as already in the database, it leaves the company ...

About a month ago I setup a Server and named it SQL1 I setup a maintenance
plan and all was well. I needed to rename server to SQL. I went onto the
server today to take a look around and noticed that the DB is 133GB instead
of 35GB. When I when to make some changed on the ...

Hi to all Gurus,
I am working with two tables, where in if a record is inserted in one
table an insert trigger fires and inserts relevant information for that
record in the second table. This works well within my applications.

Which newsgroup will help me in optimizing my query..
can any one help ?
Regards
ypul

I have one windows 2003 server running Exchange 2003.  It is also running
MSDE.  What I want to know is can I install the full version of MS SQL 2000
while MSDE is on the same server.  Can they coexist with each other?
TIA,

I have installed Visual Studio 2005 beta 2 that include the SQL Express.
Then I installed the SQLClient to my pc too. And when I click on the sql
group
An error message pops up