Viewing 15 posts - 316 through 330 (of 530 total)
Use UNION with two normal joins.
SELECT A.*, B.*, null, ...
FROM A INNER JOIN B
ON A.ID_FIELD = B.ID_FIELD
UNION ALL
SELECT A.* , ......
May 26, 2003 at 3:14 am
Just some suggestions / remarks.
1. You can get the time someone spent in a certain state just from inserting the 'starttime' for each state by using a query like the...
May 22, 2003 at 6:19 am
Yep, that's the easiest and safest way. No passwords sent in the clear over the network. CryptoAPI gives you everything you need.
Unless you need to be able to decrypt the...
May 21, 2003 at 11:26 am
Did you check the query plan? It might be possible that SQL Server decides to convert your datetime column to a string, before doing the comparison. Not only does this...
May 19, 2003 at 4:03 am
The queries wouldn't get that much more complicated. Just add an additional WHERE clause to select the correct type when joining.
You are correct with your remark for the Foreign keys....
May 19, 2003 at 1:20 am
As you mentioned yourself, naming conventions are a personal thing. The best advice is to define/choose a naming convention and stick to it.
For me, singular names work best, and I...
May 18, 2003 at 9:11 am
Jeremy, I certainly am no expert in performance tuning queries, but keep in mind that SQL Server will try to optimise stuff. Probably, the query of rdfozz will get optimised...
May 17, 2003 at 9:38 am
Use the following formula
DATEADD(dd, 1 - DATEPART(wd, GETDATE()), GETDATE())
Fiddle around with the '1 minus' part and SET DATEFIRST to determine what the first day of the...
May 14, 2003 at 5:29 am
I'm probably missing something, but your initial query seems to be correct to me.
Are you sure that this is not due to the data in your tables. Maybe there is...
May 13, 2003 at 3:47 am
One of the pre-conditions of the NotesSQL ODBC driver is the fact that an installation of either Lotus Notes (the client) or Lotus Domino (the server) is installed on the...
May 13, 2003 at 2:43 am
Here goes nothing. I started from your first alternative solution, and changed / corrected the 'inner join' problem as I stated in my previous post.
I don't know if this solves...
May 12, 2003 at 9:14 am
One remark I would like to make (from BOL) is that the order in which you specify the tables IS important when using LEFT or RIGHT inner joins.
I did not...
May 9, 2003 at 7:55 am
The CONVERT function from integer to char right pads the resulting string with spaces.
The conversion to varchar doesn't do this, since it stores only the 'meaningful' characters.
Why did it work...
May 7, 2003 at 6:53 am
This is a typical concurrency issue that you often find in 'normal' programming. Just copycatting the semaphore or mutex idea from there, I would construct a table containing one record...
May 7, 2003 at 3:59 am
Shouldn't you add Request.Querystring("Pagenum")?
Are you sure that the 'PageCount' that is calculated in the database is correct? I.e. 1 if there are less than (or equal to) 50 records, 2...
May 5, 2003 at 7:38 am
Viewing 15 posts - 316 through 330 (of 530 total)