command textbox in job has limitations ?

Hi ,
Is there any word limitations in the command text box of a job Management --
> SQL Server Agent --> Jobs '
it seems there is and it has given me some issue.
i have pasted all the SQL statements into a .sql file but how do i call that
file ?
i know using Osql is able to do so but is there other easier method (i.e i
dun have to create a batch file with the osql commands) w/o having to create
too many files
apreciate ur advice
tks & rdgs
Message posted via http://www.webservertalk.commaxzsim via webservertalk.com (u14644@.uwe) writes:
> it seems there is and it has given me some issue.
> i have pasted all the SQL statements into a .sql file but how do i call
> that file ?
> i know using Osql is able to do so but is there other easier method (i.e
> i dun have to create a batch file with the osql commands) w/o having to
> create too many files
You could put the stuff in a stored procedure, although this has some
implications, and depending on what your script does it may not be
practical.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||tks Erland Sommarskog , i have used DTS and put the script in the SQLTask
Erland Sommarskog wrote:
>[quoted text clipped - 4 lines]
>You could put the stuff in a stored procedure, although this has some
>implications, and depending on what your script does it may not be
>practical.
>
Message posted via http://www.webservertalk.com

comboboxes input parameter

Is it possible to configure combo box with values depending on another
combobox selection in Reporting Parameters
e.g.
Input1: a combobox with country
Input2: should dynamically display states in the selected country, which
user can select.
appreciate any pointers . thxOn Apr 19, 12:06 pm, "nkg" <x...@.yahoo.com> wrote:
> Is it possible to configure combo box with values depending on another
> combobox selection in Reporting Parameters
> e.g.
> Input1: a combobox with country
> Input2: should dynamically display states in the selected country, which
> user can select.
> appreciate any pointers . thx
Sure. What you want to do is create a dataset to use for the second
report parameter (in the Data tab, select the <New Dataset...> option
from the drop-down list to the right of Dataset) and include the usual
query as well as the place holder parameter (i.e., select States from
StateTable where Country = @.Country). Then select the 'Edit Selected
Dataset' button [...] and on the Parameters tab enter in the Name of
the parameter (in this case, @.Country) [it is case sensitive by the
way] and select the Parameter that @.Country should be dependent on
(most likely, something like: Parameters!Country.Value). hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thx. a lot that worked.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1177009678.611966.300310@.b58g2000hsg.googlegroups.com...
> On Apr 19, 12:06 pm, "nkg" <x...@.yahoo.com> wrote:
>> Is it possible to configure combo box with values depending on another
>> combobox selection in Reporting Parameters
>> e.g.
>> Input1: a combobox with country
>> Input2: should dynamically display states in the selected country, which
>> user can select.
>> appreciate any pointers . thx
>
> Sure. What you want to do is create a dataset to use for the second
> report parameter (in the Data tab, select the <New Dataset...> option
> from the drop-down list to the right of Dataset) and include the usual
> query as well as the place holder parameter (i.e., select States from
> StateTable where Country = @.Country). Then select the 'Edit Selected
> Dataset' button [...] and on the Parameters tab enter in the Name of
> the parameter (in this case, @.Country) [it is case sensitive by the
> way] and select the Parameter that @.Country should be dependent on
> (most likely, something like: Parameters!Country.Value). hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 20, 2:45 pm, "nkg" <x...@.yahoo.com> wrote:
> thx. a lot that worked."EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1177009678.611966.300310@.b58g2000hsg.googlegroups.com...
> > On Apr 19, 12:06 pm, "nkg" <x...@.yahoo.com> wrote:
> >> Is it possible to configure combo box with values depending on another
> >> combobox selection in Reporting Parameters
> >> e.g.
> >> Input1: a combobox with country
> >> Input2: should dynamically display states in the selected country, which
> >> user can select.
> >> appreciate any pointers . thx
> > Sure. What you want to do is create a dataset to use for the second
> > report parameter (in the Data tab, select the <New Dataset...> option
> > from the drop-down list to the right of Dataset) and include the usual
> > query as well as the place holder parameter (i.e., select States from
> > StateTable where Country = @.Country). Then select the 'Edit Selected
> > Dataset' button [...] and on the Parameters tab enter in the Name of
> > the parameter (in this case, @.Country) [it is case sensitive by the
> > way] and select the Parameter that @.Country should be dependent on
> > (most likely, something like: Parameters!Country.Value). hope this
> > helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Combo box to exclude blank input

Hi
I have a combo box that displays a list of company names. Some entries do
not have a company name on the form so the textbox remains blank. Therefore
in the combo box there are alot of blanks in the list. How do I get the
combo box to just list out the company names without the blanks?
At the moment I have this:
SELECT Contacts.ID, Contacts.CompanyName
FROM Contacts;
Thanks in advance
SeanThe following will exclude NULL or blank CompanyName rows:
SELECT Contacts.ID, Contacts.CompanyName
FROM Contacts
WHERE
Contacts.CompanyName IS NOT NULL AND
Contacts.CompanyName <> '';
Hope this helps.
Dan Guzman
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:9930ACDB-8E70-45B8-94B1-89A8DF57B60F@.microsoft.com...
> Hi
> I have a combo box that displays a list of company names. Some entries do
> not have a company name on the form so the textbox remains blank.
> Therefore
> in the combo box there are alot of blanks in the list. How do I get the
> combo box to just list out the company names without the blanks?
> At the moment I have this:
> SELECT Contacts.ID, Contacts.CompanyName
> FROM Contacts;
> Thanks in advance
> Sean|||Isn't there a Company table that, by definition, wouldn't have empty
company names?
If not, then one should be added - basic normalization.
Sean wrote:
> Hi
> I have a combo box that displays a list of company names. Some entries do
> not have a company name on the form so the textbox remains blank. Therefor
e
> in the combo box there are alot of blanks in the list. How do I get the
> combo box to just list out the company names without the blanks?
> At the moment I have this:
> SELECT Contacts.ID, Contacts.CompanyName
> FROM Contacts;
> Thanks in advance
> Sean

combo box error

I have a combo box that displays a list of records.
When a user clicks on a combo box selection all the textboxes will populate with a value from the selected record of the combo box. But instead of populating the fields it gave me an error message: Object doesnt support this property or method

I am developing in Access 2000 and using SQL Server as back-end.

Sub Combo5_AfterUpdate()
' Error occurred next line
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo5]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Thank you!This ain't be SQL problem could be Access, check with Access forums.