RE: using IN operator in a stored procedure

Another option is to dynamically build the sql statement.declare @sql varchar(2000)set @sql='select * from tbl where id in (' + @idlist +')'EXEC (@sql)If the ids are integer, then you will want to remove the qoutes prior to building the string.Brian

Hidden Dangers!

How many of you register a server in Enterprise Manager? Now how many of you click the "save password" box? Probably most of you. Are you aware of the security risks associated with this? James Travis looks at one of potential problems here and other security issues relating to SQL-DMO.

MDAC 2.8 Deployment

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Setting the default member on a Time Dimension to current date

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Taking parsed string and assigning variables without using a temp table

Thank you for responding. I really like the method you suggested...I'll give it a shot.Demicoq

RE: Linked Access MDB Question

The only time I have seen it is when attempting INSERT / UPDATE via OPENQUERY

Discuss Content Posted by Amit Jethva

Discussions about content posted by Amit Jethva

You suspect that a hacker is trying to...

Calculating days in a month

Can anyone point me to SQL Server code that can calculate the number of days in a specific month? 

RE: difference between localhost and (local)

(local) would be a SQLServer term that referrs to the current machine.  I'd expect it to use the preferred connection method (TCP/IP or Named Pipes depending on the install).localhost is a TCP/IP term, but that doesn't force it to use TCP/IP instead of Named Pipes (just for fun)I expect that the reason that it's not […]