Log in

No account? Create an account
DB_Community's Journal
[Most Recent Entries] [Calendar View] [Friends]

Below are the 20 most recent journal entries recorded in DB_Community's LiveJournal:

[ << Previous 20 ]
Thursday, August 12th, 2010
6:16 pm
Thursday, April 1st, 2010
1:26 pm

One of the tricky things that developers new to SQL Server struggle with is the concept of NULL. Quite often I have seen people wonder why an empty string, or a zero, do no equate to NULL, or even why null does not equal NULL when searching. That fundamental idea of"unknown" just seems to be one that confuses many programmers.

The other day I was listening to a developer at Microsoft that is looking forward to SQL 11, and he let something slip. I suspect that this wasn't intended to get out, but it wasn't an ND talk, and no disclaimers were given, so I don't think there is any reason I can't repeat it.

There won't be any null support in SQL 11.

No more worrying about ISNULL, or NULLIF, no more sticking in specialized code that deals with unknown values. Instead you'll need to actually put in data for all fields, relying on empty strings, or zeros, to signify missing data. The support for a"zero" date is still a work in progress, but it appears that strong support for "1/1/1900" as a base date is out there.

I think this is fantastic,and it will make developing databases much simpler in the future. Developer swill no longer have to worry about missing information, and they'll just set a default value for all columns. I suspect that defaults will actually be required for all new fields in all tables, just to prevent errors. This also means that we'll get multi-table inset capabilities in views since all fields will have defaults and the order of values supplied will be used to populate rows in the base tables.

Of course, this is also an April Fool's joke and is in no way based on reality.It's entirely a work of fiction, and I hope you have a smile on your face at this point.
Saturday, March 13th, 2010
12:43 pm
Looking for a job. java team lead / system architect

At the moment I am looking for a job of java team lead / system architect.
LinkedIN profile

Thursday, November 12th, 2009
1:38 pm
EPIC next generation ERP-system
Epicor Software Corporation (NASDAQ: EPIC), a leading provider of enterprise business software solutions for the midmarket and divisions of Global 1000 companies, today announced that Epicor 9, the Company's next-generation enterprise resource planning (ERP) solution continues to gain momentum with more than 30,000 user seats shipped worldwide to date.

Both new and existing customers globally and across industries are realizing the benefits of Epicor's award-winning real-time business management solution, launched last year at the Company's annual global user conference.

"We are extremely pleased with the success Epicor 9 has achieved since its launch, both in terms of new customer wins, and existing customer implementations and migrations," said George Klaus, chairman, president and CEO for Epicor. "We are committed to delivering world class solutions, services and support to our customers -- to see them attain the benefits of improved business processes, productivity gains and overall success with Epicor 9 is gratifying. We expect the adoption of Epicor 9 to continue trending up, as we move toward availability of Epicor 9 in more than 50 countries and 30 languages by the end of next year."
EPIC next generation ERP-system
Tuesday, February 17th, 2009
3:56 pm
Need report developer
Bank in Pleasanton, CA.
Must pass a 30-minute SQL test.
Must be willing to put up with me for a boss.
No sponsorship.
Details on request.
Wednesday, January 28th, 2009
10:07 am
Calling all VBA programmers...
Hello All,

I need some help with two situations. I work in Access 2003 in a hospital research environment.

I am trying to have a command button on a data entry form (with several subforms) that will allow the user to Lock and Unlock ALL the fields from data entry (with the exception of the command button, of course), instead of writing code for each element individually. I will need to use this on about 20 or so other forms, for individual research studies.

I am also trying to have a command button that will allow the user to specify where to save an excel export, kind of like a Save As pop-up, but I don't want the user to specify the file name, as it is something I want the code to define. (I have the file name already specified as the UserID and Timestamp)

Any help will be GREATLY appreciated!
Thanks in advance!!!

Current Mood: curious
Saturday, December 20th, 2008
1:47 am
Postgres question

Give me please an example of table dump (made by pg_dump) which have column with OID type and some bynary data.
Wednesday, October 29th, 2008
11:16 am
export question
Hello All...

Here's a doozy of a situation. I am working on an Access database of hospital patients that needs to export each record as a separate Text file so it can then be imported into a different system accessed hospital-wide. Sadly, the other system requires that it be individual files per record.

I have all the specs for the text file worked out, and the export specification, but having difficulty with the next step.

What I am trying to do is set up a VBA routine for each file to be named at the time of generation automatically via a timestamp and some unique identifier, either an autonumber or some combination of characters that will keep the files unique in the event that the export be run again (which will happen, and need to be addressed as separate entities).

