Viewing 15 posts - 2,296 through 2,310 (of 2,894 total)
I have answer to your question. You get the error because something is wrong!
Don't you mind to tell us the error you getting?
August 4, 2011 at 8:58 am
daveriya (8/4/2011)
if you dont want to help,dont comment
SQLServerCentral is the highly popular forum where SQL professionals offer free help to anyone who looks for it. In order to help you,...
August 4, 2011 at 8:10 am
You need to pivot results:
SELECT crn, [1] as CODE_POS_1,[2] as CODE_POS_2,[3] as CODE_POS_3
,[4] as CODE_POS_4,[5] as CODE_POS_5,[6] as CODE_POS_6,[7] as CODE_POS_7
,[8] as CODE_POS_8,[9] as CODE_POS_9,[10] as CODE_POS_10
from
(
SELECT t.crn,...
August 4, 2011 at 7:50 am
In a sample you have posted, you have separate independent select statements, so it will be no much performance difference in running:
SET @sql = 'Select * from table1;' + 'Select...
August 4, 2011 at 4:36 am
Have you tried to execute your code and checked the results? It does work as it is!
August 4, 2011 at 3:11 am
The answer to your first question: Yes, it is possible to run an SQL statement that is held within a column of a table?
The answer to your last question: Yes...
August 4, 2011 at 2:46 am
It's nothing to do with how NULL values are handled...
And the eeror you get clearly tells you that : "...object has no columns"
It's all to do with what OpenQuery...
August 3, 2011 at 9:32 am
Looks like OP has lost interest in his issue...
May be it was caused by something absolutely unrelated to SQLServer? May be he did not hit execute button? May be he...
August 3, 2011 at 8:13 am
Simple:
SELECT InstanceID, InstanceName, EnvironmentSpec, LastRefreshDate
FROM TableWhereItIsStored
August 3, 2011 at 7:54 am
"very slow query" from Lucky9?
Are you sure you have choosen the right nick? :hehe:
I would suspect that you do insert a lot into your table? Do you have regular DB...
August 2, 2011 at 9:35 am
Pagan DBA (8/2/2011)
...
As an aside, I'm sorry but BIT(1) = 1/0 is my preferred choice to VARCHAR(1) = Y/N. This is because in spite of my efforts, I have always...
August 2, 2011 at 9:29 am
nigel. (8/2/2011)
or
SELECT LEN(REVERSE('1 '))😛
I wanted to put this first, but it has limitation: will not work for string with trailing spaces :hehe:
August 2, 2011 at 8:29 am
Try to add the following straight after SET NOCOUNT ON line in your dynamic opwnrowset sql:
IF(1 = 0)
BEGIN
...
August 2, 2011 at 7:06 am
PaulSp (8/2/2011)
Should the Provider be receiving the Message-ID now - or could there be a further issue..? It is incumbent upon us to provide the agreed Header data -...
August 2, 2011 at 4:41 am
mahalaxmi.k62 (8/2/2011)
...Where am i going wrong.
The first place where you are going wrong is in ignoring of what was advised to you.
I wil try to advise the same again:
Please...
August 2, 2011 at 4:29 am
Viewing 15 posts - 2,296 through 2,310 (of 2,894 total)