Click here to Skip to main content
15,112,866 members

Comments by Gauri Chodanker (Top 7 by date)

Gauri Chodanker 18-Sep-14 6:34am View
   
Writing a stored procedure to get the name is not a valid point. Instead please let us know your exact table structures and the desired output. Maybe its a straight forward query that needs to be written
Gauri Chodanker 9-Jul-14 10:22am View
   
Please provide us with a tabular format of data which looks good to you and can be easily understood
Gauri Chodanker 20-Feb-14 7:52am View
   
Your query did not state anything of image.
Gauri Chodanker 20-Feb-14 7:46am View
   
Can you please provide me sample data and table name. I shall write the query for that.

Does your table MODELS_COLUMNS_STRUCTURE use some number field like primarykey. And what is the order in which your data is stored. Is it country first and then allocation or the order in which you want the data. If that is so then use the below query

SELECT DISTINCT somenumberfield, ListItem as ColumnName from (
SELECT REPLACE(ColumnsList, '$', ListItem) ListItem FROM dbo.MODELS_COLUMNS_STRUCTURE MCS
CROSS JOIN List_Resources WHERE Type = 'country data' ) A


Gauri Chodanker 20-Feb-14 7:44am View
   
Deleted
Yes simply remove the order by clause
Gauri Chodanker 12-Aug-13 2:25am View
   
Does that mean you already have the ID's with you, for which User may or maynot exists..
Well in this case why don't you try this

SELECT MIN(IDDocSell)
FROM TblSellDocument
WHERE IDUser IS NULL
Gauri Chodanker 7-Aug-13 5:50am View
   
Please explain the whole requirment