IIRC the font color is case-sensitive so your expression needs to specify Red and Green, not red and green. HTH

Doug

Your formula is calculating a number and then changing it into a date, so you need CAST to accomplish that. You also need CONVERT to change the resulting date into...

Just an idea, but you could use SSIS just to prep the data into staging table(s) and then use SSRS to create a formatted report & create a timed subscription...

We have a similar concept but in our case the developer uses some Visual Basic code to build up a single change script. Each individual script is bracketed with a...

I found this very interesting so I did some more research. . .

Scott, your code works perfectly fine, the EXEC does work as expected. Apparently the PRINT statement has a...

Scott, it is definitely cutting off. I inserted a PRINT LEN(@sql) right after the statement that begins with

"SELECT @sql = ISNULL(@sql " etc.

and it returns 22492 characters.

PS...

Hello Scott,

Do you have a solution for larger tables? I have a table with 207 columns, and very long column names, the average being approx 26 characters. The code you...

On the first attempt I received the message:

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for...

First of all, 2 GB is the theoretical design limit for an Access mdb, so you should make a copy before you do anything else. Then in the copy, try...

Hmmm. After the EXEC the temp table goes out of scope.

OK, so the solution is...don't use a temp table:

IF OBJECT_ID('myTemp1') IS NOT NULL

DROP TABLE myTemp1

IF 1 <> 0

BEGIN

EXEC sp_executesql...

Thomas, are you sure that the field is NULL and not a zero-length string ("") - ?

IF OBJECT_ID(N'tempdb..#myTemp1', N'U') IS NOT NULL

DROP TABLE #myTemp1

IF 1 <> 0

BEGIN

EXEC sp_executesql N'Select * INTO #myTemp1 From TableA'

END

ELSE

BEGIN

EXEC sp_executesql N'Select * INTO #myTemp1 From TableB'

END

george.greiner (4/16/2010)

---

Hello,

I am wondering what the best way to handle invoicing is as previously invoicing was not something we had to deal with based on a prior contract but now...

You can use this

EXEC sp_executesql N'ALTER TABLE myTable add col1 int'

but a better solution would be to modify the "part 1" code so you don't need to do this.

If any of your tables are at approx 99.995% or higher, the script errors out with:

Msg 8115, Level 16, State 8, Line 1

Arithmetic overflow error converting numeric to data type...