Re: Distinct in SQL Server - Database Discussion Boards

Re: inserting into SQL table with just a primary key column?

Chris Meech7-Jan-08 7:12

7-Jan-08 7:12

Is there also a Table_C which has as a column, Table_C.Table_A_Id? I've come across this a few times and other than adding an extra column as you suggest, you can also go without using Auto. But instead you write a trigger that peforms the logic that an Auto would do you for you normally.

Chris Meech
I am Canadian. [heard in a local bar]
Donate to help Conquer Cancer[^]

Re: inserting into SQL table with just a primary key column?

Paul Conrad7-Jan-08 7:44

Paul Conrad

7-Jan-08 7:44

You really should redesign your tables, because like Pete said, this is a failure at database normalization.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Re: inserting into SQL table with just a primary key column?

Mark Churchill7-Jan-08 12:21

Mark Churchill

7-Jan-08 12:21

Table_A contains no data. All it contains is a surrogate key, a key to look up nothing.

If you really need the list of values that you expect in Table_A, then a select distinct(Table_A_Id) from Table_B will serve its purpose.

If you want to constrain the column in Table_B to a set of values, then use a constaint.

Mark Churchill
Director
Dunn & Churchill
Diamond Binding: Zero to Data Layer in 3 mins

Re: inserting into SQL table with just a primary key column?

Vimalsoft(Pty) Ltd6-Jan-08 20:05

Vimalsoft(Pty) Ltd

6-Jan-08 20:05

hi
Please Explain in Detail on what you want to achieve.

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: inserting into SQL table with just a primary key column?

michal.kreslik6-Jan-08 21:09

michal.kreslik

6-Jan-08 21:09

Hi, Vuyiswa Maseko,

thanks for your reply. I described the coveted structure in my reply to Paul. Any help will be greatly appreciated.

Thanks much,
Michal

Re: inserting into SQL table with just a primary key column?

obymathew10-Jan-08 13:29

obymathew

10-Jan-08 13:29

In SQL Server 2005,
If not caring about normalization, NEWID() will autogenerate a uniqueidentifier

INSERT INTO [GSTDB].[dbo].[TableName]
([Field1])
VALUES
(NEWID())

GoodLuck!!

Distinct in SQL Server

.NET- India 4-Jan-08 23:19

.NET- India

4-Jan-08 23:19

Hello Friends,

I want to get the information of the record(s) where SmallImage(Field Name) must be unique. For this i'm using the following query. Is it right or not if not plz make it correct

Select * From Gallery1 Where SmallImage in (Select Distinct SmallImage From Gallery1 Where Active=1)

Re: Distinct in SQL Server

Vimalsoft(Pty) Ltd5-Jan-08 7:37

Vimalsoft(Pty) Ltd

5-Jan-08 7:37

hi Friend

try this

select * from Gallery1 where SmallImage = "whatever" And 
Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)

Remember you have to Assign a value in the First select statement.Think of it this was. you want to select all the records in a table called "Gallery1" where Value is equals to "that", and from the above Query display the records Distinctively.

hope it helps

Thanks

Re: Distinct in SQL Server

.NET- India 6-Jan-08 18:33

.NET- India

6-Jan-08 18:33

Sorry Friend,
The code you sent is not working properly

Select * From Gallery1 Where SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' and SmallImage in
(Select Distinct SmallImage From Gallery1 Where Active=1)

The code is given above only giving the records that include the SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg'

Re: Distinct in SQL Server

Vimalsoft(Pty) Ltd6-Jan-08 20:03

Vimalsoft(Pty) Ltd

6-Jan-08 20:03

hi Friend, here is your Mistake. i have sent you the Query that looks like this

select * from Gallery1 where SmallImage = '~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' And 
Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)

And you sent me that give you a Problem now ,that looks like this

Select * From Gallery1 Where SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' and SmallImage in
(Select Distinct SmallImage From Gallery1 Where Active=1)

if you can look at the Above Queries, they dont look the same. the First Query is what i recommended and the second query, its yours and you did not use the "Exists" and you used SmallImage again, and SQL does not know what to do with it, its like an used variable but declared.

try the first one and tell me what you get

Hope it helps

Thanks

Re: Distinct in SQL Server

.NET- India 6-Jan-08 20:14

.NET- India

6-Jan-08 20:14

Sorry Friend again i got same result............

It's bringing the records Where SmallImage-"....given below...."

