Since I am using SQL Server 2000 and don\'t have the luxury of SQL Server 2005\'s pivot tables, I need some help on creating a query.
I need to synchronize sql server 2000 data (source) in one server to sql server 2008 (destination) in another server by using wcf (one direction transfer is sufficient) so that i can take occasional u
I need to find all the events occurring after the most recent gap of 30 days or more without an event.My current query only finds the first gap of 30 days.开发者_如何学编程If there aren\'t any gaps of
I have run into this problem that I\'m trying to solve: Every day I import new records into a table that have an ID number.
Given a table of two columns with recurring values in each column, how can I identify the rows where a 1:1 match between the two rows exists? E.g.
Previously used this SQL Agent Jobs, how to document to get information about all SQL Scheduled jobs.
In a stored procedure I am selec开发者_开发知识库ting from a table using variables passed in. Then, I want to log what is selected. Is there any way to do this without using a temporary table or table
I am working on scenario, i have two tables: \"Master_product\" and \"New_Products\" Master_product table have 14 fields
I am massively in need to help. I have spent an entire day when I do not have even an hour to waste on a project. I have a Linq to SQL data layer and am doing a simple insert into the DB using the fol
This question refers to the T-SQL compatible with MSSMS 2000. Suppose the result set of a query Q always returns one column with 0, 1, or n records开发者_高级运维. I want a superquery W to return a v
加载中,请稍侯......