Database Discussion Boards

Re: Recursive drill down query?

Jon Sagara19-Jan-07 9:34

Jon Sagara

19-Jan-07 9:34

You can write recursive stored procedures. Will that help, or do you need it to be a single query?

Jon Sagara
I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So i had to leave the place as soon as possible.
--Mr.Prakash

Blog | Site | Articles

SQL Server table names has (dbo) as part of name

dptalt19-Jan-07 3:26

dptalt

19-Jan-07 3:26

I have a Microsoft SQL Server database that was moved. When I looked at the tables in the Server Explorer there are 2 sets of the same tables 1 set having the text '(dbo)' tacked on to the end of the table names. Why is this? Am asking because the website that connects to the database updates the tables with '(dbo)' while the admin page querys the tables without '(dbo)'. Can I delete one of the sets?

Re: SQL Server table names has (dbo) as part of name

Bassam Saoud20-Jan-07 0:00

Bassam Saoud

20-Jan-07 0:00

dbo means data base owner, in short its the user who owns the tables.if you created the tables with user name "x" the resulting table will be referenced by x.tablename

You can change the owner of an object by using stored procedure sp_changeobjectowner

dptalt wrote:
Can I delete one of the sets?

Well as long as you have the right permission in your web site to access thes tables you can...

What You See Is What You Get (WYSIWYG) .... doesn't work with SQL Reporting Services

Member 331398919-Jan-07 3:05

Member 3313989

19-Jan-07 3:05

I did the following steps:
1. Created a report using SQL Reporting Services. (OK)
2. Deployed the project (ABC) into the ServerX. (OK)
3. Opened the SQL Reporting Services using the Report Manager on localhost of the ServerX. (OK)
4. Opened the ABC folder. Files deployed. (OK)
5. Created two subscriptions. One (Service1) for printing to the Printer. One (Service2) for saving into a file. (OK)
6. Opened the Service1. In the View Tab, after entering the Report Parameters, clicked on "View Report". (OK)
7. I expected view to show what I viewed in the Project (ABC). (NOK - It printed a wrong format. Alignment was completely different)
8. Tried to export to a TIFF file expecting to see the same view as I saw in the Project (ABC). (NOK - It printed a wrong format. Alignment was completely different)
9. Tried to export to a PDF file expecting to see the same view as I saw in the Project (ABC). (NOK - It printed a wrong format. Alignment was completely different)
10. In the subscriptions, I ran the Service1 to print the report from the SQL Reporting Services directly onto the Printer. (NOK - It printed a wrong format. Alignment was completely different)

Is this an expected issue with SQL Reporting Services which incase doesnt make any sense to use it. Or it is an issue with my code. All I assumed that I should expect from SQL Reporting Services is: if I create a Report and I preview the Report, I should get a WYSIWYG formats.

Half the way through our project, we are completely stuck up. SOS!!!

Comparing Dates Problem:

Shahzad.Aslam19-Jan-07 0:56

Shahzad.Aslam

19-Jan-07 0:56

Hi There are two date fields in the table and i want to select Maximum date field from two fields i m trying to query like this.
Table Fileds:
UserID Int
LastDDTxn Datetime
LastCardTxn Datetime

SELECT LAST_TRAN_DATE=
(CASE WHEN LastCardTxn>LastDDTxn THEN LastCardTxn
ELSE WHEN LastDDTxn>LastCardTxn THEN LastDDTxn
ELSE NULL
END) AS Last_Tran_Date
FROM USERHISTORY

The Error is showing that
Incorrect syntax near the keyword 'WHEN'

SHAHZAD

Re: Comparing Dates Problem:

WoutL19-Jan-07 2:21

WoutL

19-Jan-07 2:21

Select LAST_TRAN_DATE = Max([Date])
From(
   Select [Date] = LastDDTxn
   From UserHistory
   Union
   Select [Date] = LastCardTxn
   From UserHistory
) Dates

Wout Louwers

Re: Comparing Dates Problem:

Shahzad.Aslam19-Jan-07 18:41

Shahzad.Aslam

19-Jan-07 18:41

