RE: how to return one result set from multiple queries (ie. no results from query1, go to query2)

You can write like SELECT ResultID, Link, Description FROM results WHERE Isnull(Op1,@op1) = @Op1 AND Isnull(Op2,@op2) = @Op2 AND Isnull(Op3,@op3) = @Op3 AND Isnull(Op4,@op4) = @Op4 AND Isnull(Op5,@op5) = @Op5 did i understand your problem correctly?

Problem in transform data task whlie generating text files.

Hi all,I am generating text files from database tables.When number of columns are less then 15 i am able to define cloumns in destination text file but when number of columns in table is more then 15 task is not able to generate columns in destination text file.Thanks In Advance.

RE: Moving Large Database

Hi,This is just a login idea. If I move SQL logins to a new server then I use 3 parameters to sp_addlogin: login name, password and SID that I get from restored database's sysusers that contains the source server's SIDs. This way logins are created with SIDs that are already matched.Yelena 

RE: Query Analyzer displaying all int datatypes as decimals....

Nice little option there... I see how this could be usefull when doing a presentation on a big screen. But I still preffer seeing both the queries and the results in the same window. But thanx for the great trick .

You are working with SQL Server 2005 and...

RE: week function

The rules for week numbers are different between different countries. I am not sure which rules are specific for you, but take a look at my article On the trail of the ISO week for an example of getting ISO week numbers.

RE: tables

But SET PARSEONLY requires that you execute a statement (even though it will only be parsed and not executed), and it does not return any resultset regarding which tables are used. Afaik and the way I understand your question, you need to parse the strings yourself.

RE: QueryTool complaint

I did mention that.  We could place the views on our network.  Another solution is to link our SQL tables to an Access application and let them play in that sandbox.   The over-riding problem we have is an end user who wants everything for her group...She was recently promoted into IT and we are just […]

RE: SQL CHAR field question

set nocount on create table #temp (product_id int not null, prod_desc char(1) null) insert into #temp select 1, 'A' insert into #temp select 1, 'B' insert into #temp select 1, 'C' insert into #temp select 2, 'D' insert into #temp select 2, 'E' insert into #temp select 2, 'F' DECLARE @Output VARCHAR(8000) SET @Output = […]

RE: Generate SQL Script

I think you may want to be more specific in your question.  Query Analyzer is basically a notepad interface in which you make your own code to run.  There are ways to write such that it will generate output that is a script; for instance you can run code to query one table which will […]