Viewing 15 posts - 16 through 30 (of 37 total)
Thanks! Works beautiful.
Any advantages/disadvantages of using 'convert' vs. 'cast' ?
Maybe convert is slower but safer?
August 7, 2009 at 9:41 am
Oh, thanks! I'll check that out.
June 26, 2009 at 12:22 pm
Thanks ab5sr,
I have a slack working solution though not succinct and efficient.
What I did was:
DECLARE @FullResults TABLE
(
Ranking INT,
ID varchar(10),
Name varchar(100)
)
DECLARE @MaxNum INT;
INSERT INTO @FullResults
SELECT * FROM myoriginalquery
SET...
June 26, 2009 at 9:15 am
Your example, looks like it has two wrappings. The code below seem to work exactly the same as the code in my original post without the two wrappers tbl...
June 25, 2009 at 2:38 pm
I tried referencing as you mentioned, and as before I can reference RANK with no problem, but I can't get a reference to the max value of RANK into the...
June 25, 2009 at 1:35 pm
Are you talking about making a temp table? Not sure what you mean by removing group by.
June 25, 2009 at 12:46 pm
Thanks, got it now... it wanted an nvarchar rather than a varchar
June 18, 2009 at 3:05 pm
Thanks, getting this though: Incorrect syntax near 'sp_executesql'
June 18, 2009 at 2:52 pm
It's already added.... and I can select from it with no problem. I just wanted the wording for the linked server into a parameter for a stored proc.
June 18, 2009 at 2:18 pm
That's the thing, it DOES allow remote connections.
June 18, 2009 at 1:50 pm
Thanks for your patience.
As it turns out it looks like I have two different installations of SQL. The pre-installation seems to be SQL Workgroup 2005 or above...
June 18, 2009 at 1:19 pm
Thanks, I actually have two different named instances, not user instances if there is a correct distinction there.
I always have had FTS working well and fine (with advanced services) on...
June 18, 2009 at 8:14 am
From what I can tell, I am running both. Though I'm wondering what kind of SQL the webhost had pre-installed. It was SQL without the management studio or...
June 17, 2009 at 2:25 pm
Well, the other instance was some sort of pre-installation the webserver made. I've been using that old instance. But the newer instance can have the advanced services I...
June 17, 2009 at 9:17 am
Viewing 15 posts - 16 through 30 (of 37 total)