Thanx! Its working fine.

Shahzad

Re: Comparing Dates Problem:

Mike Dimmick19-Jan-07 2:44

Mike Dimmick

19-Jan-07 2:44

SELECT LAST_TRAN_DATE =
   (CASE
       WHEN LastCardTxn > LastDDTxn THEN LastCardTxn 
       <s>ELSE</s> WHEN LastDDTxn > LastCardTxn THEN LastDDTxn
       ELSE NULL
   END) AS Last_Tran_Date
FROM USERHISTORY

The first, crossed-out, ELSE is incorrect - ELSE is only used for the 'default' case i.e. when no WHEN clauses match. Therefore, when the query parser encounters ELSE, it's expecting an expression, and reports that WHEN is an error.

Stability. What an interesting concept. -- Chris Maunder

need query

Tauseef A19-Jan-07 0:56

Tauseef A

19-Jan-07 0:56

hi all

please tell me the query

actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter

thanks

hello

hello

Re: need query

Pete O'Hanlon19-Jan-07 2:32

Pete O'Hanlon

19-Jan-07 2:32

Not only cross posting, but reposting. Do you really think we are so stupid as to not notice this?

OK - some guidelines. Tell us what the table structure is and the query criteria you have to work with. Then, give us some idea as to what you have tried so we can see that you aren't just trying to get us to do your homework for you. Finally, pick a meaningful subject. "Re: need query" is not going to get your question answered.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

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

hi its very urgent

Tauseef A19-Jan-07 0:11

Tauseef A

19-Jan-07 0:11

hi all

please tell me the query

actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter

thanks

hello

Re: hi its very urgent

Guffa19-Jan-07 0:54

Guffa

19-Jan-07 0:54

Please don't cross post.

---
Year happy = new Year(2007);

query to rename a field of an existing table in SQL Server??

Saira Tanwir18-Jan-07 21:48

Saira Tanwir

18-Jan-07 21:48

hello
can anyone plz tell me the query to rename an existing field in a table???? Sigh | :sigh:

Saira

Re: query to rename a field of an existing table in SQL Server??

andyharman19-Jan-07 0:10

andyharman

19-Jan-07 0:10

EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'

Re: query to rename a field of an existing table in SQL Server??

Elina Blank19-Jan-07 3:14

Elina Blank

19-Jan-07 3:14

SQL Server:

exec sp_rename @objname='TableName.ColumnName', @newname='NewColumnName'

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

querry

pradeep kulkarni18-Jan-07 20:03

pradeep kulkarni

18-Jan-07 20:03

:-Dwrite querry to compare row in table A and in table B.

for example
if in table A contains row values as a 12
b 14
c 15

if in table B contains row values as a 13
b 21
c 43

compare table A's row c with table B's row c.

pradeep kulkarni

Re: querry

Christian Graus18-Jan-07 22:10

Christian Graus

18-Jan-07 22:10

The questions you're asking are very easy, and you're obviously typing in your homework. Please try yourself, if you can't work this out, you should quit your course.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

querry

pradeep kulkarni18-Jan-07 19:48

pradeep kulkarni

18-Jan-07 19:48

write querry to display all books whose name start with 's'

please help me

pradeep kulkarni

Re: querry

gskumar11118-Jan-07 19:53

gskumar111

18-Jan-07 19:53

SELECT * FROM <tablename>
WHERE COLUMNNAME LIKE 'S%'

Re: querry

Christian Graus18-Jan-07 22:11

Christian Graus

18-Jan-07 22:11

Please don't do people's homework, it's not helping them

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

storing images in sql server

gskumar11118-Jan-07 19:37

gskumar111

18-Jan-07 19:37

hi ,
this is santhosh in my project i want to store 3 images in one column in sqlserver and when the time of displaying(in front end c#) it should display seperately , plz tell me how to do this

thank you
santhosh

Re: storing images in sql server

Pete O'Hanlon19-Jan-07 2:56

Pete O'Hanlon

19-Jan-07 2:56

Why do you want to store three images in one column? Seems like a bit of a normalisation issue here.