Anyone have any suggestions?

Thanks in advance!

Current Mood: curious
Thursday, July 17th, 2008
2:12 pm
From 27k, EC1 London

A company I have trained for are looking for an IT trainer , you would train B2B groups in how to use Office programs to an advanced level.

If you are interested FB me or email me world_of_cat@hotmail.com and I will send you a job spec. It's an immediate start after interview and refs.

If you are unsure of what it means to be an IT trainer, email me.
Thursday, December 13th, 2007
11:33 am
SQL Question Emergency
I have a quick question about T-SQL syntax - anyone got a minute?

I need to do an update query - such as the one below (example from http://doc.ddart.net/mssql/sql70/ua-uz_3.htm)

SET ytd_sales = t.ytd_sales + s.qty
FROM titles t, sales s
WHERE t.title_id = s.title_id
AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)

This one says to update the value in the Titles table based on a value in the Sales table, and I'm clear on this part.

My question is, can I use that FROM clause if I'm not pulling the value from another table. More specifically, can I do:

SET ytd_sales = "Not Availbable"
FROM titles t, sales s
WHERE t.title_id = s.title_id
AND s.ord_date = Getdate()-1

Basically, I want to use that FROM in order to limit which values get updatebased on thier related values in another table. However, I'm not setting hte field equal to a value in that table.....

I know this might not sound urgent, but it really is.

X-Posted everywhere i coudl think of. Sorry!

Current Mood: crappy
Wednesday, December 12th, 2007
5:19 pm
Access Imaging help
Hello all!

A few weeks ago I posted regarding OLEs vs. BLOBs.... Thanks for the replies.
I tried BLOBs as per the recommendation, but unfortunately it wouldn't work for me and ended up using OLEs.
I got it to work on my computer just fine - I am able to bring in the image to the form, and have the image appear on printouts. When I try this on another computer, all I get is the file name appearing. I am pretty sure I'm using the same version of Access, but was wondering what else could cause that situation, and what I need to do to fix it. The client seems to be able to see the images, but is having some difficulty getting used to the process and hasn't been able to get it to work a second time.

Any guidance is greatly appreciated.

Current Mood: frustrated
Friday, November 9th, 2007
4:36 pm
Image help
Hello All... 

I'm working on an Engineering database which requires the part image be brought into the database. They only have jpegs, which is fine. They'd prefer it as pdfs, but I haven't been able to figure that part out.

In short, the user needs to be able to add the part image as parts are entered into the system.
They also need to be able to update the image and identify that there's been a revision.

This is a database that I will not be maintaining on a regular basis.

My question: I have a template that gives me a few options in bringing the image in - BLOBs and OLEs. Is one better than the other? I'm clueless at this stage, travelling new territory with this project. HELP!!! :)

Thanks in advance
Saturday, October 20th, 2007
8:12 pm
Many-to-many in Access?
I'm new to Access and would like a little reassurance I'm on the right path...

My form will have the date, along with a list of items from a table. I want basically a list of checkboxes for each of these items. I want to track over time the frequency each of these items were checked.

Am I right to think this is a many to many situation..as the date is tied to numerous items for checking, and each item for checking can be tied to any number of dates?

There is all of one paragraph about many-to-many setups in my book, and I'm not sure their illustration works the same way I'm thinking. If anyone can provide some assistance on a many to many setup, or at least setting me on the right path if I'm not, I'd greatly appreciate it!
Wednesday, August 29th, 2007
9:21 am
T-SQL field aliases
Is there a way to use field aliases in T-SQL  like:

    (field1 + field2) as myNewField  - - declare some calculated field with alias
    , myField*2 as myDoubleField - - use it in expression for next field
where myDoubleField > 1 - - use it in where clause

Tuesday, August 28th, 2007
12:20 pm
SQL Prettification?
phpMyAdmin parses and prettifies complex SQL with formatting and color (e.g., right). I cannot seem to copy-and-paste this to a rich-text document, e.g., GMail, GDocs, etc. (Yes, I tried looking at the HTML source.) Ideally, I'd like to have the general case, where I can select a portion of any arbitrary webpage and copy/paste the formatted data (which does work 95% of the time). But for the moment, does anyone here know of a SQL prettifier, ideally online, that will allow me to just copy/paste?

I'm using Firefox and the current versions of Google Docs and GMail.


(Cross-posted to databases, d4b.)
Friday, July 13th, 2007
5:41 pm
Hey everyone!

