Could the error be related to the actual statement sp_executesql is executing?

Example:

DECLARE @sql NVARCHAR(MAX)

SET @sql = 'DECLARE @tbl TABLE (Test CHAR(1))'

SET @sql = @sql + 'INSERT INTO @tbl VALUES (''ABCD...'')'

EXEC...

I currently use Quest Toad Data Modeler. I've used ERWin, Visio and Power*Architect in the past. For me I found that Toad does everything I need: reverse engineering right through...

How about if you moved the email criteria to the outer select and added a DISTINCT?

insert into userprofile(userID, fieldID, value,)

select distinct userID, 1000, 'external'

from user

where not exists (

...

Not sure if this'll work or not (base table script and sample data would be helpful) but try adding userID and another set of parenthesis around the ORs in your...

My guess is that the DISTINCT and the aggregate functions aren't playing nice.

Have you tried it without the DISTINCT and the GROUP BY?

SELECT

Account

, sum(amount) over (partition by account) Total

, count...

Yep, same here. Most of the heavy lifting is in stored procs (i.e. T-SQL) and is definitely...

Brandie Tarvin (2/9/2011)

---

One thing that may help (in the long run) is to come up with a DOs and DON'Ts list (Database standards). If you're cleaning up the code, you...

Thanks for the responses.

Right call, but tough to implement. Where there used...

Change your string to start with the comma.

So instead of: 'Tuesday, Wednesday, '

It would be: ', Tuesday, Wednesday'

And then you're able to always cutoff the 1st two characters.

DECLARE @str VARCHAR(50)

SET...

lianv 90648 (2/4/2011)

---

Good Day,

is there a way to schedule SQL Server Profiler as a job ?The y need to run on a continuous basis s for auditing . I tested...

I'd have to agree with Grant. Sometimes consistency has to trump logic, especially when you're handing it off to someone else for support.

Also, if they're going to be inflexible about...

Seems like there should be a better solution but this seems to work.

CREATE TABLE #tbl_radio (

AdDate CHAR(12)

, AdTime CHAR(8)

, Station CHAR(4)

, Duration TINYINT

)

INSERT INTO #tbl_radio (AdDate, AdTime, Station, Duration) VALUES...

Just to be clear, when the first record's time plus the duration (45 sec) is greater than the second record's time then omit the second record?

Just an FYI: I contacted Red Gate about the 404s and they referred me to documentation on a different release.

http://www.red-gate.com/supportcenter/Content?p=SQL%20Compare&c=SQL_Compare/help/8.1/SC_CL_Getting_Started.htm&toc=SQL_Compare/help/8.1/toc846144.htm

Sure, you just need to cleanup the join.

use

...and b.fk_stateid = case when...

instead of

...and b.fk_stateid = b.fk_stateid = case when...