isnumeric(column name) to check whether the column has any numeric values in it.

SELECT p1.CategoryId,

( SELECT ProductName + ','

...

:angry:

Dude....Dont post any questions when you dont have time to Check back what you've posted......I'm here to help with some issues....and not to waste my time.....

Place the SQL Code in SP give input parameters if any....use SqlCommand, SqlConnection, Sql PArameters to exec SP and to pass Parameters in Visual Studio.....

What do you mean by modifying? Changing the columns you select or chang the logic, you can see the execution steps in execution plan along wid the time it takes...

If the Pages in your application are accessing the Database.....u need to setup permissions to execute scripts on your Database..for that user...

Express doesnt allow remote connections, so please check the requirement....as you can extract data from two tables into your application and you can use LINQ if you are using C#...

try this:

SELECT convert(varchar(10),[yourdatecolumn],121) as Dateonly FROM dbo.v_all_tracking_table

Run the query part ot the SP on production server and see the execution plan, this way you can see which part of your query is taking so much amount...

sorry i've used table datatypes for your tables toavoid creating tables in my database

here is the code again

DECLARE @TEMPTABLE TABLE(USERID INT, USERNAME VARCHAR(MAX), TAGNAME VARCHAR(MAX), USERCOUNT INT)

INSERT INTO @TEMPTABLE

SELECT USERS.Id...

I THINK YOU CAN DO SOME FORMATTING.......ELSE JUST LET ME KNOW....nimbala29@gmail.com

HERE IS THE CODE, HAVE FUN :-):

DECLARE @TEMPTABLE TABLE(USERID INT, USERNAME VARCHAR(MAX), TAGNAME VARCHAR(MAX), USERCOUNT INT)

INSERT INTO @TEMPTABLE

SELECT USERS.Id AS USERID, USERS.FirstName +', '+USERS.LastName AS USERNAME,A.TagName , A.USERSCOUNT...