A Pivot table query would work for you. You should be able to modify my "Pivot table without case statement" example. You can find that example here:

http://www.geocities.com/sqlserverexamples/#pivot1

Gregory Larsen,...

Old habits are hard to break. Here is the same thing using sp_executesql:

create PROCEDURE dbo.test

@tableName varchar(20)

AS

declare @CMD nvarchar(1000)

set @CMD = 'SELECT dbo. '+ rtrim(@tableName) + '.*' +

' FROM...

Try this out:

create PROCEDURE dbo.test

@tableName varchar(20)

AS

declare @CMD varchar(1000)

set @CMD = 'SELECT dbo. '+ rtrim(@tableName) + '.*' +

' FROM dbo.' + rtrim(@tableName)

exec(@cmd)

GO

Gregory Larsen, DBA

If you looking for SQL Server...

I also have not detailed this out at all, but generally this is what I am thinking.

There would be a process that would read the encripted login and password, then...

We are running all of our jobs using the SQL Server job scheduler. All these jobs are connecting to SQL Server using a trusted connection.

Another possible option...

Looks like you have a number of examples. If your text data is really less than 8000 then looks like jpipes suggested a simple approach. Now I guess...

Here is one possible solution. I'm guessing that someone else might have a better way. This particular example removes all the carriage return and line feed from a...

If the task scheduler and SQL Server box are one and the same, I think you can add local accounts to SQL Server and still use the trusted option.

Gregory Larsen,...

Below are two examples to do what you want. Hope this is what you are looking for.

-- Example 1 only works id rows are returned in update...

Guess I was trying to assess how much of an impact turning off parallelism migh cause. I'm assuming with parallelism turned on not all query the queries would get...

Turning parallelism off, surely solves the problem, but I am wondering did parallelism work in SP 3 and earlier? Or where we just not seeing the errors, it really...

Probably the easiest way is to go into "Design Table" in EM for the tables that you want to move columns around, and then used CUT/PASTE to reposition the column....

I also think you need to add to that sum, the size of the null block, and the variable block. Null block contains the null bit map, and the...

Here is an article I wrote about collation problems.

http://www.sqlservercentral.com/columnists/glarsen/collate_part1.asp

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Have you checked out the convert function?

Try something like this:

declare @N numeric(18,2)

set @N = 49785.26

select convert(char,cast(@N as money),1)

set @N = 85.26

select convert(char,cast(@N as money),1)

set @N =...