Please don't cross post - someone has already answered your question here.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=322131

Cheers

Use nested selects such as

select
   (select x from myTable where rowNum=1) as col1,
   (select x from myTable where rowNum=2) as col2,
   (select x from...

That's a fairly broad question - is this for an assignment or something?

In any case, you have two ways of authenticating with SQL Server - Windows Authentication or SQL-Server authentication. ...

Please don't cross post - or if you must then please include references between your threads so that other members don't answer your question when it's alreay been answered elsewhere. ...

Cross post - see http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=318895 instead (maintain a single set of replies so we don't double answer).

I like the "schwacked" term

I haven't used much of the SQL 2005 tools yet but I would imagine that the window sizing is...

I'd play with the settings on the linked server properies - there's two about collations.  One is about using the remote server's collation and the other indicates whether you want...

I don't see how that code helps.  I tried this

create table #Command (

 EventType nvarchar(100),

 parmeters int,

 EventInfo nvarchar(255)

)

GO

select 1

GO

INSERT INTO #Command

EXEC sp_executesql N'dbcc inputbuffer(@SPID)', N'@SPID int', @SPID = @@SPID

GO

select...

Hi..

What does Query Analzer say about the view names?

What does select * from information_schema.views  return?

What tool did you use to give you that code?  Scripting from Enterprise Manager, Query Analyzer...

Having completed IT + Maths degrees at university it is nice to see someone using some maths in the real world - I reckon 99/100 SQL developers would've used a...

It is important that incorrect (again, depends on your point of view to some extent) posts are debated.  It wasn't really that "ouch" from my point of view but again...

I guess the lines might blur slightly when you have a table of drugs, some of which could be used to treat multiple conditions.

EG, we are developing an electronic forms...

Locking hints mightn't needed (although they certainly couldn't hurt) IFF there can only be one user modifying a given order at any given time.  I assumed that you wanted the...

No problem - the stored proc parameter method is also much safer as it helps to avoid SQL injection attacks

I agree with the others - your question doesn't seem to be expressed very clearly.

You stated that you need a stored proc to accept a parameter and based on this...