Using MS SQL Server

WORK PART TIME GET PAY OUT WEALY $100
WOW!! Get seen -- get paid! You can now get paid to drive your car, wear T-shirts, and more! Just join the EyeEarn Advertising Network and start earning money effortlessly while you go about your day! It's fun, easy, and no experience is necessary! http://www.eyeearn.com/10122618/signup ... 19 Jun 2008 01:14

Anyway to declare and use variables in a View
I have some SQL code I wrote that returns about 15,000 rows (using a group by statement, raw data is around 1mill rows). In this code I have a few variables that I declare and set. These variables for the most part are just calling functions that return a set value that I use later in my script in Where statements... 19 Jun 2008 01:14

Migration of an Access Database. How is the best way?
Hello there, I am migrating an Access database to Sql Server. There are many many problems with the access database (Schema and data) that need to be fixed in the process. What I was initially doing is writing a script which changes the schema and data as I go. I then planned to run this script when we go l... 19 Jun 2008 01:14

Connection pooling issue with pass through queries
On Sun, 1 Jun 2008 06:52:51 -0700 (PDT), "Bill E." <billmiami2(a)netscape.net> wrote: When I opened the form, I looked at my trace and voila--two calls to the same proc on SQL Server! Do you have any idea why this would be happening? For forms and reports bound to passthrough queries, Access runs the query ... 19 Jun 2008 01:14

Select from a access table
I am looking for a way to select some data from a Access database into my SQL database. In Enterprise manager, I want to do someting like: SELECT InvoiceNo, CID FROM c:\MyAccessDatabase.mdb\CIDTable WHERE Imported=0 ... 19 Jun 2008 01:14

MSDE upgraded to SP4 but showing SP2
I just upgraded my SQL 7 to SP4 (actually MSDE 1.0). I used sql70sp4.exe from the Microsoft site, ran the setup program, and everything seemed to work fine, and I restarted my system. Now the value of @@version is this: Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 14:18:16 Copyright (c) 198... 19 Jun 2008 01:14

Problem connecting to SQL Server from Access Database
Dear all, We recently migrated a SQL database from one server to another. Now, when you try to run some code in an Access Database which links to the SQL one, you get a 3704 error "Operation is not allowed when the object is closed". I think this means that the connection between the Access DB and SQL Server ha... 19 Jun 2008 01:14

Fuzzy logic for duplicate identification?
Hi, We have a table of users with about 10000 rows. We have to import a large text file into this table. While doing so we would like to ensure that if a row already exists, it should not be imported. Rather that True/false logic, we need to apply Fuzzy logic here so that if we find similarities in the name, add... 19 Jun 2008 01:14

simple SQL engine
Hello , O may ask this before. I need an SQL for learning purposes to execute examples at books. What are the most easy simple SQL engin to do that tsk . Thanks ... 19 Jun 2008 01:14

Convert Int to Date
Hi, I have a date field stored as an INT and need to convert to a date format mm/dd/yyyy. I'm having trouble determining what the starting date is. min(date) = 730395 max(date) = 733189 Starting at 01/01/1900, 730395 would make the min year 3901? Thanks for any help. ... 19 Jun 2008 01:14