Programming SQL

order clause
Hi All, I have a table with state field, if the state is no correct we have XX as state. how can I show in my report the XX first and the rest of states after in order like: XX XX AZ AZ CA CA VA VA I try union but doesn't do the order for the states. SELECT rowid, address1, address2, address3, address4,... 8 Jul 2008 14:08

Moving data
I'm sure that this question has been asked hundred's of times but really don't know how to search for it. I have 3 fields that contain street address information. The fields are PrimaryAddress, PrimaryAddress2, PrimaryAddress3 I need to move PrimaryAddress2 into PrimaryAddress if PrimaryAddress is null o... 8 Jul 2008 14:08

thousands of plans in cache for one stored procedure
The procedure does not use dynamic sql but does use temp tables a lot, the temp tables are created in another stored procedure that then calls this stored procedure. This is taking up 2GB in pln cache. Is the temp table the cause of this? Thanks ... 9 Jul 2008 15:47

Select first three words in field
Hi I need to select the first three words in a varchar field and then the remaining words (4 to whatever) separately. For my purposes I count a word as finishing on a space not a full stop or any other character. e.g. if the string is The House of Commons Members Library Meeting Rooms I want to select '... 9 Jul 2008 18:53

using textcopy to import image file (jpg) to sql server DB
I am using the following SP (that I found on the net) for importing an image file to my server DB. And below that is how I call the SP, but it is not importing the image file. The SP uses textcopy.exe. I am making the calls from a remote workstation and not from the server. Will this sp only work on the ser... 9 Jul 2008 04:28

Quick question on stored procedures,..
I'm in the process of building an insert and update stored procedure, as one of the fields involved in the insert can contain so much data, I'm using a field type ntext, the problem that I'm having is that my stored procedure doen not recognise the field type ntext? Any ideas? Many thanks ... 8 Jul 2008 13:07

Alter tabe set default is not working
ALTER TABLE MyCustomers ALTER COLUMN CompanyName SET DEFAULT 'A. Datum Corporation' follwing error comming Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'SET' adv thanks ... 8 Jul 2008 11:03

Test post -- please ignore
For some reason, my last few replies have NOT been showing on Google Groups; just trying to see if this will make it. Sorry for the inconvenience. ... 8 Jul 2008 07:58

Which systemtable or view hold the default values
CREATE TABLE [dbo].[ASSESSMENT]( [est_id] [int] NOT NULL DEFAULT ((0)), [overall_assessmnt] [float] NULL, [bldg_assessmnt] [float] NULL, [land_assessmnt] [float] NULL, [value_rounding] [int] NULL, ) this value DEFAULT ((0))adv thanks ... 8 Jul 2008 08:59

Query Help
Hi All I have a table as follows col1-----col2-----col3-----col4 --------------------------------------- 30 1 11 111 30 2 22 222 30 3 33 333 Now i want 2 query on this table so that my output should be as follows 30 1 11 111 2 22 2... 8 Jul 2008 06:57