- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 3
- Downvotes Received
- 2
- Posts with Downvotes
- 2
- Downvoting Members
- 2
124 Posted Topics
 | > Set @fromdatetime =dateadd(day,datediff(day,0,'2012/06/04'),'00:00') > Set @todatetime=dateadd(day,datediff(day,0,'2012/06/05'),'00:00') The declaration looks fine but for the instantiation you could remove the dateadd functions and use a format that can be converted to express minutes/seconds. I think this would work a smidge more efficiently. DECLARE @fromdatetime DATETIME, @todatetime DATETIME SELECT @fromdatetime = '2012/06/04 … |
| | Modifying this query to satisfy your metadata should remove the duplicates using a self-join. SELECT name, ID, [date], gender, birthday FROM <tbl> T INNER JOIN (SELECT ID, MAX([date]) MaxDate FROM <tbl> GROUP BY ID) T2 ON t2.MaxDate = T.[date] AND t2.id = T.id It appears you're querying against data that … |
| | SELECT A.ATTENDANCE_ID, P.PERSON_ID, P.FIRSTNAME, P.LASTNAME FROM DBO.ATTENDANCE A INNER JOIN DBO.PEOPLE P ON P.PERSON_ID = A.PERSON_ID WHERE P.FIRSTNAME = 'JOHN' AND P.LASTNAME = 'DOE' AND A.ATTENDANCE_ID = (SELECT MAX(ATTENDANCEID) FROM DBO.ATTENDANCE WHERE PERSON_ID = P.PERSON_ID)  |
| | > My question are: > 1. can I still create SSRS/SSIS. > 2. i have existing RDL,RDS file. still can open it to 2008 express. Answers: 1. You can create all the SSIS you want, but the functionality of the SSIS runtime on express edition is incredibly limited. Basically anything … |
| | > object_id index_id avg_fragmentation_in_percent page_count **> 1801213617 0 82.9268292682927 2718** > 1801213617 2 0 369 > 1801213617 3 0 250 The bold record is a heap. (table without a clustered index, which can't be organized. The way you can tell it is a heap is from the index_id column: Index_id … |
| | Hi Yomet, you might want to try something like this and reduce or integrate the xp_cmdshell call. DECLARE @LSName VARCHAR(50) SET @LSName = '' --linked server name BEGIN IF EXISTS (SELECT 1 FROM sys.servers WHERE is_linked = 1 AND name = @LSName) BEGIN BEGIN TRY SELECT 1 FROM --use distributed … |
| | The problem is you are looking at a heap, which can't be organized. This is of course providing that the query you executed returns simliar results to 2008/2005 queries... IndexID of 0 = heap IndexID of 1 = clustered index IndexID >= 2 = nonclustered index Here's an article on … |
| | I agree with the opinion of others here, Identities are typically created to be retained...regardless of logical sense. Most database devs that use identity columns use flags instead of removing data from the database. It makes life easier because you don't have to worry about deletes and updates...restoring from backup, … |
| | Hi there, I'd use a webservice to handle that logic if possible. The web service can poll every 5 seconds and cache the results to answer the client requests. Is this possible in your situation? |
 | Re: download My.Computer.Network.DownloadFile(Address as string, DestinationFileName as string) Read up and make sure you're assembling the strings properly if this is how you are constructing the statement. [url]http://msdn2.microsoft.com/en-us/library/ack30t8y(VS.80).aspx[/url] :) Note how in this example they include a protocol, path, and file name. My.Computer.Network.DownloadFile _ ("http://www.cohowinery.com/downloads/WineList.txt", _ "C:\Documents and Settings\All Users\Documents\WineList.txt") |
| | I have a feeling you're going to have to use a cursor to get that kind of result. Read up on them, it should be pretty easy, but keep in mind they are a bit slow if you're using a lot of data. |
| | Additionally, if you have to perform this task any more, its quite easy to build a SSIS package to do it for you. That way having a fresh new Access DB is only a click away. |
| | Re: Rfid wow...this is kind of up my alley here. Ok first, you need to read up on the protocol for reading/writing to and from the read/writer and create code that will assemble protocol-structured statements and pipe them out over the serial port. Once you've got that done its really simple. In … |
| | Look in your VB2005/Projects/<ProjectName>/debug/ folder you should see a exe in there. That is the debug exe. This article may help too :) [url]http://support.microsoft.com/kb/304654[/url] Jon |
| | Hi Strangeloop, That really all depends what you plan on doing with SQL. Are you an IT Amin/Engineer or are you a programmer, if coding...what langauge? Jon  |
| | Yes...keep in mind you can't do arithmitic operations with null values. |
 | Vista clients can be configured to prevent this theft possibility. As a previous poster pointed out, yes good treatment of employees is a great practice for infosec but sometimes this comes down to dollars and potential profit for the thieves. Great article. |
