Have you looked at the layering capabilities of Visio. It allows you to have multiple layers to a drawing. This way you can separate your physical and logical...

The exec command seems to create a new connection and execute the command that you are specifying, so any changes to the curently specified database are not reflected in the...

You can always start typing the word in Query Analyzer and see when the word turns blue

I am sorry the code should be:

Create FUNCTION GetCol4 (@col1 datatype, @col2 datatype, @col3 datatype)RETURNS varchar(5000)AS

BEGIN

DECLARE @Cols varchar(5000)

SET @Cols = ''



SELECT @Cols = 

CASE @Cols...

I don't know if this is what you are trying to do, but you said you wanted to display horizontally what is vertically in a table

I got this elsewhere on...

This is a file being uploaded by a user. I co not know what the field names are going to be.

A more complete solution for me actually...

I found the answer. You have to turn the option on when creating the procedure.

SET ANSI_NULLS ON

SET ANSI_WARNINGS ON

GO

CREATE PROCEDURE xxx(...

GO

I am need to use dynamic file names and I am inserting the data into dynamic table names. When I generate the statements and try to EXEC I get...