Viewing 15 posts - 3,406 through 3,420 (of 4,087 total)
The problem is this line here:
CAST ( ( SELECT td='<a href=''http://ABC:7777/XYZ/TYPE/EditForm.aspx?ID=0&UID='''+CAST(ACTIVITY_UID AS VARCHAR(36))+'''''>'+ACTIVITY_NAME+'</a>','',
Because you have given it an alias ("td") it treats the data as text instead of XML....
December 21, 2011 at 6:39 am
ulteriorm (12/20/2011)
I suspect the bind phase of query execution is trying to resolve the stores table data, and since it could not find the Info column, it threw an error.
This...
December 20, 2011 at 12:53 pm
This sounds like it might be due to differences in the language settings between the various computers. To prevent these kinds of problems, you want to make sure
* ...
December 20, 2011 at 12:39 pm
Formatting should be left to the presentation layer, because it can vary depending on the language or user preferences. Dates should be stored with the DATE datatype, so that...
December 20, 2011 at 12:16 pm
unnati.patel513 (12/20/2011)
yes i lookng for something like that.. when you click value in column it will open the xml coding in SSMS..
This will happen automatically in SSMS for anything that's...
December 20, 2011 at 12:05 pm
There is actually another possibility, but it's highly unlikely.
Your table is set up with case sensitive column names and you have another column in that same table that differs only...
December 20, 2011 at 12:00 pm
ulteriorm (12/20/2011)
I am pretty sure that we have only one Stores table;
I'm pretty sure that you do and the fact that you are only "pretty sure" and not positive indicates...
December 20, 2011 at 11:50 am
Narud (12/20/2011)
I'm a little bit confused about the field names and the content of your sample code, but I think that this would give you a near result to your...
December 20, 2011 at 11:30 am
You probably have two tables named "stores" under different schemata. Adding a condition for Table_Schema should fix the problem.
Drew
December 20, 2011 at 9:56 am
The problem is that your hierarchy is improperly modeled. Your structure is incomplete. You have node data and depth data, but you don't have the information about how...
December 20, 2011 at 9:40 am
He's confusing the UI (SSMS) with the database. SSMS will display XML results as clickable text when using the grid display.
Drew
December 20, 2011 at 8:50 am
You want to totally scrap your method and start over using a set-based approach. CURSORS are as slow as molasses in January.
This is essentially a reverse running total. ...
December 19, 2011 at 9:50 am
Your Current_Stmt_Date is coming in as a BLANK not NULL. Your DateAdd is converting the BLANK to 1900-01-01 and then adding 16 days to it to get 1900-01-17. ...
December 19, 2011 at 9:38 am
sami.sqldba (12/19/2011)
Please can anyone say which would be the best possible join can be used to get the task.
You should be able to answer this for yourself. Ask yourself...
December 19, 2011 at 8:26 am
SQLQuest29 (12/16/2011)
But my problem is that the data is integer and I get it as 465, 356, etc .. I need to convert it into meaning full data.
You're going to...
December 16, 2011 at 2:36 pm
Viewing 15 posts - 3,406 through 3,420 (of 4,087 total)