|
Excel cell which is having Excel Formula instead of value.
Thanks,
Nagaraj
|
|
|
|
|
We've used Intellisync in the past for synchronizing databases ... they've basically gone out of busines, and I'm interested in knowing what software others use to synchronize ms sql databases.
The software has to be capable of implementing rules for synchronization, so I can sync select data / tables.
Thanks!
Paul Brower
|
|
|
|
|
What about writing your own using Sync Framework?
|
|
|
|
|
Hi i try to insert 195 countries at a time in sql. For that i have used BULK insert query. My Query is
BULK INSERT hrmsuser.country FROM 'C:\data.txt'WITH (
DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
MYPROBLEM:
Cannot bulk load. The file "C:\data.txt" does not exist.
Pls Anyone Help Me........
|
|
|
|
|
Hemalatha.A.M. wrote: The file "C:\data.txt" does not exist.
Those 195 countries are listed in a file? I'll bet that the file isn't called "C:\Data.txt"..
I are troll 
|
|
|
|
|
what is it called then?
|
|
|
|
|
|
pagefile is locked 
|
|
|
|
|
Luc Pattyn wrote: pagefile is locked
My bad, the file is indeed locked whilst Windows' runs. That's quite easy to patch though, may I kindly suggest these steps;
* Put your swapfile on an USB-stick
Right-click "My Computer", choose "Properties", Tabpage "Advanced", button "Settings" of the groupbox "Performance", Tabpage "Advanced", button "Change" of the groupbox "Virtual Memory".
* Load the textfile into your favorite webbrowser. You can either view it locally, or find a good host for this file, preferably with FTP-access and high uptime.
* Minimize the browser, and load a 4 Gb movie on Kiwi's (the bird, not the fruit) into MovieMaker. This might cause the contents of the browser to be swapped to virtual memory. I say might, as one never can be sure whether God is or isn't addicted to playing dice.
* Yank out the USB-stick as quickly as you can, so that only a minimum amount of bits will spill out of the USB-port. You now have a crashed Windows-system and a pagefile on USB-disk.
* Reinstall Windows, and when done, run chkdsk.exe on your USB-stick. Pray to Codd, while sacrificing a HP-calculator during the first Googledance.
There you have it; a "pagefile.sys", that may or may not contain a complete or partial list in a non-readable format, ready to be peek'd, poke'd and goes very well with mayonaise
I are troll
|
|
|
|
|
So now I have to order:
- a PC with USB (making sure I have a Win install disk)
- a USB stick (easily yankable)
- a Kiwi movie (any recommendation?)
- a set of napkins to clean up spilled bits
- an HP calculator
[ADDED] No mayonaise; still have some [/ADDED]
I think I'd rather spend half an hour looking up countries in Wikipedia and recreating the list myself. Actually I could write a program to do just that...
modified on Monday, April 20, 2009 5:38 PM
|
|
|
|
|
It does sound like a good idea to create an application to automate the task of reading the Wikipedia. I'm looking forward to your article 
I are troll
|
|
|
|
|
Highly likely your file is on your local c drive and you are executing the bulkcopy on the server so it is looking at the servers c drive!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
I have to reports A and B
A is main report which contain pie chart
when i click on any part of the chart i'll jump to the next report B
now i have two ways to do this
one: select Jump to report action but the problem is am displaying the report in aspx page using ReportViewer because i only have one reportviewer and can only define one path for it
two: select Jump to url action and it alomst work but am stil facing another problem which is how to get the value from the clicked part of the chart and pass it throw Query String, if i wrote the url in following case it will consider it all as string
- http://www.mysite.com/mypage.aspx?Param=&Fields!myField.Value -
but if i wrote it like next one it will discard the url i wrote and took me directly to the server of reporting services and display thw value of the field
- "http://www.mysite.com/mypage.aspx?Param="&Fields!myField.Value - it will take me to
- "http://ReportingServicesAddress/"XXX
so can you help me with any one of those
thank in advance
|
|
|
|
|
Hello
I have a column name RegionID in my table name tblAllSale. The column RegionID has values like
C1H1D01
C1H1D02
C2H1D01
C2H1D02
C3H1D01
C3H1D02
.......
Now I need to show all the columns of the table based on the first two character of the column name RegionID. Something like this:
C1 AZN BVG 54
C1 AZK HNJ 76
C2 AVK JMK 45
C2 ALO HNO 89
Now how can I do this..??
Thanking in Advance
Johnny
|
|
|
|
|
|
|
Try this,
SELECT SUBSTRING('C1H1D01',1,2)
Niladri Biswas
|
|
|
|
|
hello
CURSOR bad (Performance) in Oracle and MySQL as well? Or just M$SQL?
Thanks
dev
|
|
|
|
|
Cursors generally don't perform well in any database. Although I read that Oracle have done a lot of work to optimise cursors so it may not be as bad in Oracle. However, it is generally best to do as much as you can using set based queries (i.e. queries that operate on a lot of rows at once) as that is what databases are good at.
|
|
|
|
|
|
Colin Angus Mackay wrote: I read that Oracle have done a lot of work to optimise cursors
Yes that's right. In fact, I think it is the only way to return a set of results from a oracle stored procedure.
|
|
|
|
|
Hey, Guys Let me just lay out the problem:
I have 2 tables
table Function
FID
FName
Table Materials
MID
MName
FunctionID1 (foriegn key for FID)
FunctionID2 (foriegn key for FID)
Now I want to select all columns from Materials table, instead of FunctionID1 and FunctionID2, I want to have their related text (FName).
SELECT M.MID, M.MName, F.FName, F.Fname FROM Materials AS M INNER JOIN Function AS F
ON FunctionID1=F.FID OR FunctionID2=F.FID
WHERE FunctionID1 = X(input) and FunctionID2 = X(input)
I want this query to search for records in which FunctionID 1 is The input or FunctionID2 is equal to related input!!!! buy when I do this, It fetches two rows for a row and in each one FunctionID1 and FunctionID2 are the same !
How should I fix this???
|
|
|
|
|
If the content of the rows is the same DISTINCT might be useful. Using OR in a join statement is always going to cause you problems.
You may also want to use sub selects, do your initial filtering in the from (select)
Select *
from (Select * from Function where Id1 = @ID1) X
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
How about using two joins like this:
SELECT M.MID, M.MName, F1.FName, F2.Fname
FROM Materials AS M
INNER JOIN Function AS F1 ON M.FunctionID1=F1.FID
INNER JOIN Function AS F2 ON M.FunctionID2=F2.FID
WHERE FunctionID1 = X(input) and FunctionID2 = X(input)
Regards,
Syed Mehroz Alam
My Blog
My Articles
Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein
|
|
|
|
|
Actually, I think you'd want to use two LEFT OUTER JOINS, as you'll want to return a match on FunctionID1 or FunctionID2 (unless I've read this all incorrectly):
select M.MID, M.MName, F1.FName [F1Name], F2.FName [F2Name]
from Materials M
left outer join Functions F1 on F1.FID = M.Function1ID
left outer join Functions F2 on F2.FID = M.Function2ID
where F1.FID is not null or F2.FID is not null
The WHERE clause will elimitate records where neither the Function1ID nor Function2ID match the input value. And the double LEFT OUTER JOINs will cause records where either the Function1ID or Function2ID match the supplied input value to be pulled.
Hope in one hand and poop in the other; see which fills up first. Hope and change were good slogans, now show us more than words.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
