Steve,

I can read this two different ways, and I can't tell which way you mean:

1. Post all examples of the...

This should do it.

declare @test1 table (Tname varchar(1000))

insert into @test1 (Tname) values ('<>Agenda and Minute')

insert into @test1 (Tname) values ('<>Agenda and Minute')

insert into @test1 (Tname) values ('<>Agenda and Minute')

insert into...

Now that explains a few things.:w00t:

Lynn Pettis (7/6/2009)

---

You may want to search this site a bit....

Lowell... very good insight there. I had not considered this... I just assumed that they ran here.

Ghanta (7/5/2009)

---

Guys I made the variable @nsql nvarchar(max) to be used for dynamic sql. When I execute using sp_executesql, it throws me error and seems like the sql that it...

edl0022 (7/5/2009)

---

I have a stored procedure with a variable with type nvarchar(max) to store the sql for executei(exec sp_executesql).... but i found my sql statement is too long(over the size...

The business case helps tremendously. Let's see what we can come up with...

@Lutz: Thanks for the additional links.

What brought this to a head for me was that I was contacted by three senior posters (senior, by my definition, being > 1000 points)...

Lowell (7/5/2009)

---

I slapped together a stored proc sp_GetDDL that returns the table DDL, complete with indexes ,defaults, everything...there's a function version as well; that would probably work just fine for...

Glad we could help you.

No... we're not here to do your work for you. We will, however, guide you to find the solution.

As several...

wesigler (7/5/2009)

---

Sorry about the lack of detail, I was trying to keep it simple, but I can see how it was not enough information.

I am trying to create a stored...

Jeff Moden (7/5/2009)

---

I've been bitching to Steve Jones and the others that the code windows don't work correctly with IE. One voice isn't very effective though. It would...

rahul.soni2 (7/5/2009)

---

Hi All, I have a script that generates Server job details on execution.

I need to store the data in .csv file.

I need to send the Output file in a...