It was an interesting article, but I don't see why you would store the logic for the calculation in the table definition rather than in the SQL you use to...

To list the names of files in a directory you can use the 'dir' command. Execute it using xp_cmdshell.

There might be an extended procedure to do it for you too....

I think it's actually a double quote that's missing. Try this:-

set @cad='BULK INSERT webmisco.dbo.wr_primero FROM ''d:\transferencia$\web\reports\'+@Fichero+' with (DATAFILETYPE = ''char'', FIELDTERMINATOR = '','',CODEPAGE=''850'')'

should be

set @cad='BULK INSERT webmisco.dbo.wr_primero FROM ''d:\transferencia$\web\reports\'+@Fichero+'"...

Why not try something like this, it uses 2 updates but doesn't require a select to get the value of nextticket from #ytable:-

CREATE TABLE #xtable (ticket int)

CREATE TABLE #ytable (nextticket...

Why not just use different code for each known sort param, e.g.

Declare @SortOrder as varchar(10)

Set @SortOrder = 'myString'

IF @SortOrder = 'My_ID'

Select My_ID_Int, My_Date, My_String
From MyTable
Order By My_ID_Int

ELSE IF @SortOrder =...

This may not be a problem but have you tried executing an SP that does not have spaces in the name?

I know the [square brackets] should allow spaces to be...

Ok guys, this might seem like a strange question but how about creating an SP with a lot more logic that retrieves data from a smaller subset of tables in...

Just a warning note about the EXCLUDE list - you should probably add start and end delimiters to your excluded DB names to prevent a custom DB called My_master being...

Alternatively, once you've unzipped the file containing SQL statements you can load them into a temp table with a single field using a BULK INSERT command (look in BOL).

Then process each...

You could try looking at the sp_addtrace and related system s procs.

These will let you save info on queries, in a similar way to profiler does but more flexibly, to a...