SQL Server database programming

Hi, I am moving some data from a table to a text file using BCP. The data is created in a temporary table and is then moved to a global temporary table in the order of ID (this is the identity field in the temporary table). However, ...

I have an SQL select that I need to add a WHERE clause to bring back all records where SeqNo is not a whole number.  Below is my normal SQL without the WHERE clause.  Thanks. David SELECT [ID] ,[SeqNo] ,[FileNumber] ,[Subfile] ...

Is there a way to in SQL to sort outline numbers to retain the "natural order" state? E.g.: 1.1 1.2 1.3 1.10 Shows up now as: 1.1 1.10 1.2 1.3 Is there any way to use recursive functionality to check for longer ...

Hi I need to FTP a file from HP3000 to SQL 2005 server. How do I setup a user account in SQL server side to enable the FTP process from HP3000. I have the code as below:        !BUILD FTPXEQT.PUB.SYS;REC=-2,128,F,ASCII;DISC=1 ...

Hello, I have this values: 1 = value_a 2 = value_b 4 = value_c 8 = value_d 16 = value_e Now I add some values like a+b+c = 7 and put it in my table value 7 1 16 How can I select to get the value_b? ...

Hi,   I use SQL Server 2005. I have a table with around 7 million records in it. I am doing a count(*) on it to get the records based on some condition. ie., Select COUNT(*) from <table_name> where <condition>. ...