Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post.
I have a table containing user-account permissions and I\'m trying to write a query to return one row for each user-account combination.
I have a bit of SQL that is almost doing what I want it to do. I\'m working with three tables, a Users, UserPhoneNumbers and UserPhoneNumberTypes. I\'m trying to get a list of users with their phone n
I am getting data like Result ------ 10 23 21 But i want开发者_StackOverflow中文版 to get data in the following format.
I have a script that processes queued records in a SQL table in SQL Server 2000.I now need to add additional instances of my script to process their own subset of the queued records in the table.
I need to select a nullable bit column in a view, but use a default value of FALSE whe开发者_如何学JAVAnever the value is NULL.(For other reasons, I can\'t add the default value on the source table it
Can you please tell me how to integrate the CR 2008 into VS 2008 Team System as currently VS doen\'t give me the option to create Crystal reports using a template!!!
I want to use LIKE clause and IN clause together. e.g: Currently my query is - SELECT * FROM 开发者_StackOverflow社区[USER_DETAILS]
I am trying to optimize the below query in SQL Server 2000. Every table has more than 300 000 rows except the Prod_Lot_Stage_Wise_Detl table which contains 2 million records.
I\'ve just moved a database from a SQL 2000 instance to a SQL 2008 instance and have encountered an odd problem which appears to be related to IDENTITY columns and stored procedures.
加载中,请稍侯......