Select * From Gallery1 where SmallImage = '~/Gallery/Bhaji in Lodhi Garden/Small/5.JPG' And Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)

Oracle, BizTalk, SQL Server

Ph@ntom4-Jan-08 20:39

Ph@ntom

4-Jan-08 20:39

My requirement is to read data from Oracle using BizTalk (XML) and write to SQL Server.

Looking for recommendations.

Thanks.

The Phantom.

Re: Oracle, BizTalk, SQL Server

Vimalsoft(Pty) Ltd5-Jan-08 7:45

Vimalsoft(Pty) Ltd

5-Jan-08 7:45

Hello Friend

it seems you did not google your Problem

http://www.google.co.za/search?hl=en&q=quirement+is+to+read+data+from+Oracle+using+BizTalk+%28XML%29+and+write+to+SQL+Server.&btnG=Google+Search&meta=[
href="http://www.google.co.za/search?hl=en&q=quirement+is+to+read+data+from+Oracle+using+BizTalk+%28XML%29+and+write+to+SQL+Server.&btnG=Google+Search&meta=" target="_blank" title="New Window">^]

Next time Google before you post.

Thanks

Re: Oracle, BizTalk, SQL Server

Paul Conrad5-Jan-08 9:57

Paul Conrad

5-Jan-08 9:57

Do a google search first.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Re: Oracle, BizTalk, SQL Server

Pete O'Hanlon5-Jan-08 10:22

Pete O'Hanlon

5-Jan-08 10:22

Ph@ntom wrote:
My requirement is to read data from Oracle using BizTalk (XML) and write to SQL Server.

Why? You can do this by reading the data from SQL Server using SSIS (SQL Server Integration Services) which is perfectly capable of transforming data from other database sources.

Deja View - the feeling that you've seen this post before.

My blog | My articles

ReportViewer Problem

sangramkp4-Jan-08 18:45

sangramkp

4-Jan-08 18:45

Hi,

I am using Sql Server Reporting Services in my asp.net web application. I am displaying the reports in reportviewr.
Whenever there is some data its ok. But When The Stored Procedure or query didn't produce any result the report viewer appears and take usual place(i.e width and height).

My requirement is that if the stored procedure or query returns data then the report viewer will be visible along with data. Else the report viewer should Hide and display Record Not Found.

Issue:
--------
As the .rdl file is directly related to stored procedure or query we r not fetching any datatable into the page.

Any Suugesstions or Solutins heartly Accepted....
Rose | [Rose]

Sangram
(A battle with self)

Life is simple, we are the ones makes the living difficult

Re: ReportViewer Problem

pmarfleet4-Jan-08 23:57

pmarfleet

4-Jan-08 23:57

Data bound controls in SSRS have a NoRows property which allows a message to be defined which will only be displayed when the data source that the control is bound to does not return any data.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

User Defined Data Types

AAGTHosting4-Jan-08 14:35

AAGTHosting

4-Jan-08 14:35

I need to store a time such as 5:00 PM in a table column in SQL SERVER Express 2005. I do not need to store any data about the date. I know that I could store this as text, but I know I should store it in a datetime data type. Should I create a user defined type just for time?

When I first was writing the database I found an article in a forum where users were saying that when they needed to store a time with no date they were using a text field. Then I posted a message in the VB.NET forum and I was told that it would be a big mistake to store a time in a text field.

What should I do?

Re: User Defined Data Types

Paul Conrad4-Jan-08 17:39

Paul Conrad

4-Jan-08 17:39

AAGTHosting wrote:
Should I create a user defined type just for time?

Probably the best route to go. If you have any comparing/manipulation of the data, it will be easier to work with a UDT, rather than a text field.

OT: One of my favorite books is Pro SQL Server 2005 Database Design and Optimization[^] by Louis Davidson. He does a pretty good job with UDTs. Examples in both C# and VB.NET. Though it is for SQL Server 2005, most of the material still works with SQL Server 2005 Express.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Looking for reference book

Leo Smith4-Jan-08 6:12

Leo Smith

4-Jan-08 6:12

Hello,

I am looking for a reference book that covers T-SQL for MS-SQL 2005. I have found several that cover SQL Server, but almost nothing about stored procedures. I want a book that covers advanced programming along with some of the performance topics, and advance query and calculations.

Thanks,

Leo T. Smith

Re: Looking for reference book

pmarfleet4-Jan-08 13:04

pmarfleet

4-Jan-08 13:04