Viewing 15 posts - 1,876 through 1,890 (of 5,504 total)
Darundo (2/21/2011)
...Any suggestion? Or additional information you need please let me know
Please provide table definition, sample data and expected results based on those sample.
February 21, 2011 at 2:15 pm
AJ-636201 (2/21/2011)
Hey Thanks Creig,So such a query can not be improved, there will always be an index scan.
So i think i got my answer:crying:
Thanks
There is (at least) one option left:
You...
February 21, 2011 at 1:02 pm
Please provide the sample data your result is based on in a ready to use format.
Your expected result and the "sample data" provided so far don't seem to match. Please...
February 21, 2011 at 12:57 pm
You don't need SSIS for it.
I'd recommend XQuery instead.
If you could provide a sample and your expected result we could show you an example based on your specific scenario.
Until then,...
February 21, 2011 at 8:29 am
Let's begin with the question "Why?":
What would be the benefit to add a set of character before a number? Please explain the business case in more detail so we can...
February 21, 2011 at 4:33 am
Are you sure you'er talking about SQL SERVER 2005 syntax?
If not, it would be very helpful if you would at least name the software and version you're dealing with...
February 20, 2011 at 5:04 pm
CAST(SUM (chg.TOTAL_QUANTITY / clpt.QUANTITY) AS DECIMAL(8,3)) AS calculated_exponent,
February 19, 2011 at 2:13 am
I would shred the comma separate list using a split string function and query the result. Search for DelimitedSplit8K here on SSC for a great example of a split string...
February 18, 2011 at 6:05 pm
...While I do have a specific problem to address...
What exactly would this specific problem be?
I cannot find it in your system description...
February 18, 2011 at 6:02 pm
I'd use the following approach:
Step 1: remove the string before the three equal signs (including two equal signs)
Step 2: replace all equal signs with commas
Step 3: call a string...
February 18, 2011 at 5:58 pm
Please provide table def and sample data in a ready to use format as described in the first link in my signature. Also please include your expected output based on...
February 18, 2011 at 5:52 pm
Have a look at Jacob Sebastians Blog for several examples.
February 18, 2011 at 5:49 pm
We currently have a performance issue with a 3rd party app.
The SQL code is not encrypted, the rest of the code mainly is stored in dll's.
I admitt I analyzed the...
February 18, 2011 at 5:45 pm
Hi Gregory,
please provide table def and sample data of all tables involved in a ready to use format. Also please include your expected result based on the sample data you...
February 18, 2011 at 5:17 pm
george sibbald (2/18/2011)
...I was going to stop, but confusing foreigners is too much fun. 🙂
Statement archived for future reference. 😀
Remember: all people on this planet are foreigners... 😉
February 18, 2011 at 5:02 pm
Viewing 15 posts - 1,876 through 1,890 (of 5,504 total)