This should do the trick:

SELECT Department, Status, COUNT(*)

FROM (

SELECT A.ItemCode AS [Container ID],

Cust.company AS Account,

Dept.departmentname AS Department,

A.ref1 AS [Alternate ID],

A.fromdate AS [From Date],

A.todate AS [To Date],

A.ref2 AS [Sequence Begin],

A.ref3...

Not so unique in Italy... 😀

http://www.paginebianche.it/execute.cgi?ver=default&font=default&btt=1&ts=101&cb=8&l=it&mr=10&rk=&om=&qs=Sartori&qsn=Gianluca&dv=&ind=

Steve Jones - Editor (6/9/2009)

---

Here are a few books recommended on database design. The diagrams will be listed in there: http://thomaslarock.com/book-reviews/

A few tools I have used:

- Management Studio/Enterprise Manager with...

Maybe you need something like a CASE .. WHEN expression, bu I suggest you take a look at this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

maybe we can help you better with some sample code.

Regards

Gianluca

This is what I have done, at my own risk... (see some bull**it answers I threw in some threads... ;-))

There are pros and cons, but I didn't think about it...

Glad I could help.

XMLHTTP, a COM-wrapper around the classing WinInet library is designed to be used on the client-side to send HTTP requests to the server. Whereas, ServerXMLHTTP was introduced in MSXML 3.0...

What does it mean? What will you do with these variables? Will you use the variables in a stored...

"each database has tables" can't be translated into a query predicate, it must be something related to your columns.

If I try this I get duplicates for each table:

DECLARE @tab TABLE...

Take a look at this article:

http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm

It was linked from last week's newsletter.

MSXML2.XMLHTTP, as far as I know, is not thread safe, so I would not recommend it.

Hope this helps.

Gianluca

Is this what you need?

SELECT A.id1, A.Name1, MIN(B.user1) AS User1

FROM #id AS A

INNER JOIN #EVENT AS B

ON A.id1 = b.id

GROUP BY A.id1, A.Name1

Your primary source is BOL (Books OnLine).

http://msdn.microsoft.com/en-us/library/bb418471(SQL.10).aspx

Did you try google?

http://www.google.it/search?q=sql+server+2000+cursors

Regards

Gianluca

I don't undesrtand what you need.

Try reading this http://www.sqlservercentral.com/articles/Best+Practices/61537/ and come back with more info: I'll be glad to help you.

Regards

Gianluca

You must define a business rule to join tab with itself. That rule could be dataset = dataset and db db, but this still doesn't do the trick. With...

This is a client tool, so you don't need the x64 version if your server is x64. Anyway, there's no x64 package on the page you linked.

Hope this helps

Gianluca