Newcomer here :)

It's been a while since I used Microsoft Access, and I feel more than a little rusty... I want to make a database to organize my cds. Any chance anyone have a finished database I can use for this?
Wednesday, February 7th, 2007
4:45 pm
Building Hours/Hours of Operation
I'm trying to figure out best to handle building hours in a DB. The buildings all have default hours (e.g. M-F 8:00 - 19:00, Sa. 10:00 - 17:00, Su. closed), but may also have exceptions to the posted building hours, e.g. during holidays it may have shortened hours or no open hours at all.

Should I create separate tables for default hours and exceptions?Collapse )

I feel like I'm overlooking a solution that is elegant, simple, and obvious—I'm willing to settle for any one of the three.
Wednesday, January 17th, 2007
5:55 pm
SQL Help
Hey guys (and gals) I need a little SQL help:

I have 4 tables: Players, Books, Events, and Player_Events. The Player_Events table details which Player will play which Book at a particular Event. It is possible to have more than one Player per Book at the same Event, and it is also possible to have no Players on a Book for an event. I need to construct a query which will return "Who is playing what book at this event" but here's the catch.. I  also need it to return a row for any Books for which there is no Player assigned and leave a Null value for Player.

As you can see in the sample data below, there is no one scheduled to play Drums at the Smith Wedding. No record exists to indicate this in the Player_Events table. The only logic that dictates this fact is that there is in fact a Drum Book in Books and no reference to it in Player_Events.

The only solution I can think of so far is to create a function that automatically creates records in Player_Events based on a proposed Default_Book_FK column in Players, but I really don't want to go that route if I can avoid it. Any help is appreciated!

Desired Query:

Who Is Playing The Smith Wedding? Query

Book_FK Player_FK Event_FK
Joe Blow Trumpet The Smith Wedding
John Boy Trumpet The Smith Wedding
Some Guy Sax The Smith Wedding
[Null] Drums The Smith Wedding
... ... ...


Player_ID Player_Name
1 Joe Blow
2 John Boy
3 Some Guy
4 ...


Book_ID Book_Name
1 Trumpet
2 Sax
3 Drums
4 ...


Event_ID Event_Name Date
1 The Smith Wedding 1/1/2000
2 ... ...
3 ... ...


Player_Event_ID Player_FK Book_FK Event_FK
1 1 1 1
2 2 1 1
3 3 2 1

Tuesday, January 16th, 2007
8:43 am
table design issue
Hi everybody,

I have a table design issue. There are some sets of files that need to be handled as one file:
  1. File1.avi
  2. File2.avi
  3. File3.part1.avi
  4. File3.part1.avi

File3 is logically one file, but is split up into two parts.

I need these files to map to films, in a many-to-one relationship (many files to one film).

I've created the following tables:
  • a FILES table, holds all files
  • a FILMS table, holds all film descriptions
  • and a relationship table FILES_FILMS {id, file_id, film_id}.

And I can't get the following (logical) select result:
film1_id, file1.avi
film2_id, file2.avi
film3_id, { file3.part1.avi, file3.part2.avi } <-- that's an array, a "set" of files.

So: how do I gather the the files file3.part1.avi, file3.part2.avi into one group?

Should I loop through the results in of a query with Group By clause?

The best solution I could come up with is having a fourth table GROUPS to which the Files table maps to, in a many-files-to-one-group relationship. Then I can map the a group row to to the Films table, one-to-one, and when doing a select on the Films table, do a join with the groups and the files tables. But I believe I'll need to do on-client looping through the results anyway.
Tuesday, December 12th, 2006
7:20 pm
x-posted to sqlserver

As part of our current SQL setup we've got an extended proc that calls a C++ DLL to generate a unique id for all db calls. This unique id is use as a primary key on a logging table that is inserted into (along with user id, destination stored proc and any params) prior to running the users call. Also this unique id is added to the params list and passed on to the destinition stored procedure. Finally the logging table is updated with the return code of the call.

Unfortunately this DLL won't work under SQL 2005, therefore I'm rewriting as part of the upgrade. That isn't the problem. The problem is one of the DBAs asking why we just don't use an Identity column on the logging table. TBH I couldn't think of a reason why not, especially if we use SCOPE_IDENTITY rather than @@IDENTITY. The only reason I could think of is historical, ie the original developers didn't trust SQL Server to handle the load (the DLL has been used since at least SQL 6). Can you think of situation where the use of an Identity column would fail?
[ << Previous 20 ]
About LiveJournal.com