Well in QA You cannot.

In EM actually You can, EM has a tab separated format for the rows copied from/into a table.

You can see this if you copy some rows...

This is a very good idea. I am all for it.

And congrats on this great site, and all the dedication and good work and effort You guys put into it...

The two methods basically use the same technique:

Find the first day of next month and substract one.

The method that doesn't use string manipulation is slightly faster. Which of course has...

If everyone is Ok with You setting up your db, I can't see why not.

Also I'm interested in maintaining my own DB. I'm wondering if there will be a...

declare @date datetime

set @date = '20040329'

select dateadd(month,1+datediff(month,0,@date),0)-1

set @date = '20040331'

select dateadd(month,1+datediff(month,0,@date),0)-1

--/rockmoose

/*

CREATE FUNCTION dbo.getMthEndDate(@date datetime)

RETURNS DATETIME

AS

BEGIN

 RETURN dateadd(month,1+datediff(month,0,@date),0)-1

END

*/

First for alternatives:

Install MSDE (Microsoft SQL Server 2000 Desktop Engine).

Microsoft has a free admin tool that is webbased:

(SQL Server Web Data Administrator)

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

And there are other tools out there as...

You will want to acquire skills in database design concepts, [T-]SQL, SQL Server Administration and Security concepts.

And the best way to acquire them is by excersising these skills on a...

Ok Anup,

A table must have at least one Key that is meaningful to the business.

An "Artificial" key ( Identity, guid, rownumber ) is probably not a meaningful business key,

and if...

Hi,

There are tons of ways to this, here is another one...

DECLARE @minutes INT

SET @minutes = DATEDIFF(mi,'2004-05-09 11:45:00','2004-05-11 00:00:00')

-- Format minute interval to HH:MM

SELECT REPLACE(STR(@minutes/60,2,0)+':'+STR(@minutes%60,2,0),' ','0')

-- Format minute interval to HHHH:MM

SELECT...

Declare @tablename varchar(255)

Declare tablecursor CURSOR For

  Select TABLE_NAME from INFORMATION_SCHEMA.COLUMNS

    WHERE COLUMN_NAME = 'QTY_PO'

OPEN tablecursor

FETCH NEXT from tablecursor into @tablename

while @@fetch_status = 0

  BEGIN

   print @tablename

   exec( 'select QTY_PO...

Right Antares, didn't click at first.

The left join could be replaced with an exists clause:

where not exists( select * from paymentprocessing.dbo.recon r where r.ccr_trxno = cct.number and r.ccrespid is not...

Actually, why do You join paymentprocessing.dbo.recon at all in this query!?

I can see no information in this table being used anywhere in the query, or am I just blind ???...

This all seems a bit messy.

Could You please post the definition for Your table, with PK etc.

To me it does not make sense to have a default value on the...

--Is it something like this You are trying to accomplish ?:

SELECT grp.emp_group_name, mmmm_emp.*

FROM mmmm_emp

JOIN(

 SELECT emp_group_name

 FROM mmmm_emp a INNER JOIN mmmm_emp_group b

 ON a.emp_group_id=b.emp_group_id AND a.emp_id=18887 ) grp

ON mmmm_emp.first_name =...

OR processing can be slow,

try changing

.......and ( p.processor = 'Processed'

   or

   p.processor is null

       ).....

to

.......and isnull(p.processor,'Processed') = 'Processed' .........

Might make the query optimizer happier !?

/rockmoose