Date: 01/03/06     Keywords: asp, web

How do I instance an ASP2 application from a client machine from within the firewall? Despite that, I wrote it in Visual Studio 2005 Professional Edition, whenever I attempt, it tried to read it as if I wrote it for .Net framework 1.1 and not 2.0. I am calling it over HTTP (i.e., HTTP://pjohnson/website1/default.aspx) where the application resides in a folder in WWWRoot.

Source: http://www.livejournal.com/community/sqlserver/39020.html

Date: 01/03/06     Keywords: asp, web

How do I instance an ASP2 application from a client machine from within the firewall? Despite that, I wrote it in Visual Studio 2005 Professional Edition, whenever I attempt, it tried to read it as if I wrote it for .Net framework 1.1 and not 2.0. I am calling it over HTTP (i.e., HTTP://pjohnson/website1/default.aspx) where the application resides in a folder in WWWRoot.

Source: http://community.livejournal.com/sqlserver/39020.html

Date: 12/30/05     Keywords: sql

1. In query nalyzer, type either of the following and run it:
PRINT 365/183
PRINT CAST(365/183 AS float)

If your answer is 1 (or 1.0), congratulations, you win. You get to tell me what switch we both need to flip to get the correct (mathematically, anyway) answer.

* * *

2. I'm porting a horribly-written Access application to SQL Server. It contains a table with three columns. Each of these columns corresponds to a dropdown box on a form. The way it's supposed to be written is that a value selected in column A will populate the list in column B, etc., since only certain values in column B should be present for any given value in column A. The monkeywrench in the works is that the values in B are not necessarily unique to the values in A, and the values in C are definitely not unique to the values in B-- but not all values in B are applicable to all values of A, and all values in C are not etc. As an example:

A: Inpatient, Outpatient, Other
B: Transplant, Maternity, Addiction Treatment
C: Bone Marrow Transplant Allogenic, Caesarian Section, Emergency Room

It's relatively obvious that Outpatient in A will never correspond to Transplant in B; Transplant will always, short of a medical miracle, be an inpatient procedure. Addiction Treatment, though, can be on either an inpatient or outpatient basis. (I'm lobbying for getting rid of "other" altogether.) Similarly, Bone Marrow Transplant Allergenic will, good lord willin' and cricks don't rise, never apply to maternity-- but Emergency Room could concievably apply to just about anything in either column A or column B, because you can show up at the ER needing, well, anything.

What I've been mulling over is having three different lookup tables, each with two columns-- ID and Description-- and a fourth column that would list the valid IDs that can go together for each. That, however, ultimately saves me not much room, will require manual additions to the core table whenever new categories are added, and would probably end up being slower. (Actually, anything will end up being slower, seeing as the Access app takes the Chinese-menu method-- display anything and let the user pick whatever-- but I'd like to cut the speed decrease as much as possible.) We're still in the brainstorming phase with this, so there aren't any ideas which will undercut work that's already been done. If you have any to throw into the ring, I'd appreciate it.

Thanks!

Source: http://www.livejournal.com/community/sqlserver/38791.html

Date: 12/30/05     Keywords: sql

1. In query nalyzer, type either of the following and run it:
PRINT 365/183
PRINT CAST(365/183 AS float)

If your answer is 1 (or 1.0), congratulations, you win. You get to tell me what switch we both need to flip to get the correct (mathematically, anyway) answer.

* * *

2. I'm porting a horribly-written Access application to SQL Server. It contains a table with three columns. Each of these columns corresponds to a dropdown box on a form. The way it's supposed to be written is that a value selected in column A will populate the list in column B, etc., since only certain values in column B should be present for any given value in column A. The monkeywrench in the works is that the values in B are not necessarily unique to the values in A, and the values in C are definitely not unique to the values in B-- but not all values in B are applicable to all values of A, and all values in C are not etc. As an example:

A: Inpatient, Outpatient, Other
B: Transplant, Maternity, Addiction Treatment
C: Bone Marrow Transplant Allogenic, Caesarian Section, Emergency Room

