Well, that really depends on how you want to handle it and what should be the final result... here one possibility:

select * , CONVERT(varchar(5), tran_date,14) AS tran_time

from transactions

where tran_date between...

Thanks, Optimist 🙂 your solution was something that didn't occur to me, and is very helpful! I was looking for that right now, because I wanted to avoid the use of cursors in a...

Thanks for the explanation, Sara - now I can see that I understood the question wrong and that Amit's method should give correct results.

And now it is time to have some fun... see...

Hi Sara,

I guess it would be easier to help if you explain a bit more closely what do you want to achieve... What does the "Without using temp tables or cursors, how...

Well, I don't know what the problem is, and I have only SQL2k ... just an idea, did you try to specify all the numbers (100, 10, 1, 0.1 ....)...

Hmm.. the question does not state whether combination of ID+IACID must be unique. If it isn't unique, then AH's solution won't work... but just a simple modification of the last line should...

Hello,

without seeing the SQL and underlying data structure I don't know where the problem could be. IMHO it should work. You could also try COALESCE(field1,field2) AS NewField - this allows...

Hello,

I suppose this is just a simplified version of your real query, so I won't ask what it is supposed to do... Anyway, IMHO the problem is that you use...

The log will not shrink on backup - file remains the same size, but most contents are emptied - so when there are new data coming in, log doesn't have...

AutoShrink is not a good choice because of the fact that both shrinking and growing of the log file will lower performance of the system. It is better to keep the...

Hi Curtis,

Al didn't mention the version of SQLS their company is using, so I suppose it is Enterprise Edition. Standard Edition wouldn't be able to use the memory above 2...

I'd definitely vote for a flexible model, like the one proposed by wz700. You can bet there will be changes over time... as soon as you hardcode the structure, some new...

Hi Mohammad,

if your DB is really just 200 MB, IMHO you can reindex all and don't worry about it much... it is really a small database.

We have a DB of...

Well, table with two hashes (##tmptable) is global and should be visible to other users as well - as long as the connection in which it was created is active....

Hi,

what version of SQLS are you running? I tested on SQL 2k and I agree with noeld, on random data your query works fine. I wrote a similar query for one of...