| | Good article, interesting to see how all those hours add up. |
| | Indeed...most companies tend to strategically word publications and press releases in their favor (Symantec, F-Secure, Sophos, various linux distros, to name a few). Don't let your hatred for Microsoft impair your judgment. Sometimes a comparison is a good selling point and helps prospective buyers and shareholders paint a mental picture … |
| | Good Article. That's just bad journalism to seize an opportunity to bash the White House when the President is working hard to fix this subprime issue. I guess now we know how credible and what kind of a bias Yahoo has. Honestly if the Fed wasn't as good as it … |
| | Good Article. If I was to have done something like that when I was a kid I would be in for it! |
| | Woohoo! About time someone did something about this! I had to pay Sprint buku bucks to early terminate a contract on 5 phones where they changed terms of service overnight and quadrupled my family plan bill (sometime around the Nextel merger). I ended up going over to Cingular because they … |
| | I don't think its Dell's responsibility to cram linux down the throat of its consumers, especially considering profits are greater by installing a MS Operating System. As indicated earlier Dell will incur additional support costs with negative returns to scale and also risk damaging their reputation by soliciting Ubuntu to … |
| | I would think the consumers would have realized someone was going to have to pay for the marketing hype of the iphone and should have expected a significant price drop within months of the initial release. Good for Apple, now let’s see if they want to move into gaming consoles … |
| | Great article! Rare find in an IT community but being an eco-friendly person I find it relevant and would like to see more done in alternative fuel research/development. If this is as good as what it sounds it'd be nice to see it actually happen. Note: Prius != Honda |
| | Does your Apple client have a spell check button? :P Good article, I agree there has been notable innovation recently from Apple and Google. Either case, product improvements from any and all of these companies (and the FOSS community) contribute to our technological development as a whole, albeit lately everyone … |
| | I don't think MS has innovation problems, but I'm sure there are plenty that would say otherwise. Microsoft is a Corporation whose objective is to make a profit and bring happiness to its shareholders. Web apps are useful indeed...for typing up non-confidential documents on a free platform. In Corporate America, … |
| | MS has had clustering available for years now xlinuks... |
| | Skype took a customer relations course from Symantec? :P |
| | It looks to me like Privacy International is playing with fire although I do find Google's response a little inappropriate. |
| | Terrible...that's all I have to say.  |
| | Interesting article! I can understand why some buy in-game currency... With the limited time resources we have, dedicating hours upon hours of generating wealth can be a hassle. Instead of spending 50% of the 6 hours you have available during a week to gathering, you could have 100% of that … |
| | |
| | Informative Article! I could use something like this (a casual photographer) to bring my amateur-like photos to a professional level and to modify focal points to enhance portions of the image sometimes realizing after shooting may give more value to the photo. |
 | |
| | "Reporters posing as children between the ages of 10 and 14 were exposed to a bombardment of sexually explicit messages from adult men within the Skype chat sessions. One 50 year old man arranged to meet the ‘girl’ at a railway station, and the Sunday Times witnessed him turning up …  |
| | One of my friends had his blog shut down becuase of this rule. He is serving overseas as a Reconnaissance Marine and has had his blog/website up for years without incident. Its funny how the govt will trust him (as they trust all Recon Marines) enough to drop a $40k+ …  |
| | My grandmother once told me "if you don't have anything nice to say don't say it at all", but this time I'm compelled. Author: Have you provided any documentation as to power consumption Vista vs XP? Have you provided any documentation as to power consumption Vista vs Kubuntu vs the …  |
| | I think this idea is great as well, but the only competition is going to be between Dell call center associates and who is going to answer the next Ubuntu call. Just think about the niche Dell has...cheap PC's. So next year 20,000 frugal people will buy a Ubuntu Dell … |
| | Software Darwinism at its best :) |
| | Ladies/Gents... Please don't go crazy here but there are significant advantages to Vista. At nearly the same price (OEM) I don't think MS is scaring people away, except those that are afraid/reluctant to change.  |
| | I agree with the author about the anti-Vista advertising. The Apple commercials yes may be humorous, but are misleading and slanderous. Just think, an operating system reducing itself to using advertising tactics like that of politicians.  |
| | Hi Athersgeo, Believe it or not, this is a feature of SSIS. The best way to handle flat file importing is mapping the flat file connection EXACTLY the way the file is mapped and configuring the source to perform how you want it to when anything different presents itself (failure … |
| | Hi there. Have you by chance attemped any type of batching? I'd queue up the record and try to batch them first, say 50,000 recs for each batch? See if that makes things any easier and let us know what you find. EDIT: Also check your disk I/O. You can …  |
| | This old function I made may help as it demonstrates the concepts of looping with SQL (without a yucky cursor!). [CODE="SQL"]CREATE function [dbo].[fn_Is_Uppercase] (@string varchar(1000)) returns bit as begin declare @r bit declare @l int declare @i int --trim it up set @string = mrm.dbo.trim(@string) --need to check every character … |
 | [URL="http://msdn.microsoft.com/en-us/library/ms189461.aspx"]This[/URL] may correct the issue if implemented correctly, and at the same time eliminate the need of your functions. To correct the function and not use an Over Clause, just make sure you search for that particular string/value in the field before you insert into it into the destination column. … |
| | Re: SQL Query Help Wow. Few issues I noticed with this: 1. There is no group by clause. You'll want to group by Cardno and cardeventdate when trying to aggregate. 2. Look out in your where clause!! 2A. You are passing a zero padded integer to compare to a nvarchar. Not typical programming, and … |
| | Look through the metadata functions available in your database. Specifically, the columnproperty() function looks like it may be of some use for you. As suggested earlier the question was a bit vague. You might be looking for some of the functionality sp_help provides. In that case, you can peek through … |
| | Hi, Could you provide us with a few sample rows of data. SSIS/DTS should be able to do the trick (commonly work with CSV data), we just need to see the data so we can put you in the right direction. |
| | You need to use the logic in the SP to concatenate a dynamic SQL query, then execute the query. Right now you know your parameter is going in right, you just now have to concatenate properly and execute a dynamic SQL query :) |
The End.