ah sorry, Easter() is my own udf, please replace it by for example yourBirthday.
krs, tesu

hello
SELECT DATEDIFF(DAY, yourBirthday, getdate()) AS silly_days
may work on mssqlserver.

krs,
tesu

Hello,

you may have a look at DATE_FORMAT(date, format), especially specifier %p to convert date and time values.

krs,
tesu

Hello,

php default's is auto commit ON. Therefore, you first step should always be switching it OFF, if you want to do serious database programming. With auto commit ON you will never be able to...

hello,

>>> "select * from table1 where RAM between ... "

Never use *, the sign of slackers! You must always enumerate only those columns you really need for your datagrid!

There are lots of...

hi,

how do you access the database? If by ODBC, you should set autocommit OFF. Unfortunately, ODBC's default is ON!

krs,
tesu

And also that "unaltered" code went through some modification meanwhile, LOL

hi,

there are some discrepancies:

1. What are PD.REFNO, PH1.BGROUP, PS1.REFNO ?

2. Is there a self-join: LEFT JOIN TableC LEFT JOIN TableC C ???

3. TableC of first left join...

hello,

in union clause the column which should be ordered cannot be denoted by column name. Column to be ordered must be specified by its position number like in:

select a, b, c from t1
union...

Hello dmmckelv,

When Edgar Frank Codd invited relational databases his primary idea was to found it on
logic algebra and set theory. The rows of relational tables (aka relations) are sets....

Hello guptaalok12,

When Edgar Frank Codd invited relational databases his primary idea was to found it on logic algebra and set theory. The Rows of relational tables (aka relations) are sets....

first do you first update, then:

update whattable set price = 5 where price IS NULL

From now onwards, all goods without price before will now cost 5 yourPriceUnit. Is this really correct?
...

hello,

You want to select some data from three tables. This will be done by two inner joins. If you don't tell which columns of the involved tables should be joined together the result will be...

Hi qdaddyo

you may try this statement:

with

modi (tn, moda) as
(select ticket_number, min(modified_date) from tictac
where assignee <> 'NONE' group by ticket_number) ,

Hello saisankar_p

Just another solution:

select s.SiteID, SiteName, s.StateID, PostCode, Phone1, StateName,
1 as canDelete
from tbl_site s, tbl_state a, tbl_user_site u, tbl_trial_site t...

Hello saisankar_p

Because of not having completely read your perfectly written post from begin to end, I presumed canDelete would already be part of one of your tables. I have to apologize to you...

Hello

If your tables are properly designed simple inner joins will solve your problem:

select * tbl_site join tbl_state join tbl_trial_site join tbl_user_site.

Ok, this result set will...

Hello

That is true, because the IN list is kind of set, all records will be fetched that contain one of the list's element. So you can say the records are "ored" together in result set.

I...

[QUOTE=harcaype;639245]
SELECT Vio.ViolationList.ViolationCode,Records.[Violation Commited],Vio.ViolationList.FineAmnt,DriverInfo.[Plate Number]
,DriverInfo.[License Number],DriverInfo.[Reg'd Last...

hi,

you should consider my posting #3:

You can freely change the IN list

WHERE Mrkt2 IN ('architecture', 'offices', 'hospitality')

for example

To cut a long story short: there is no way for retrieving a user's password, neither
from SQL-Server login nor from Windows-user login except you have installed keyboard recorder to spying out the...

where to get them from? what language, environment? need hacker's snippets?

Hi again

I have got this idea of selecting the appropriate data from table Markets:


select distinct PrjID, PrjName from projects
where PrjID IN
(
select PrjID from markets where...

hi

If you were able to redesign table Markets like that:

(PrjID, MarkedID, Market), where at least all three attributes be part of markets' primary key, the query you are looking for and...

amongst other things, it depends on precision...

Hi,

So you have a table consisting of 6 columns: Column Name Data Type Length
Turnover where the latter should be of decimal data type???

What do you mean by "that the max value could be...

Hi again,

well, I have got some problems understanding your screen shots. Wouldn't it be easier you post your sql code for tables and view creations? I know, if select statements are getting more...

In

INSERT INTO dudel2 SELECT name, sex, age FROM dudel GROUP BY name, sex, age;

GROUP BY clause, which must contain all attributes (column names), provides for distinct rows too.

Instead...

Hi,
obviously both is possible as you can read on http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

Database mirroring maintains a hot standby database...

Hello michael123

I am afraid, there is no direct way to get rid of duplicate rows.

But you can populate a new table with distinct rows from your given table only, for example:


-- create...

Hi arupa

Let's look at an example: With create table t(c char(10), v varchar(10)) there will be 10 places, e.g. 10 bytes statically allocated for column c. At first, there will be nothing...

Hi tkotey

Similar problem we have discussed on http://www.daniweb.com/forums/thread127644.html.
you may investigate SQL code from posts #5 and #7 where I gave solutions on how to compute balance...

hi,
this could be a solution:

select SUM (Column A) AS TotalColumnA, SUM (Column B) AS TotalColumnB,
TotalColumnA / TotalColumnB as TotalColumnC from yourTable;


If you want to...

Can you give an examle?

Do you know wildcards % and _ ?

krs,
tesu

You can download SQL management studio separately from MS. It's free.

krs,
tesu

Well, looking at your short code fragments it seems to be hard to me understanding your problem. I would suggest that you post the really complete (from create procedure... till go)

krs,
tesu

Addition
---------
Based on your given instances ERROR, TESTCYCL, LINK and RUN from post #8

select * from error join link join testcyl join run

gives:

5 open 58778 3971 ...

Hi again,


Well, in your FIRST POST you said that the result wouldn't meet your conception
(see: "However, what I really need to...")

Your LAST POST shows the same result as your FIRST POST,...

Hi conwayce,



These SQL selects

select a.column1 from tableA a, tableB b
where a.column1 = b.column1 AND b.column2 = 'apple'

-- or with inner join:

Hi conwayce

Cannot figure out the logic how result is created from the given tables.
How are these two tables related to each other? Are there any (hidden) relationships?
Best you post complete...