Hey guys, I believe Julio created a new Topic instead of replying in http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx.

antonio.collins (5/31/2009)

---

P.S.: if you've got hundreds of thousands of entries and the table is growing regularly, then an explicit colum to store the derived value should be added to the...

Hi guys,

Everyone’s nailed it for the example I provided, though I have realised that there may be legitimate Trades with the exact same values (yes, there is no Primary or...

Thanks Gollis, that shortcut may prove useful in future!

Yeah, I believe he works for Redgate who advertise heavily on SSC (and make some great products from what I've seen through trialware).

Yes, you can definitely create Tables using SSIS. In Data Flow Task, create a OLE DB Destination and for the Data Access Mode, select "Table Name or View Name Variable"...

I'm actually glad i knew that Client Side for 2005 was SQLWb. When I first starting this job, my machine had 1Gb Ram (they've doubled since, thank God) on it...

Is Property_Zip_Country_ID the last column in the row. In that case your error might be caused by an Incorrect Row Delimiter and you can fix the error rather than ignore...

I'd be happy so long as these "Answered" questions still appear in the "Database Pros who need your help!" section of the Newsletter. I always enjoy picking out the topics...

I would have thought not having an ifexists() on the first line would ensure this would fail (table not existing to drop), though I second guessed the question and got...

Sergiy (2/21/2009)

---

nathanb (2/19/2009)

---

Also realised my Broken Drop Table Statement was because I had the Schema (Dbo) included. On just doing a straight select * on information.Schema I realised what it...

Also realised my Broken Drop Table Statement was because I had the Schema (Dbo) included. On just doing a straight select * on information.Schema I realised what it should look...

Ah, thanks! It never occured to me that would be the Problem. In that case, I get '100.446271221111' as the answer:

--IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_name = 'dbo.Fund')...

Well, tried to produce it using my Logic and J's original Code (First Table I've ever created using a query, though I've had plenty of experience writing SELECT statements to...

I'd say J would either create a second column (or table, I guess) to differntiate the two groups, adding together those in Group 1 and Counting those in both Groups...