Viewing 15 posts - 5,266 through 5,280 (of 5,504 total)
You could check the following thread. It covers a variety of options how to import Excel files including several more links.
http://www.sqlservercentral.com/Forums/FindPost326846.aspx
If the Excel file always has the same location, file...
June 17, 2009 at 2:32 pm
It looks a little more like HTML file rather than XML structure.
That's a slightly different story...
You might want to have a look at the following article:
June 17, 2009 at 2:09 pm
What would be the output you're looking for?
June 17, 2009 at 1:34 pm
What happens if the resulting number of rows after applying selection criteria will be less than 1000?
Would that make the result incorrect?
Sounds like a very strange requirement/criteria to me...
To "prove"...
June 17, 2009 at 1:24 pm
Hi Jeff,
You're welcome!
Why copy the code from your article when a link transports the same message and rewards the effort you took to put those helpful articles together? 😉
June 17, 2009 at 1:09 pm
Please attach sample data together with a more detailed description on what you're trying to achieve.
It's not the "urgent" hint that gives you fast answers, it's the way you'll describe...
June 17, 2009 at 5:07 am
Hi,
as far as I can see Table A is not relevant since it is identical to table B except for the addtl. code column in table B.
So I'm using table...
June 16, 2009 at 2:33 pm
Is it possible to call the mapping software from a command line with input file and target file as parameter? Or start it from command line to process a batch...
June 16, 2009 at 1:48 pm
We're getting closer...
From what I understand so far you're getting EDI messages from an automotive OEM. Those messages are stored in an EDI inbox folder.
The goal is to have the...
June 16, 2009 at 11:13 am
Hi,
please have a look at the following post http://www.sqlservercentral.com/Forums/FindPost714447.aspx.
I used two CTEs for the PIVOT.
If you need further help please provide sample data as described in the link in my...
June 16, 2009 at 2:19 am
Hi,
AFAIK there are no "correct" data within a database. Data can (and should/must) be valid and consistant. But that does not mean they have to be "correct" from users perspective,...
June 16, 2009 at 1:05 am
Hi,
you could either use (dynamic) Cross Tabs or the PIVOT function.
Dynamic cross tabs are used if you don't have a fixed number of target columns (dates in your case).
Cross Tabs...
June 16, 2009 at 12:53 am
Hi Valle,
you might want to read the following article http://www.sqlservercentral.com/articles/SS2K5+-+XML/2982/.
If you have further questions please provide sample data as described in the link in my signature. Please use [ code="xml"...
June 16, 2009 at 12:47 am
If we're talking about a production related (or even production critical) process, I strongly recommend that you think about a process design not related to human interface.
Would you please name...
June 15, 2009 at 2:47 pm
Viewing 15 posts - 5,266 through 5,280 (of 5,504 total)