Your not grouping by pnc_bnc alone. You have three different pieces to your group clause.

GROUP BY b.pn_bnc, b.model_bnc, b.bnc90d

Split returns an array. Maybe you can't put the results into a text object.

This is not an easy task. It took me about a year to get one of these done converting from Access 2000 to SQL 2000. Most of the...

Check the scope of the variable. SSIS has all those pretty little boxes and you can scope the variable to any one of them.

Are you using Access as an adp file tied to a SQL server back end? If so, you have to create a switchboard table on SQL Server. That...

The report parameters section offers a combo box.

1. Create and name a dataset for the report using a stored procedure or sql text.

2. Reference the dataset name in the chosen...

Okay, I'll try an answer. Hopefully this does not sound familiar.

Acct Guy: Hey DBA guy, I'm in accounting and I need a list of every purchases for last month...

There is a problem with using ISNumeric to decipher a string. Certain character groups return TRUE such as 10E. So if in this case someone lives at...

Couldn't you just right click on the row header and click summation?

http://msdn2.microsoft.com/en-us/library/ms251709(VS.80).aspx

Thats beautiful work guys!

What if the record has the string '4-Stars out of 5'. Woud this return 45?

I was thinking about creating a function which loops through the string...

If you want to change how records are ordered, you have to use the "Order By" clause and you have to meet 2 criteria.

1. You must use a field in...

If I understand this process, you're ending up with one large report with every invoice. If you don't need everything in report you may be able to set up...

+5 Hours would be GMT during Eastern Standard Time. Right now it should be +4 until the November stoppage of Daylight Savings Time.

http://timeanddate.com/worldclock/

http://wwp.greenwichmeantime.com/time-zone/

http://en.wikipedia.org/wiki/List_of_U.S._states_by_time_zone

I would import the information as a datetime. This will give you the 4 digit year during import. You can also do a lot of date/time manipulation with...

We had to upgrade a db from 2000 to 2005. I just used a restore of one of the 2000 backups to the new box and the db was...