This is browser depended. Once you click on the excel file link, it'll determine weather need to open on same page itself or on a new window. http://support.microsoft.com/kb/162059[^]
I appreciate your help all the time... CodingLover :)
Since you don't have any indexes, you cannot create them and you don't have joins, there's not much you can do. The only thing that comes in mind is that yu copy the data to another table (perhapes in another database), index it and execute the query there. However this isn't a good solution if you need the data to be up-to-date.
The need to optimize rises from a bad design.My articles[^]
Put the values into a table variable and join to it; in our projects we have a udf that parses a comma-separated string and returns a table variable of the data, it's not too hard to make one. Do that and then join to the table variable.
Keep It Simple Stupid! (KISS)
You cannot combine insert and update statements, so you have to execute two separate commands. However you can execute them in a single batch (or write a procedure to wrap them).
The need to optimize rises from a bad design.My articles[^]
Uma Kameswari wrote:
How to split them. The insert or Update statement is not allowed in case statement
Don't use single statement. Create a different insert statement and different update statement and execute both separately. Instead of using case in select, use where conditions, like:
insert into table (columns)
select columns
from anothertable
where ConditionsToBeMet
and
update table
set columns
where ConditionsToBeMet
Just make the conditions so that they define the logic you defined in case statement.
The need to optimize rises from a bad design.My articles[^]
Perhaps this will help: http://www.codeproject.com/KB/tips/HowToUseGoogle.aspx?msg=2458041#xx2458041xx[^] The person who answered you here has given you all the important information ( that is, how to use the response object to write a file back out for download ). In fact, what you want is simpler, you just need to read the file bytes from the file system.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
It's pretty hard to reply for this message in forums. But I can give you some hints. My idea is try to create maximum possible id's with the supplied information. Check each id exist on the DB. If not show that to user. Assume user has specified name as Navaneeth and age as 24. Then possible id's could be navaneeth24 24navaneeth 24.navaneeth navaneeth.24. Then check each on DB and display only id's that doesn't exist on DB. It's wild guess. But try it
printf("Navaneeth!!") www.w3hearts.com
There are two attributes - overflow-x and overflow-y, which control the scrollbars independently, so to hide one and show the other, use something like...
"Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
SELECT Col1, Col2, Col3
FROM TABLE1 WHERE
Col4 >= ANY
( SELECT Col1 FROM TABLE2 WHERE DateAdded >= '21-Oct-2006')
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.
http://www.projectdmx.com/tsql/sqlarrays.aspx[^] You should be able to use CharIndex as the article in the link above suggests as one solution. select t1.* from table1 t1 join table2 t2 on charindex(',' + t1.col1 + ',' , ',' + t2.col1 + ',') > 0
It happens automatically. As soon as you start making changes the table will get locked until the transaction is completed. Since SQL Server will wrap each statement in its own transaction, if you are updating over several SQL statements use Begin Transaction at the start and Commit Transaction when successfully finished.
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
