Programming SQL

Returning a range of serial numbers when consecutive, otherwisea range of one.
Here is one solution. It is a method of subtracting two sequences, one without gaps and one with gaps to create grouping factor: SELECT custid, itemid, MIN(serialnumber) AS minserial, MAX(serialnumber) AS maxserial, COUNT(serialnumber) AS countserial FROM ( SELECT A.custid, A.... 17 Jan 2010 22:51

SQL 2005 Certification exam
Hi Naveen This guru form Tamilnadu. Am interested to SQL 2005 Certification exam, can you please guide me if you have any dumps please send me this helpful for me. my id gurusewack(a)hotmail.com Naveen wrote: MS SQL 2005 Certification Dumps 26-Jul-08 Hi, Pelase find the MS SQL 2005 Certification Dumps ... 17 Jan 2010 01:56

Best way to persist alter table changes in my local DB to web host
Hello. Using SQL Server 2008. I'm developing on my local PC with a copy of the DB that is contained on a web host. Is there a good way when I do an alter table on the local DB to export that change to the web host DB and have "semi-automatically" apply the change to its copy of the table? ... 16 Jan 2010 17:15

Problem with DECLARE CURSOR
Dear Sir, I am using SQL Server 2005, Visual Basic 6 (SP6) & Microsoft ActiveX Data Object 2.5. If I run following query through SQL Server 2005 Management Studio through QUERY only then it works FINE. But if I run from application using Execute method of Command Object of ADO then it process maximum 49 rec... 19 Jan 2010 10:10

Having divide by zero error
Hi, I have the following formula which is given the above errorl ROUND(((orders.qty / finished_parts.psets) * finished_parts.pqot_cyc) + finished_parts.setuphrs, 2) AS EstRunHrs1 I would appreciate any help for resolution of the above. Thanks. ... 16 Jan 2010 09:31

Code and Creation 60240
This is a free and informational site I created for application development and application development source on the net. Enjoy, and it's free, nothing to register oir sign up for just an informational site. http://codeandcreation.com l%Y)S+lP$*WKUy*dXX/efx/c( ... 15 Jan 2010 13:52

Code and Creation 74116
This is a free and informational site I created for application development and application development source on the net. Enjoy, and it's free, nothing to register oir sign up for just an informational site. http://codeandcreation.com qOUl^pa,/gKt)&.**f$dDSL>e ... 15 Jan 2010 13:52

query help
I am reviewing some old code and the below query is the one I like not to use subquer. Is there a different way to write this query? update tblProduct set ProductCatory_name = 'Hard' where ProductCat_id =400 or ProductCat_id in ( select pdt.productCat_ID from tblProduct as Pdt where pdt.ProductSource_ID =... 15 Jan 2010 20:34

Question on SQL Server 2008 and MS Access 2003
Hi, I just installed a new Windows 2008 Server( 2 CPU X Quad Cores), and I found it's a 64-bit operation system. We have SQL 2000 (32 bit) running on the Win2008 Server temporarily, but I'm thinking replacing the SQL 2000(32 bit) with the new SQL Server 2008(64 bit). However, most of our clients are using th... 15 Jan 2010 03:55

Function sequence error when attempting to write about 32K to varBinary(max)
This occurs in a Native Client application on either SQL Server 2005 or 2008. Does the data have to be written in chunks or am I binding the column incorrectly. I've been looking for examples in the MS doc online, but it is very sketchy. ... 14 Jan 2010 22:31