Viewing 15 posts - 46 through 60 (of 74 total)
Any ideas how to fix it...
Found this fix
But it isn't the same error
Sure some people must have similar errors..
Thanks
March 31, 2008 at 8:32 pm
Thanks but thats whats in the colum name in Excel
Its with a dot [Account Reference No.]
Any work around?
January 22, 2008 at 11:06 pm
Although i fixed it.....but i will try your advice and let u know.
Thanks
December 21, 2007 at 5:51 am
Thanks but that wasn't the problem though
December 20, 2007 at 9:40 pm
thanks for the reply.
it refers to the Location table
thanks in advance
December 20, 2007 at 5:21 am
Why are you prosposing this.
I'm thinking of writing a Store proc for this..
Any reason why thanks..
November 28, 2007 at 11:15 pm
Well i got it working
this did it
set @sqlrest = 'E.FirstName' +' , '+ 'E.LastName'
November 28, 2007 at 9:38 pm
Yes and getting confused now..
Still get the error:
Incorrect syntax near ','.
on line
set @sqlrest = ', E.FirstName + ',' + E.LastName'
declare @term as varchar(50)
declare @MyCount as varchar(2)
declare @sql as nvarchar(200)
declare...
November 28, 2007 at 9:17 pm
Thanks and normally i won't go for dynamic sql.
I want to use it for my Ajax part of my application which is an auto completebox
But when i tried your suggestion...
November 28, 2007 at 8:53 pm
I have tried that put nothing is printed out:crying:
November 28, 2007 at 8:35 pm
Thanks i actually solved it using dynamic query like below:
But now i want to concantenate the FirstName and the LastName
but want to use the parameter @sqlrest
but when i run the...
November 28, 2007 at 7:50 pm
To add one more thing.
I think XML is very good for hierachical data structures e.g Treeview etc..
Patrick
February 20, 2007 at 3:57 pm
fixed my brain was asleep
November 9, 2006 at 9:12 pm
Thanks guys i ended up using RunningValue:-
http://msdn2.microsoft.com/en-us/library/ms159136.aspx
And it worked like a charm
PAtrick
October 26, 2006 at 12:38 am
Viewing 15 posts - 46 through 60 (of 74 total)