AIRWALKER-375999 (12/21/2010)

---

Hi Elliott thanks for your response,

the excel file our ssis packages uses goes on a short journey before it end up on the database server,

it is uploaded to an...

I'm too busy to work out a script right now, but maybe you, or somebody else could benefit from hearing how I'd solve it:

Build a Tally table[/url] if you don't...

I did something similar at my last job, but I don't seem to have a copy. In short, you'd have to use information_schema and/or system views extensively.

A bit of...

Ok here we go...

You'll need to build a tally table. Jeff Moden has an excellent article about tally tables here[/url].

After you have a tally table, create a test table with...

I'm dreaming up a solution using tally tables... What is your desired output? Number of occurrences, or indexes of occurrences?

I imagine there are better ways to do this, but this is what I was able to come up with...

select * from

(

select *,

row_number() over(partition by postcode order by...

Thanks for the response Gail,

I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had much luck...

If you want to script data, you'll need to explicitly set the option. Under the "Choose Script Options" dialog, scroll down, you'll see the "Script Data" option under the Table/View...

Jeff Moden (11/28/2010)

---

Just never name any constraint on a Temp Table or, like Craig said, you'll...

I think that option one is by far your best choice.

For option 2, I don't think you'd want to change the schema every time you want to add a...

Thanks for the reply Craig (and for the helpful links in your sig :))

Visual studio's schema compare does indeed do some weird stuff with constraints when they are named/unnamed. After...

Good points. I guess I'm looking for a webhost with sql server, or a evirtual host that I can install sql express on.

I never really use sqlcmd, but maybe if you set nocount on in your statement, you will suppress the record counts - seems to work that way in SSMS

Looks like line 66:

GETDATE()) + 11) AND (DATEPART(year, DOCDATE) = DATEPART(year, GETDATE()) - 1)), 0.0) AS PyrMonth1, e.VENDORID, ISNULL

You are sending 2 values to the isnull statement here.

No Prob - us "Forum Newbies" have to stick together. I have also seen some examples when accessing properties rather than variables, the brackets are not used. Your example would...