It's relatively obvious that Outpatient in A will never correspond to Transplant in B; Transplant will always, short of a medical miracle, be an inpatient procedure. Addiction Treatment, though, can be on either an inpatient or outpatient basis. (I'm lobbying for getting rid of "other" altogether.) Similarly, Bone Marrow Transplant Allergenic will, good lord willin' and cricks don't rise, never apply to maternity-- but Emergency Room could concievably apply to just about anything in either column A or column B, because you can show up at the ER needing, well, anything.

What I've been mulling over is having three different lookup tables, each with two columns-- ID and Description-- and a fourth column that would list the valid IDs that can go together for each. That, however, ultimately saves me not much room, will require manual additions to the core table whenever new categories are added, and would probably end up being slower. (Actually, anything will end up being slower, seeing as the Access app takes the Chinese-menu method-- display anything and let the user pick whatever-- but I'd like to cut the speed decrease as much as possible.) We're still in the brainstorming phase with this, so there aren't any ideas which will undercut work that's already been done. If you have any to throw into the ring, I'd appreciate it.

Thanks!

Source: http://community.livejournal.com/sqlserver/38791.html

Date: 12/20/05     Keywords: sql

Is there any way to stop this from occurring?

(SQL Server 2000, most recent service pack applied.)

Thanks.

Source: http://www.livejournal.com/community/sqlserver/37960.html

Date: 12/20/05     Keywords: sql

Is there any way to stop this from occurring?

(SQL Server 2000, most recent service pack applied.)

Thanks.

Source: http://community.livejournal.com/sqlserver/37960.html

Date: 12/08/05     Keywords: database, sql

I am having some issues starting a procedure. I need to create a sql procedure where the user creates a new dog in a database. The information that is going to be inserted is : gender first, which will stop the program if not identified in the database, breed, which will go under unknown if there is no existing record in database, owner id, which will go under ORPHAN if no existing record, eye color, which will create a new entry for a new eye color is not already in DB, and finally create the dog with dog_id once all the other parts are taken care of. I need to have exception handling in this procedure as well. I would like someone to help me to start this.

Source: http://www.livejournal.com/community/sqlserver/37683.html

Date: 12/08/05     Keywords: database, sql

I am having some issues starting a procedure. I need to create a sql procedure where the user creates a new dog in a database. The information that is going to be inserted is : gender first, which will stop the program if not identified in the database, breed, which will go under unknown if there is no existing record in database, owner id, which will go under ORPHAN if no existing record, eye color, which will create a new entry for a new eye color is not already in DB, and finally create the dog with dog_id once all the other parts are taken care of. I need to have exception handling in this procedure as well. I would like someone to help me to start this.

Source: http://community.livejournal.com/sqlserver/37683.html

Date: 11/18/05     Keywords: database, sql, security, google

Source: http://www.livejournal.com/community/sqlserver/37213.html

Date: 11/18/05     Keywords: database, sql, security, google

Source: http://community.livejournal.com/sqlserver/37213.html

Date: 11/14/05     Keywords: no keywords

Hi all!
I have some table with some "name" field in it which looks like
"Blah blah blah Part 1"
"Blah blah blah Part 2"
"Blah blah blah Part 3"
when I query it
select * from mytable orderby name
it doesn't actually work in a "proper" way.
I keep on getting something like
"Blah blah blah Part 2"
"Blah blah blah Part 1"
"Blah blah blah Part 3"
Do you know what should I do to make it work?

Source: http://www.livejournal.com/community/sqlserver/37053.html

Date: 11/14/05     Keywords: no keywords

Hi all!
I have some table with some "name" field in it which looks like
"Blah blah blah Part 1"
"Blah blah blah Part 2"
"Blah blah blah Part 3"
when I query it
select * from mytable orderby name
it doesn't actually work in a "proper" way.
I keep on getting something like
"Blah blah blah Part 2"
"Blah blah blah Part 1"
"Blah blah blah Part 3"
Do you know what should I do to make it work?

