655 Posted Topics
 | I have recently been informed by my boss that I am to be made "Director of Service Transition". Since I only have my ITIL Foundation Certificate in Service Management from 2006, I have a lot of reading to do. Are there any ITIL adopters out there who have stories to … |
 | Some other classics: "ToDo" list: Show a list of appointments for the day/week/month (bonus: sort by date/topic/importance) "Budget": Here's how much money I have, and here's how I'm going to spend it. "Shopping List": Here are the products I use and here's how much I have left, generates a list … |
| | Could be simpler. Here's a snippet of SQL code that you can run in your query tool of choice (I'm assuming MSSQL). You'll have to change to appropriate variables to construct your C# database call (I'm not a C# guy, sorry). [CODE]declare @arrival as varchar(12) declare @departure as varchar(12) select … |
| | I think what you are trying to accomplish is a PIVOT or CROSSTAB. If you are using SQL2008, you can go to Books-On-Line and investigate the syntax as it has been incorporated into T-SQL. If you are using SQL2000 or SQL2005, look at this link: [URL="http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables"]http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables[/URL] Some clever fellow wrote … |
| | IBM 370/H148, DOS/VSE, ICCF, CICS, COBOL, 360 assembler What are these newfangled things called "personal computers"? ;) |
| | |
| | You might try updating stats (check BOL for syntax) as an immediate thing. One indexing strategy is create a partial index (i.e. not a complete unique index) for the tables in your most-used queries. That will get you halfway on speed of retrieval without sacrificing performance on updates. Another possibility … |
| | It's kind of hard to tell anything without knowing what your data structures look like, but just from eyeballing you statement it appears that your ship date comes from the shmast table (which I assume is either about a ship or a shipment). I'm going out on a limb here, … |
| | Hmm..."Where Not" is probably not a construct you want to use. We'll bypass that for the moment and get straight to your syntax. Inside the "WHERE NOT" construct, you are surrounding you column names with single-quotes. That instructs the parser to treat them as literals rather than column names. Not … |
| | The problem is the "dash" in the middle. You'll have to do something about that. Here's some sample code to demonstrate how you might handle it: [CODE]declare @myBadDate varchar(25) declare @myGoodDate varchar(25) declare @myActualDate datetime select @myBadDate = '20110319-04:30:00.772' select @myGoodDate = substring(@myBadDate, 0, charindex('-', @myBadDate)) + ' ' + … |
 | Not sure what you mean by "form name". The Name attribute for every child form of the same type will be the same. One possibility if you're looking for a way to identify the forms is to use the frmD(Index).Tag property and populate it with something useful when you instantiate … |
| | I'm making a couple of assumptions about your table defs and data just for the sake of testing, but here's what I came up with: [CODE]select a.m_name, b.bookingdate, c.* from dbo.member a inner join dbo.booking b on a.memberid = b.memberid inner join dbo.session c on b.sessionid = c.sessionid where c.activity … |
 | Re: Good .ISO Burner If it's for Windows, I'd use InfraRecorder. You can find a link to it on (of all places) the Ubuntu web site. |
| | Bad login or password. [URL="http://msdn.microsoft.com/en-us/library/cc645917.aspx"]http://msdn.microsoft.com/en-us/library/cc645917.aspx[/URL] Are you sure you have the password correct for "sa"? Do you have the caps lock on? Did you accidentally delete the "sa" login? Are you trying to connect as "sa" when you shouldn't be? You aren't providing a lot of information about what you're … |
| | The title of your thread and the body of your question don't really match. If your boss is asking you to create a ROLLOUT STRATEGY then he's asking for a plan of how to go about deploying your system when it's done, not a specification of what the system is … |
 | I miss vinyl LP's, and laying on my bed looking at the album art and inserts while listening to the music on a lazy spring afternoon after school. Anybody ever try to look at the cover art for Elton John's "Captain Fantastic and the Brown Dirt Cowboy" when it came …  |
| | There are a couple of ways of doing this depending on how deep you want to get into SQL Server security group setup. I'll assume that you don't want to go that way because it can get messy very quickly, so I won't go into it. The method you suggest … |
 | You need to put "end" at the end. A "case" statement requires that. [CODE]case when dbo.SC331000.SC33013 > dbo.SC011000.SC01049 then dbo.SC331000.SC33013 else dbo.SC011000.SC01049 [COLOR="Red"]END[/COLOR][/CODE] |
