cutepinkbunnies

Hi Guys, Here is my requirements: I need to pullout records based on datetime fields ranges from 12 am in the morning of 2012/6/4 and 12 am in the morning of 2012/06/05. kindly please check my declare parameter for date if it is correct. Thank you in advance. Data: Declare …

I have a bunch of records that I get from doing multiple joins. # Name, ID, Date, Gender, Birthday # John Doe 111 01/02/2003 M 01/01/2001 Jane Doe 222 03/04/2005 F 02/02/2002 Jane Doe 222 **03/05/2005** F 02/02/2002 Jim Doe 333 07/08/2009 M 10/11/2012 What I am trying to get …

Hello, I have a MSSQL database with a table called "people" and a table called "attendance". The people table contains the person's ID (primary key, identity increment), last name, first name, and active fields (I would only be interested in grabbing fields where active = Yes). The attendance table contains …

Guys, current im using MS SQL 2005. today they will change it to MS SQL 2008 express edition. My question are: 1. can I still create SSRS/SSIS. 2. i have existing RDL,RDS file. still can open it to 2008 express. Thanks. Jonel

I have a nightly SSIS package that reorganizes indexes that are between 10% and 40% and then a weekly package that rebuilds for anything over 40%. But Ive noticed a lot of table do not change. Example below my Location table below is just about always at 82%. Am I …

Hi all, Here's to hoping that a SQL Server guru is hiding among the ranks of DaniWeb members. I have two servers, DB01 - the production database server and BKP01 - the backup server, that are in two different geographical locations. Since some queries on DB01 are accessing BKP01 there …

Hi, We have an SQL Server 2000 with one 138GB database currently used. I am worry of the performance because as time goes it becomes slower and slower. So I tried googling out the solution and I found out the DBCC Reindex command. As what I read, first you have …

Is it possible to reuse an identity field value after deleting rows in SQL Server 2005? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. …

Hey All, Context: I am creating a feed for work, similar to facebooks, that hits the database every 5 seconds to see if an update is made and if so returns the results to the feed. The problem I have is that we have over 35,000 users and if they …

i decided to make a download program, i have a form 2 textboxs n a button, i looks somin like this Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click My.Computer.Network.DownloadFile((TextBox1.Text), (TextBox2.Text)) End Sub it aint workin cos of ` A valid address should include a protocol, …

Hi I m Having a Problem in retrieving records. I want to get nth maximum value in a column. I have tried it using top select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc) But i m getting all the n records. Any …

Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ?

hi guys.. i need to read tags using rfid reader. the reader is connected to the computer using serial port. can anyone advise me the codes for receving the tags data? i'm using microsoft visual studio 2005. thanks. your help is appreciated.:(

Hi, i've been working on a couple of vb.net projects, but i've been unable to make an executable project.is there a way i can go about this?? Please Help! Thanks

Hi, what would you recommend as the best book for someone *new* to SQL and SQL Server (specifically 2005, Developer version)? Thanks!

I have Column named 'Price' in a table.I want to update the 'Price' Column by adding 5 .But i have some Null values in 'Price' Column.Whenever i update the 'Price' Column.All Values Updated Except the Null Values Column.So how can i update the null Column.Pls Help Alok

[URL="http://www.checkpoint.com"]Check Point Software Technologies[/URL], developers of the ZoneAlarm security range, has announced the results of research which suggest that half of all staff will happily walk away from employment with competitive information about your business in their pockets. That they are walking straight into another job with it should be …

If you have ever spent a few minutes looking for an email that the sender swears they sent the week before, but seems to have vanished into the ether now, then you are not alone. A new report by [URL="http://www.emedia.co.uk"]e-Media[/URL] for [URL="http://www.mimecast.com"]Mimecast[/URL] suggests that IT managers in the UK alone …

Not one to sit back and reflect quietly upon its moments of glory, Microsoft has been making quite a fuss over the record breaking [URL="http://www.halo3.com"]Halo 3[/URL] launch. It is, Microsoft insists, the "biggest entertainment launch in history." Sales in the first 24 hours, in the US alone, topped $170 million. …

I had to shake my head when I read about the latest GDP numbers today. The news is good, maybe even great for the economy – a 3.8% upward spike in gross domestic product for the second quarter (the numbers were revised from the original GDP estimates, and were light …

The UK government has started a concerted [URL="http://yp.direct.gov.uk/cyberbullying/"]campaign[/URL] to stop what Schools Secretary, Ed Balls MP, refers to as a "particularly insidious type of bullying." According to government figures more than one third of teenagers between the ages of 12 and 15 have fallen victim to cyber bullies. Perhaps more …

Cell phone agreements have long been the bane of many subscriber's lives. Cloudy language, hidden fees, legalese traps, and contract terms that lean heavily in the favor of cell phone companies. Anyone who's been roped into a lousy cell phone contract can relate. It turns out that Congress relates, too. …

According to a report at [URL="http://www.theregister.co.uk/2007/09/07/dell_linux_ubuntu_red_hat_but_where/"]The Register[/URL] it would appear that Dell is making life difficult for UK customers who want to buy a Dell PC running Linux. Being a snooping journalist myself, I went to have a look for myself and indeed it is a lot harder to buy …

The dust has settled. The rumor mill is quiet. The masses are sated. If you've been under a rock today you probably don't know what I'm talking about, but I'll assume for the majority you've at least vaguely kept up on the slew of iPod announcements put forth by Steve …

Labor Day weekend is a busy one for travelers. Families out shopping for back to school supplies, sun-worshipers heading back from the beach, and scores of backyard barbecues and college football games to attend, all make for some serious gas-guzzling out on the nation's highways. With gasoline hovering at $3 …

Last week I wrote that I am a big Apple fan, and I am. I think its products are better than other technology companies and that's especially true of Microsoft. Anyone who's ever spent hours trying to debug a Windows-based PC or closing out pop-ups ad that appear with all …

There has been much online speculation about how Microsoft is going to head off the Google Apps free office software attack, much of it focusing on an advertising supported version of Microsoft Office. While this may, at some point, feature in the Microsoft strategy it is not going to appear …

The first interesting missive to arrive in my inbox came courtesy of the words of Microsoft COO, Kevin Turner, speaking at the July 26th Microsoft Financial Analyst Meeting 2007. Turner decided to focus his attention on Vista security, rolling out the usual 'most secure Windows operating system ever' company line …

A member of Skype staff posting in the Linux support forum there seems to have taken a course in customer relations from <insert your least favourite company here> if his responses to criticism of the lack of real world development of the Linux version of Skype, compared to Windows development, …

[URL="http://www.privacyinternational.org"]Privacy International[/URL] has accused Google of embarking upon a smear campaign within the media to discredit both PI and a report, to be published in full later in the year, which ranks the privacy performance of the top Internet service companies. The interim results which were [URL="http://www.privacyinternational.org/article.shtml?cmd%5B347%5D=x-347-553961"]published[/URL] on the 9th …