Source: http://community.livejournal.com/sqlserver/37053.html

Date: 10/28/05     Keywords: no keywords

Hey guys, hopefully quick question:

I have a table with 2 columns that looks like this called OldList:

User Fruit
-------------------------------
Chris Apples
Chris Grapes
Chris Oranges
Adam Apples
Jordan Apples
Jordan Oranges
Mike Grapes
Mike Oranges

And I need to write a query to populate a new table (NewList), and the results should look like this:

User Apples Grapes Oranges
----------------------------------
Chris Yes Yes Yes
Adam Yes
Jordan Yes Yes
Mike Yes Yes


Any ideas?

Thanks in advance!

Source: http://www.livejournal.com/community/sqlserver/36652.html

Date: 10/28/05     Keywords: no keywords

Hey guys, hopefully quick question:

I have a table with 2 columns that looks like this called OldList:

User Fruit
-------------------------------
Chris Apples
Chris Grapes
Chris Oranges
Adam Apples
Jordan Apples
Jordan Oranges
Mike Grapes
Mike Oranges

And I need to write a query to populate a new table (NewList), and the results should look like this:

User Apples Grapes Oranges
----------------------------------
Chris Yes Yes Yes
Adam Yes
Jordan Yes Yes
Mike Yes Yes


Any ideas?

Thanks in advance!

Source: http://community.livejournal.com/sqlserver/36652.html

Date: 10/14/05     Keywords: sql

Is there an equivalent to the SEEK command in T-SQL?

In other words, I need

SELECT left (some_column, number_of_characters_until_you_hit_the_first_space_[which_is_not_uniform]) FROM some_table

Source: http://www.livejournal.com/community/sqlserver/36422.html

Date: 10/14/05     Keywords: sql

Is there an equivalent to the SEEK command in T-SQL?

In other words, I need

SELECT left (some_column, number_of_characters_until_you_hit_the_first_space_[which_is_not_uniform]) FROM some_table

Source: http://community.livejournal.com/sqlserver/36422.html

Date: 10/05/05     Keywords: sql

Intellisense® style word completion for MS Query Analyzer, VS.NET 2003, SQL Server Management Studio and VS 2005.

http://www.promptsql.com/

--

This looks like a real slick tool, which would easily pay for itself after a day's use!

(x-posted to various places)

Source: http://www.livejournal.com/community/sqlserver/36137.html

Date: 10/05/05     Keywords: sql

Intellisense® style word completion for MS Query Analyzer, VS.NET 2003, SQL Server Management Studio and VS 2005.

http://www.promptsql.com/

--

This looks like a real slick tool, which would easily pay for itself after a day's use!

(x-posted to various places)

Source: http://community.livejournal.com/sqlserver/36137.html

Date: 09/23/05     Keywords: no keywords

the error message:
"The conversion of the verchar value 'xxxxxxxxxxxx' overflowed an INT1 column. Use a large intereger column."

The column is char(10). (The value is, actually, numeric; I x'ed it because it's a phone number.)

I've checked, double-checked, and triple-checked that (a) the INSERT INTO statement is putting the value in the right place; (b) the table does have the column listed as char(10); (c) the variable names are consistent across the board in putting the INSERT INTO statement together.

Anything else I should be looking at?

Source: http://www.livejournal.com/community/sqlserver/35281.html

Date: 09/23/05     Keywords: no keywords

the error message:
"The conversion of the verchar value 'xxxxxxxxxxxx' overflowed an INT1 column. Use a large intereger column."

The column is char(10). (The value is, actually, numeric; I x'ed it because it's a phone number.)

I've checked, double-checked, and triple-checked that (a) the INSERT INTO statement is putting the value in the right place; (b) the table does have the column listed as char(10); (c) the variable names are consistent across the board in putting the INSERT INTO statement together.

Anything else I should be looking at?

Source: http://community.livejournal.com/sqlserver/35281.html