Why do you want prefixes on all your tables? This is...

Or if you don't want to have a hard coded set of value to look for and your list is delimited we can use the DelimitedSplit8K.

if OBJECT_ID('tempdb..#MyTable') is not null

drop...

SqlServerNinja (4/11/2013)

---

Hi Sean,

Thank you for your reply. This is the second time you are helping me out.

I actually see that there...

Lynn Pettis (4/11/2013)

---

Yes,...

You did a pretty good job posting details about your issue. It would be easier if you had created tables but from your description it is pretty simple.

create table #TableA

(

ID...

So you are building...

a_ud (4/11/2013)

---

The odd thing (from an Access point of view) is that the row, to me, is identified by the condition.

Essentially what I was doing was used some VBA on...

Easiest way is to use SSMS.

Right click the database -> Tasks -> Generate Scripts.

This will bring up a wizard. Choose the table(s) you want to script. Then on the "Set...

???

Did you have a question or did you just want to post some data to see if it posted correctly?

As previously stated having ddl and sample data is the best way to help. There is a large amount of information here though so that task may be a bit...

More than likely one of those variables is ending up NULL so when you concatenate them all together the @Message is NULL.

I would recommend NOT sending an email directly from...

To read and write files stored in varbinary you have to convert to and from a byte array.

Here is a snippet that I use to retrieve pdf's from a...

LOL Lynn's code looks almost the same as mine...except he remembered the isInMarket part. 😉

matthew.knudsen (4/10/2013)

---

I have a table structure as follows:

guidA, market, isInMarket, guidB (lets just say all of these columns are strings)

I would like to get a count grouped by market, where...

Not totally sure what the...