Comments by Gauri Chodanker

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

Comments by Gauri Chodanker (Top 7 by date)