Viewing 15 posts - 4,966 through 4,980 (of 5,502 total)
XingThing (9/14/2009)
would adding an identity column help?
From my personal point of view and with respect to the original question: no.
Even with an identity column a mixed insert or an update...
September 14, 2009 at 2:59 pm
Greg Snidow (9/14/2009)
Then what happens when you try location >= 'A9' ?
Well, you're right, the ORDER BY Clause will lead to wrong results 🙁
Nevertheless, I'd "blame" it on the data...
September 14, 2009 at 2:33 pm
At this point I'd like to ask you to do some research.
Here are two possible sources:
http://www.sqlservercentral.com/articles/SS2K5+-+XML/3022/
and
BOL, section "FOR XML clause".
To play around with the various options of FOR XML is...
September 14, 2009 at 12:27 pm
jcrawf02 (9/14/2009)
To quote:
The answer is simple as well:
SELECT *...
September 14, 2009 at 12:15 pm
jsheikabdullah (9/14/2009)
In the front end can u tell me the logic how to do it
For what type of front end?
September 14, 2009 at 2:09 am
Where do you want to convert the date format - SSRS or Database?
If the latter I strongly recommend against it. Date formatting should be done at the front end side...
September 14, 2009 at 1:13 am
It is a 4-core server, I don't know how many are dedicated to SQL, how can I check this?
In Management Studio, right click on the Server in the Object...
September 13, 2009 at 4:14 pm
Does your console app allow for parallel processing?
What is the hardware configuration of your Server? (e.g. How many CPU's and how many of them usable for SQL Server?)
Do you import...
September 13, 2009 at 2:22 pm
Duplicate post.
Please continue here .
September 13, 2009 at 11:16 am
Hi phanatico,
posting way over 400 lines of VB code in an SQL forum probably won't find many volunteers to look at it...
You should try to narrow the issue down to...
September 13, 2009 at 6:40 am
venu_ksheerasagaram (9/13/2009)
Thank you Lutz,Thanks a lot.
You're very welcome. 🙂
If you'd like to (or have to) look deeper into XQuery I'd like to redirect you to one of my...
September 13, 2009 at 6:32 am
Change your select clause to
SELECT c.value('Name[1]', 'varchar(50)'),
c.value('EmpNtId[1]', 'varchar(30)'),
c.value('CreateBy[1]', 'varchar(30)'),
...
September 13, 2009 at 6:18 am
Paul White (9/13/2009)
Thanks Lutz. Let's try that again, with the xml formatter (see below).If that fails, I'll attach it as a file!
It fails, but it's successful at the same...
September 13, 2009 at 5:57 am
Did you copy it straight from the front end or did you use the "Quote" button to see the "real code"?
Reason: SSC displays XML data not exactly as in...
September 13, 2009 at 5:42 am
Following please find an untested proposal.
It should be verified using a test system and not used for production directly.
Since you didn't provide any sample data nor expected results we don't...
September 12, 2009 at 11:40 am
Viewing 15 posts - 4,966 through 4,980 (of 5,502 total)