Heyhey, you mix up something here. Wine is nothing to drink like beer or other alcoholica.

But from your given alternatives, I would also opt for #3 (of course, without...

select * from table1 where id = case @parm  when null then null else @parm end

where id = null...

Have you tried that before posting?

Hm, I would rather drink another good one, than think about a schema for this just for fun.

Anyway I think most wine guides...

Germany may outsource its resources to Poland (no jokes please) but German jobs would be lost.

Yes, http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181044

CREATE TABLE #test

(

 dt DATETIME

)

INSERT INTO #test

SELECT '20050504'

UNION ALL

SELECT '20050510'

UNION ALL

SELECT '20050511'

UNION ALL

SELECT '20050515'

UNION ALL

SELECT '20050517'

SELECT MIN(t1.dt) [DATE], ISNULL(DATEDIFF(dd,MAX(t2.dt), MAX(t1.dt)),0) [DATE DIFF]

FROM #test t1 LEFT JOIN #test t2 ON t1.dt>t2.dt

GROUP BY...

What about QUOTENAME()?

Alternatively click on the button next to the combobox. You should see a windows popping up showing all available active servers. Once you've connected, QA "remembers" your last servers.

Here are some more to read:

http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

Welcome to the family!

Within your Microsoft SQL Server program group you'll find Books Online BOL). Unlike other MS product documentation, SQL Server's online...

See if this helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=180032#bm180450

In addition to Carl's comment, see if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

Pipe the results from sp_helpindex into a table and query this.

The following query is not exactly what you've asked for, but I think this will get you going:

SELECT

 CAST(SO.[name] AS...

One possible way would be to send the return from xp_cmdshell to a table and query the table for the filename to process:

CREATE TABLE cmdshell (line VARCHAR(260))

GO

INSERT INTO cmdshell EXEC...