Programming SQL

Price Level Design
I have a table design which contains quantity break pricing data. The design work was done months ago based on some article or post I read. I believe it is a good design, but now after a review I am asked to defend my design. Of course, I did not save off the original article, so I have forgotten the logic b... 2 Aug 2008 23:47

Multiple options query question
Hi I have a Clients table with a 'status' field with possible values; Current, Inactive and Prospect. I want to return values either on one of the values of status field or all records. My questions are; 1. Is stored procedure the best way to handle this query? If so what is the construct of such a stored p... 9 Jul 2008 05:30

Metallbauer Metallbauerin ich will im ausland arbeiten Psychotherapeut Psychotherapeutin www job im ausland de
Metallbauer Metallbauerin ich will im ausland arbeiten Psychotherapeut Psychotherapeutin www job im ausland de + + + ARBEITSANGEBOTE IM AUSLAND http://WWW.STELLENANGEBOT-AUSLAND.DE http://WWW.STELLENANGEBOT-AUSLAND.DE + + + AUSLANDSJOBS ONLINE FINDEN http://WWW.AUSLANDSJOBS-24.DE http://WWW.AUS... 8 Jul 2008 17:13

insert into table from excel or text file
Hi, I can use openrowset to insert records into table from excel file. However, I'm having difficulty to eliminate those unknown columns saved with the file. How to read the data without those columns. Thanks so much in advance, sg ... 9 Jul 2008 10:37

Help with CTE syntax error
Can anyone help me with "incorrect syntax near 'cte'"? Thanks in advance, Lars with cte as ( select AddressID, PersonID, DateAdded, row_number() over(partition by AddressID order by PersonID DESC) as rn from dbo.Person ) select * cte where rn > 1; Table definition: create table Person ( ... 8 Jul 2008 17:13

WORKS..Thanks!
"JFB" <jfb(a)help.com> wrote in message news:eWnY28R4IHA.1952(a)TK2MSFTNGP03.phx.gbl... 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... 8 Jul 2008 16:11

Using ODBC binding for wildcard search
I am trying to change my search query to use SqlBindParameter instead of "inline" search pattern like: SELECT last_name FROM users WHERE last_name = 'S%' I am using "SQL Server" ODBC Driver (version 2000.85.1117.00) with MS SQL Server 2005 back end database. Here is what my sample code looks like: --------... 8 Jul 2008 19:17

OrderId Query
I have a table Orders with OrderId(PK), EventId(FK to Events) OrderId EventId 2 33 2 38 3 49 I have another table Events with EventId(PK). I would like to write a query which will return: 1. OrderId with the maximum number of Eventid's associated (in this case its orderid=2) 2. Numb... 8 Jul 2008 15:10

SQLQuery
I have a table Orders with OrderId(PK), EventId(FK to Events) OrderId EventId 2 33 2 38 3 49 I have another table Events with EventId(PK). I would like to write a query which will return: 1. OrderId with the maximum number of EventId's. In the above case its OrderId=2. 2. Total nu... 8 Jul 2008 15:10

Logging in SSIS package
Hi, I have a SSIS package that executes a SQL script against few SQL Servers in our environment. I setup SSIS file based logging to capture error messages but I can't get the server name where the error happns on. How can I include SQL Server name in logging? Thanks ... 9 Jul 2008 22:59