Viewing 15 posts - 646 through 660 (of 920 total)
D'oh..
Yep, makes perfect sense. Coffee has kicked in, brain now functioning.
Your previous 'exists' query should work, I think, or use the 'in' syntax and check for a count() of...
June 22, 2007 at 10:40 am
How about:
SELECT *
FROM clientsproducts, clients WHERE clients.clientid = clientsproducts.clientid AND clientsproducts.product in ('xxx','yyy','zzz')
June 22, 2007 at 10:18 am
Having not had my first cup of coffee this morning, I'm not sure I'm following this question.
Since there can't be a column with multiple values in the same row, an...
June 22, 2007 at 9:56 am
If you're running this on the server, are you sure the relative path name is correct and that the account running the package has permissions to it?
June 14, 2007 at 3:32 pm
Im not somewhere I can test this, but this might be a place to start.
create proc num_insert (@rows_in int) as
create table #testt ( somecolumn varchar(20) NOT NULL,
someothercolumn int NOT...
June 14, 2007 at 3:31 pm
Post the whole query you're running (or the proc text if it's a proc).
June 13, 2007 at 9:13 am
This is a specific example of the more general debate as to whether the DBMS should be a dumb storage mechanism or an intelligent guardian of data intergrity.
I'm of the...
June 12, 2007 at 12:50 pm
Hmmmmm. I did a copy and paste of the code you gave and it worked fine for me. Are you sure that the testTable table was created with the correct...
June 8, 2007 at 4:54 pm
If you need to use the parameter to specify columns for DML statements, you have to build the entire statement on the fly and execute it using special execution syntax. Look...
June 7, 2007 at 2:27 pm
How are you currently doing this, or is this a new, from scratch construction?
What is this file going to be input into? Can you use some other delimiter that is...
June 5, 2007 at 5:55 pm
I'm not sure where I got this (or how helpful it will be) but the following sql computes a median without cursors. The application was, if I remebmer correctly, calculating...
May 30, 2007 at 5:33 pm
A lot of the folks I know with technology careers, including myself, tend to be more self-contained than the average person. It does tend to make times of stress seem more...
May 30, 2007 at 4:06 pm
Post the entire proc and the steps you are going through to alter it.
May 7, 2007 at 2:43 pm
Extract the 30% you want to keep. Drop and recreate the table and the clustered index. Bulk insert the extracted rows and rebuild the other indexes. I'd be willing to...
May 7, 2007 at 2:41 pm
Post the whole proc, the ddl for the table, some sample data, and the errors you received (stick with the first syntax).
May 4, 2007 at 2:05 pm
Viewing 15 posts - 646 through 660 (of 920 total)