Ok.
You can create window based application using .net.
BHTanna
Last Activity: Apr 9 '10, 08:31 AM
Joined: Aug 8 '08
Location:
-
Pls let us know,
Your many excel files are stored at one location or different location?
Another thing, using DTS Package, you can import data from particular single excel file.. Stored at particular location on PC Where you are making / designing this DTS Package.
Cant you use some programming along with? If your many excel files are stored in particular folder, then you can make small utility, which takes folder's...Leave a comment:
-
Can you pls guide how to use CSS? I m new....
Thanks for your help..Leave a comment:
-
Regarding Formatting Web Pages of Project
Dear All Experts,
I m new to .net..
I wanted to apply same type of format settings like font size, font type, background color etc to each page of my project...
Is it possible to do by some option or i have to do it manually??? Pls guide... -
If it has seperator " "(Space) then use charindex and diff string functions...Leave a comment:
-
Try this store procedure..
CREATE PROCEDURE crosstab
@select varchar(8000),
@sumfunc varchar(100),
@pivot varchar(100),
@table varchar(100)
AS
DECLARE @sql varchar(8000), @delim varchar(1)
SET NOCOUNT ON
SET ANSI_WARNINGS ON
if exists(select name from sysobjects where name = '##pivotos' and type= 'U')
DROP TABLE ##pivotos
Print('SELECT ' + @pivot...Leave a comment:
-
All databases on same server?Leave a comment:
-
Now you are getting first error..
I suggest you to keep your excel file in c:\ of your server and simply try..
It seems you are violating some basic file sharing rules...
As this error indicates, either u dont have rights on this sheet or sheet doesnt exists.
Hope this will help.Leave a comment:
-
Seems in your statement declare @userprofilecnt @ is missing???Leave a comment:
-
Have u changed file path or moved file somewhere else???
It seems, your file does not exists now, may be you have chenged path or renamed it???
Or is it opened??? Then too u will get this error...
If it is in sharing, & used by someone else then too u will get this error...Leave a comment:
-
Can't you use sp_attach_db ????Leave a comment:
-
Hi,
I hope u have spelled you sheet name correctly...
Request you to rename the sheet which has data to "A" or something very easy....
Other than this, i dont find any other problem..
It should work perfectly....Leave a comment:
-
I mean, It will start displaying the records as its fatched...
It wont wait entire query to get executed.. Like enterprise manager..Leave a comment:
-
Actually, both are taking the same time.. But thru Enterprise manager, it just starts desplaying as records are fetched...
Same can be done thru Query Analyzer also, if u set Results in Text.
But in the both situations, all records will take same time.Leave a comment:
-
Dont you have SQL Enterprise Manager??? Above steps are for the same.
If u want to do the same using SQL Query Analyser, u need to save your excel file on Server's local drive and try following query...
Select * from OPENDATASOURCE( 'Microsoft.Jet. OLEDB.4.0',
'Data Source=c:\<file name>.xls; Extended Properties=Exce l 8.0')...[<sheet name>$]
Hope this will help.Leave a comment:
-
Last flight details should be of last year only or latest from data???
If you want from last year only then try following Query:
select P.[Last name],p.[First Name],d.[Total flights],[Last Flight Date],f.[flightName],p.seat
from PassengerFlight s P inner join
(
select [Passenger ID],count(*) as [Total flights],max(FlightDate ) as [Last Flight Date]
from PassengerFlight s p inner join...Leave a comment:
-
Let me tell you, what my function is doing exactly...
Here, getdate() is 13-Aug....
If BC date is 18-June i want payment made between 18-June and 12-July..
If BC date is 27-June i want payment made between 27-June and 12-July..
If BC date is 1-July i want payment made between 1-July and 12-July..
If BC date is 3-July i want payment made between 3-July and 12-July..
If BC date is 5-July i...Leave a comment:
-
But that varchar string will be parse here in query no???
Wont the function will be replaced with its output string and entire query will be executed then after ???
Is there any way to check what exactly function in returning???Leave a comment:
-
But, this user defined function returns condition which will have boolean output...
This is the basic requirement to use dynamic where part...Leave a comment:
-
Sorry.. I again gone thru your table structure...
pls try this and let me know..
select s.id, s.name, s.email, s.time, s.milliseconds
FROM scores s inner join
(
SELECT [name],mintime,min(mi lliseconds) as minsec
FROM scores T1
INNER JOIN
(
SELECT [name], min(time) AS mintime
FROM scores GROUP BY name
) T2 ON T2.name = T1.name AND T2(mintime). = T1.(time)...Leave a comment:
No activity results to display
Leave a comment: