Indeed, but who knows why they would want to aggregate data from 2 different tables and present them in 1 recordset.

Probably would have been too much trouble to ask why...

What do you mean by its not working?

error message?

your users need to know to create tables using the proper naming conventions no exceptions

If the table is intended to be shared to all db users. then they should create...

Max() or min() it diesn't matter, this is the best performing solution to perform a crosstab query.

the only other way is to create temporary objects and a looping/cursor solution where...

I'm in the Doesn't matter school of thought.

The t-sql, or ansi-sql standard does not state that there is an order requirement, nor have I seen a recommendation of the order.

It...

Something like this

select [Date],

       min(case type when 'A Count' then [count]end) as 'A Count',

       min(case type when 'B Sum' then [count]end) as 'B Sum',

From (

        SELECT 'A Count' as...

As remi is stating, you should create a begin and end date parameter instead of using datepart.

set @Begindate = '10/07/2005 10:00:00'

set @Enddate = '10/07/2005 11:00:00'

Select ...

From Mytable

Where CreateDate >=...

Is it giving you too many rows?

try specifying what the value of WO1 is?

Without knowing your table relationships, and data its hard to say.

http://www.aspfaq.com/etiquette.asp?id=5006

Use Modulo % it shows the remainder value in a division equation.

Select 10 % 5

Result

0

Select 10 % 4

Result

2

if ((@currentBid - @NewBid) % @bidincrement) = 0

I'm not exactly sure what your asking.

Is this your sample data?

what do you want it to look like after your done?

I do not see repeated data.

Can you elaborate on your...

Create the work in a trigger calling a stored procedure recursively.

Just be careful, because if your hierarchy is of unknown depth, then you may encounter an error.

Sql server can...

http://www.extremeexperts.com/SQL/FAQ/StoreImages.aspx

This one is important

http://www.aspfaq.com/show.asp?id=2149

http://www.sqlteam.com/item.asp?ItemID=986

http://www.sql-server-performance.com/q&a17.asp

you can, but not the best idea.

1) Is there any System level Store Procedure that I as an SQl Server Admin can access and restrict the user.

Use sp_grantdbaccess to give user access to a db

and...

Please do not cross post, we read all forums

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=227144

Hello,

the problem your having is Ur xml is no good

when you set @strXML, you need to use an apostorphe (')

with an attribute in an xml string the Value is wrapped...