| | On line 14 you have to use the cstr function to force the Variant to be a string: [CODE]NewArrayKey0 = cstr(NewArray(0))[/CODE] |
| | It has to do with how the login is set up. If you can connect to the SQL engine with some other SA login, go to the login properties of the login having problems and fix it there. Since you are using SQL2000 terms, I'll assume it's SQL2000? Anyway, open … |
| | The situation you describe is very similar to one of the classic database design conundrums: the Product Assembly Hierarchy, colloquially known as a "parts explosion". Think of a car. A car has a chassis, an engine, a body, an interior, etc. The body is made up of frame, doors, hood, … |
| | Check out the Embarcadero tools for reverse-engineering databases into diagrams. I've used this type of graphical tool for years. They can be a bit pricey but if you're serious about data design and documentation, they're a must. They really help you identify an overall layout of the "data landscape" and … |
| | Re: Gift book! Help Not a "gift book" per se, but definitely worth reading to anyone who works with computers. [URL="http://www.canonical.org/~kragen/tao-of-programming.html"]http://www.canonical.org/~kragen/tao-of-programming.html[/URL]  |
| | Please post the connection string value. |
| | Try this: [CODE]SELECT payroll.empid, employees.firstname, payroll.basicpay, payroll.allowance1, count(month) as monthcounter FROM payroll INNER JOIN employees ON payroll.empid = employees.empid WHERE payroll.year=2011 GROUP BY payroll.empid, employees.firstname, payroll.basicpay, payroll.allowance1 ORDER BY payroll.empid[/CODE] |
| | Re: Creating tables And don't forget to include that payment type flag as part of the primary key, to ensure that there's only one of each type per booking! |
| | Look at the Event viewer (should find it under Administrative Tools in Control Panel). There should be more details under the Application section, or possibly under the System section. Look for the events that have to do with MSSQLSERVER and follow the instructions. |
| | It looks like you stopped one step short in your normalization. You appear to have a many-to-many situation between Employment and SpecificProperties. Create a resolution table between them to fix the many-to-many, and you should be fine. |
| | |
| | It depends a lot on what type of data. If it is structured data (think "Spreadsheet" or "Lists") then it's worth trying to design it as an RDBMS table structure, with appropriate version data tacked on. This limits its flexibility as far as any user being able to upload any … |
| | There are two things going on here that you may want to look at, but only one has to do with your original question. I'll answer that one first. When you specify "Select *" you get as column names ONLY the column name. So if I have table1 and table2, … |
| | Your "If..." statement on line 10 has no condition for breaking out of the loop. You don't even really need a "Do...Loop" here. It's an event-driven program and this event procedure has a single number to process. Your testing loop is inside the IsPrime function (where it is appropriate).  |
| | This has been an ongoing debate ever since relational database engines were first created. On the one hand, you have the group that says "Data integrity outweighs a minor speed reduction." On the other hand, you have the group that says "Speed is most important...don't slow it down for anything...we'll … |
| | Not sure what dialect of SQL you're using, but the one I know says that using SELECT...INTO... creates a table, not a variable assignment. perhaps you should try: select temp = unavailable_date from unavailability where mechanic_id = mech_id; May work, may not...worth a try? |
| | No, make RowNum, ColNum primary key, CellValue a non-key column. No rule that says a key column has to be an integer, so you could have your RowNum be float or real. Or just have a non-significant key column, with RowNum, ColNum be an alternate unique key. Query as "select … |
| | I rebuilt your code line by line from your listing above, and it worked fine. The only thing I can suggest is to use debug.print, step through execution, trap your generated SQL statment and execute it manually in Management Studio (or Query Analyzer, as the case may be), and check … |
| | Another thing you might check is the Server Properties for your instance (requires you to log on to the server). Under the Connections tab, make sure the Remote Server Connections is enabled. I think Developer Edition has this unchecked by default, as Developer Edition assumes the instance is only used … |
| | Excellent questions you have. This very scenario is one of the reasons to separate logical design from physical design. What you might find is that if you complete a logical model there could be a better way to segregate your physical data than by just following your logical model. I … |
| | Just a little more background information on why the number of green bits is larger than the other two: (Excerpt from Programming Windows, Fifth Edition by Charles Petzold (c) 1998, Chapter 14, "Bitmap Dimensions") <snip> In recent years, full-color video adapter boards have become quite common. These use either 16 …  |
| | Re: Chess Boxing Kinda made me think of this: [URL="http://en.wikipedia.org/wiki/Battle_Chess"]http://en.wikipedia.org/wiki/Battle_Chess[/URL] However, I don't think you could do it with programming...ever try to type with boxing gloves on? ;) |
| | Okay, I'm going to put in my 2 cents worth. Some assumptions on my part: 1. You don't necessarily have all three nodes; i.e. you could have 1.1, 1.1.1, 1.1.2, 1.2, 1.2.1, etc. 2. You never have more than three nodes; i.e. you never have "1.1.1.1" 3. All the nodes … |
| | Re: VB6 Save Dialog Can we assume that cDialog is the name of the common dialog control on your form frmRutaExcel? If so, then the bolded line should read: [CODE]eRuta = frmRutaExcel.[COLOR="Red"]cDialog[/COLOR].FileName [/CODE]  |
| | If I recall correctly, any time you specify a date literal in MSAccess SQL, you have to use # as your delimiter rather than quotes (e.g. #4/11/2011#) otherwise it gets treated as just another string...then you run afoul of all the nasty date formatting issues such as 4/11/2011 <> 04/11/2011 … |
| | I would add one thing to the course/pre-req table structures...a second identifying relationship between Course and Pre-req. Here's the rationale: If you think about the "pre-req" as defining a relationship between two courses, one course might have many pre-requisites, and one course might be a pre-requisite for multiple courses. So … |
| | Re: Code ?? Just a quick critique. By item: A. Good. Just be aware that this will be indexed as aScores(0) through aScores(9) B. No need to redim if it isn't changing the array size. You have a "FOR" with no "NEXT". You cycle through from 1 to 10. You should be cycling … |
 | |
 | You'll have to go into the setup program generated code. I have to look and see the directory...will post in a bit... |
| | Judging from your post, you seem to have some unrealistic expectations for your application. I'm not trying to discourage you, just point out that it's not as easy as you imply. Here are some things to consider: First and foremost, in order to connect to a database you kinda have … |
| | You might also check into PostgreSQL. It too is free, it has both Windows and Linux builds. Here's a link to an interesting comparison wiki: [URL="http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL"]http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL[/URL] |
| | Assuming you're using SQL2005 or SQL2008, this should do the trick: [CODE]select a.name as ParentName, c.name as ChildName from sys.tables a inner join sys.foreign_keys b on a.object_id = b.referenced_object_id inner join sys.tables c on b.parent_object_id = c.object_id [/CODE] If you're using SQL2000 (yes, people still do that) you'll have to … |
The End.