|
Just out of curiosity.
If you bump this value up
@strSQL varchar(2000),
to something higher like
@strSQL varchar(3000),
do you get a different error?
edit:
And I don't know if this matters but you've got a disagreement here:
[GLName] Varchar(200),
@f_GLName varchar(50)
[FileNo] Varchar(50),
@f_FileNo varchar(30)
Weird errors creep in on things like this down the road even if the language lets you do it. I saw one TAL issue that took months to figure out because a variable was cutting a value off with a method like this.
_____________________________
Those who study history are doomed to watch others repeat it. -Scott M.
modified on Monday, June 8, 2009 1:44 PM
|
|
|
|
|
select @variable will only give the value inside it
you have try things like exec(@variable)
|
|
|
|
|
Hi Team,
I have an functional to retrieve data from hosting server to local server.Is there any option to set the custom installation to get facility of import and export via sqlserver2005 Express addition or is it needed to install any service pack for this.
Could any body help me out from the above scenario.
Thanks in advance.
Ram Panda(S.E.)
Ergode
|
|
|
|
|
Huh ! you question makes no sense (at least to me anyway) try restating your requirement and see if it gets a more positive response.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The following list highlights the major SQL Server 2005 components that are not supported in SQL Server Express:
Reporting Services
Notification Services
Integration Services
Analysis Services
Full text search
OLAP Services / Data Mining
From: http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspx[^]
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
Hello,
I have table in microsoft access with fields- partNumber, Date, Status.
( the status field always is one of two words - on or off
can I write a iif statement in sql that says IIf ([partNumber = a certain Date]), the status will automatically display off for those records with that part number.
I already have alot of records entered in database.
I have tried and not used to writing IIf statements in sql-
also wonder can you change a field that has data in it with a iif condition statement.
thank you
|
|
|
|
|
As I understand you then you want to display Status to OFF for some records which contain one certain data in field Date ?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
modified on Saturday, June 6, 2009 5:12 PM
|
|
|
|
|
|
here it is
select iif(value='2009.01.02','OFF',value) from table1
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
unfortunately this did not solve problem
I have partNumber Date and Status
I have tried Select partNumber,Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON) From table1
but still gettng errors-your sql statement is missing partNumber
thank you
modified on Sunday, June 7, 2009 7:34 AM
|
|
|
|
|
johnnysmith1 wrote: Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON)
Should be
Date <big>,</big> IIF(partNumber= 1011 and Date = #01/01/2006#,'OFF','ON')
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
You are welcome.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi Experts
How to alter Column To On Identity on Column
i am try this but not working
ALTER TABLE TEST ALTER COLUMN iD IDENTITY (200, 2)
|
|
|
|
|
Sharma Dinesh Kumar wrote: How to alter Column To On Identity on Column
ALTER TABLE Foo
ALTER COLUMN FooKey
ADD CONSTRAINT IDENTITY(100,1)
Regards
Aman Bhullar
www.arlivesupport.com[^]
|
|
|
|
|
This is not Working Give Me Error on CONSTRAINT
|
|
|
|
|
Does anyone have any ideas?
|
|
|
|
|
Hi friends
I m getting replicated images when I export crystal report having images in Word,PDF,Rtf etc.
Kindly suggest solution
|
|
|
|
|
And the relevance to a database is?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello ! I'm doing little project and I need database for it, but not whole server. So I choose Access ... But that's pain in the a**
I have a relatively simply query in which I need to do LEFT JOIN:
SELECT a.*, b.*
FROM a LEFT JOIN b ON (a.pid = b.pretplatnik_id) AND (a.iid = b.izdanje_id);
a and b are booth some other queries. I needed to do this because I can't do query inside a query in access And there's problem. It all works, except it shows only data from query a and nothing from query b. Everything from b is NULL. Interesting thing is that if I change part "LEFT JOIN" to "INNER JOIN" it returns booth results from query a and b. So does anyone have an idea why LEFT JOIN isn't working ?
Thanks for your time and help
|
|
|
|
|
try to use
LEFT OUTER JOIN
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks for help But it's not working Same result as just using "LEFT JOIN"
|
|
|
|
|
Well,if you don't mind then post here some tables data, and result which you want to get and we will try to give you hand on query.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks, but I've solved it
In b query I've had GROUP BY statement, and it was something like SELECT blabla FROM bla GROUP BY pid, iid;
Now I've changed it to SELECT blabla FROM bla GROUP BY iid, pid; and everything works ... Although I don't think there's any difference, but ok ... if there is, please explain it to me
|
|
|
|
|
It's possible to use DISTINCT instead of GROUP BY but when you had solution then let it as it is.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|