Check box insert question

I have 3 tables - Data, Facility and FacilityKey

The FacilityKey table will hold the Data ID and Facility ID based on a series of check boxes on a form.

My question is what is the best way to do the insert into the FacilityKey table from the form? If 5 facilities are checked I don't want to do 5 separate calls to the database for inserts, but I'm a bit confused on what the best method would be.

Thank you!I can't really think of any other way. You're going to need to call 5 INSERT statements, each inserting a single row. You can use the one connection to do this. To be honest, I don't think SQL Server is going to struggle with this.

Cheers
Ken

Check Box in reprting services

Hi!
I don't know how to have check box in reporting services.Hi Shima,
This is the round about solution that we had worked on.
First, your query should return the following values for True as 'x' and for
false as 'o' (for ex., i have an gender field in my db wherein I have set
that field as bit. Now in my query, I have it
case when gender=1 then 'x' else 'o' end) as Gender
Now in your report, after you pull this field onto the report layout, change
the font to "wingdings" and this should solve your problem.
Regards,
Sudhakara.T.P.
"shima.seifolahi@.gmail.com" wrote:
> Hi!
> I don't know how to have check box in reporting services.
>|||On Oct 18, 2:49 pm, Sudhakara.T.P.
<Sudhakar...@.discussions.microsoft.com> wrote:
> Hi Shima,
> This is the round about solution that we had worked on.
> First, your query should return the following values for True as 'x' and for
> false as 'o' (for ex., i have an gender field in my db wherein I have set
> that field as bit. Now in my query, I have it
> case when gender=1 then 'x' else 'o' end) as Gender
> Now in your report, after you pull this field onto the report layout, change
> the font to "wingdings" and this should solve your problem.
> Regards,
> Sudhakara.T.P.
>
> "shima.seifol...@.gmail.com" wrote:
> > Hi!
> > I don't know how to have check box in reporting services.- Hide quoted text -
> - Show quoted text -
Hi!
my problem isn't it,becuse i want to have check box in run time ,for
example i want to select two or three names of employers in first
report then i want to show names of their emploeeys in the second
report (i want to show these informations of these employers together,
not one by one ) and i need to have check box in first report ,thses
two reports have relation via navigation , till now i haven't have
any solution for it .
But I hope!

check box in parameters

How do I display check boxes in parameters.. I want the user to be able to
select multiple options that can be passed into the Query.. please help.
For example,
Select * from branch where branchregion in ('NORTHEAST','SOUTHWEST','
SOUTHEAST')..
RKSql Server 2000 Reporting Services does not directly support this
functionality. It is on our wish list for inclusion in a future release.
However there is an solution to this post on the GotDotNet.com web site:
http://www.gotdotnet.com/Community/Resources/Default.aspx?AFXPath=/Resource%5b@.ResourceId='2E882C0A-8D2B-4EAD-81BE-8E66C0941A18'%5d
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"RK Balaji" <rk.balaji@.gmail.com> wrote in message
news:ux5BwXHhEHA.4092@.TK2MSFTNGP10.phx.gbl...
> How do I display check boxes in parameters.. I want the user to be able to
> select multiple options that can be passed into the Query.. please help.
> For example,
> Select * from branch where branchregion in ('NORTHEAST','SOUTHWEST','
> SOUTHEAST')..
> RK
>
>
>

Check box in a Combo Box

Hi,
Iam working on a window application using .NET framework 2.0.
I want a check box + some text in a combobox.
User can select multiple items in combo box by using the check
box.
My requirement is : I have a report page. User selects some data
and click on 'Show Report'. Iam showing (I must show) the report also
in the same page. When user selects some other data, and click on 'Show
Report' button new data will be populated.
On this page I have an "Items" Combo box. User may select more than one
Item. Since multi selection property is not there for combo box, Iam
forced to go for ListBox. But Listbox is occupying more space and the
look is bad.
I have seen a CheckedComboBox article here:
http://www.codeproject.com/combobox...&forumid=114...
Its in VC++ I think. I need the same kind of functionality in .NET.
I hope its possible. But dont know how to start with it.
I tried creating a class that is inherited from ComboBox. The class
contains a CheckBox, ItemText Properties. But whats next? Iam unable to
proceed. Could you please help..........
Any ideas or code snippet........ Please............
Regards,
Bharathi Kumar.Please post this to a .Net programming group.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bharathi Kumar" <bharathidotnet@.gmail.com> wrote in message
news:1149768936.113891.259960@.u72g2000cwu.googlegroups.com...
Hi,
Iam working on a window application using .NET framework 2.0.
I want a check box + some text in a combobox.
User can select multiple items in combo box by using the check
box.
My requirement is : I have a report page. User selects some data
and click on 'Show Report'. Iam showing (I must show) the report also
in the same page. When user selects some other data, and click on 'Show
Report' button new data will be populated.
On this page I have an "Items" Combo box. User may select more than one
Item. Since multi selection property is not there for combo box, Iam
forced to go for ListBox. But Listbox is occupying more space and the
look is bad.
I have seen a CheckedComboBox article here:
http://www.codeproject.com/combobox...&forumid=114...
Its in VC++ I think. I need the same kind of functionality in .NET.
I hope its possible. But dont know how to start with it.
I tried creating a class that is inherited from ComboBox. The class
contains a CheckBox, ItemText Properties. But whats next? Iam unable to
proceed. Could you please help..........
Any ideas or code snippet........ Please............
Regards,
Bharathi Kumar.

Check all CPU's are used

We added a new CPU to our 1 CPU box making it a 2 CPU box.
In order to check that Sql is using both CPU's, I'm going
to load 2 bcp files simultaneously. I'll check the task
manager to monitor that CPU usage increases for both CPU's.
Is there a better way to show my sysadmin that both CPU's
are being used ? He refuses to believe that SQL will
recognize both CPU's without a reconfiguration.
TIA,
JackIn Enterprise Manager, right-click the server name, select properties and
click the processor tab. Check the CPUs you want to use. You may need to
stop and restart the services...can't remember.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...

quote:

---

> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack

---

|||Hi,
No need to do a configuration change to use the second CPU.
How to check is.
1. Use the Performance monitor from Control panel ...Admin tools
2. From the conter, u have to select Processor and select the 2 CPUs
seperately.
3. Now you run your SQL server batch processes.
This will give you a picture of CPU usage.
Thanks
Hari
MCDBA
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...

quote:

---

> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack

---

Check all CPU's are used

We added a new CPU to our 1 CPU box making it a 2 CPU box.
In order to check that Sql is using both CPU's, I'm going
to load 2 bcp files simultaneously. I'll check the task
manager to monitor that CPU usage increases for both CPU's.
Is there a better way to show my sysadmin that both CPU's
are being used ? He refuses to believe that SQL will
recognize both CPU's without a reconfiguration.
TIA,
JackIn Enterprise Manager, right-click the server name, select properties and
click the processor tab. Check the CPUs you want to use. You may need to
stop and restart the services...can't remember.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack|||Hi,
No need to do a configuration change to use the second CPU.
How to check is.
1. Use the Performance monitor from Control panel ...Admin tools
2. From the conter, u have to select Processor and select the 2 CPUs
seperately.
3. Now you run your SQL server batch processes.
This will give you a picture of CPU usage.
Thanks
Hari
MCDBA
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack

Changing Virtual Directories

Hello, I'm installing reporting services on a new sql server 2005 box. While
on the machine, I go to Reporting Services Configuration Manager, I'm trying
to create the report server virtual directory and report manager virtual
directory. My issue is that I don't want to create them on the sql box but
on another web server. I don't get an option to tell it to create a New
folder on anywhere put the sql server.
How can you do this?
Thanksyou have to install RS on this second server... and you have to pay for the
license...
you can use the first server to host the RS database, but you have to go
through the setup process for the new web server.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> Hello, I'm installing reporting services on a new sql server 2005 box.
> While
> on the machine, I go to Reporting Services Configuration Manager, I'm
> trying
> to create the report server virtual directory and report manager virtual
> directory. My issue is that I don't want to create them on the sql box
> but
> on another web server. I don't get an option to tell it to create a New
> folder on anywhere put the sql server.
> How can you do this?
> Thanks
>|||Are you sure that's how the licensing works? I thought you only had to pay
for additional licenses if you were doing it in a farm, or if your database
server was 1 cpu and the web server had 2 CPU.
So, If I run the setup on the web server then when i go into Reporting
Services Configuration Manager on the web server and select the database on
the sql server? Or do you do the configuration manager from the sql server.
Thanks
"Jeje" wrote:
> you have to install RS on this second server... and you have to pay for the
> license...
> you can use the first server to host the RS database, but you have to go
> through the setup process for the new web server.
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > Hello, I'm installing reporting services on a new sql server 2005 box.
> > While
> > on the machine, I go to Reporting Services Configuration Manager, I'm
> > trying
> > to create the report server virtual directory and report manager virtual
> > directory. My issue is that I don't want to create them on the sql box
> > but
> > on another web server. I don't get an option to tell it to create a New
> > folder on anywhere put the sql server.
> > How can you do this?
> >
> > Thanks
> >|||On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
> Are you sure that's how the licensing works? I thought you only had to pay
> for additional licenses if you were doing it in a farm, or if your database
> server was 1 cpu and the web server had 2 CPU.
> So, If I run the setup on the web server then when i go into Reporting
> Services Configuration Manager on the web server and select the database on
> the sql server? Or do you do the configuration manager from the sql server.
> Thanks
> "Jeje" wrote:
> > you have to install RS on this second server... and you have to pay for the
> > license...
> > you can use the first server to host the RS database, but you have to go
> > through the setup process for the new web server.
> > "Don" <D...@.discussions.microsoft.com> wrote in message
> >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > > Hello, I'm installing reporting services on a new sql server 2005 box.
> > > While
> > > on the machine, I go to Reporting Services Configuration Manager, I'm
> > > trying
> > > to create the report server virtual directory and report manager virtual
> > > directory. My issue is that I don't want to create them on the sql box
> > > but
> > > on another web server. I don't get an option to tell it to create a New
> > > folder on anywhere put the sql server.
> > > How can you do this?
> > > Thanks
The licensing scheme that Jeje mentioned is correct (reference:
http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
link should help in terms of the Configuration process.
http://msdn2.microsoft.com/en-us/library/ms157293.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, so I have a sql server but I don't want to install the reporting
services piece on the sql server (using the IIS installed on SQL box) because
I want people outside of the network to see the reports using the report
manager.
I believe that if I have it installed on the sql server then only people in
the office will be able to see it. So, sql server reporting servies is only
really every included in your purchase of sql server if you want to only
display the data with people logged onto your network?
Thanks
"EMartinez" wrote:
> On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
> > Are you sure that's how the licensing works? I thought you only had to pay
> > for additional licenses if you were doing it in a farm, or if your database
> > server was 1 cpu and the web server had 2 CPU.
> >
> > So, If I run the setup on the web server then when i go into Reporting
> > Services Configuration Manager on the web server and select the database on
> > the sql server? Or do you do the configuration manager from the sql server.
> >
> > Thanks
> >
> > "Jeje" wrote:
> > > you have to install RS on this second server... and you have to pay for the
> > > license...
> > > you can use the first server to host the RS database, but you have to go
> > > through the setup process for the new web server.
> >
> > > "Don" <D...@.discussions.microsoft.com> wrote in message
> > >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > > > Hello, I'm installing reporting services on a new sql server 2005 box.
> > > > While
> > > > on the machine, I go to Reporting Services Configuration Manager, I'm
> > > > trying
> > > > to create the report server virtual directory and report manager virtual
> > > > directory. My issue is that I don't want to create them on the sql box
> > > > but
> > > > on another web server. I don't get an option to tell it to create a New
> > > > folder on anywhere put the sql server.
> > > > How can you do this?
> >
> > > > Thanks
>
> The licensing scheme that Jeje mentioned is correct (reference:
> http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
> link should help in terms of the Configuration process.
> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||its a network and firewall issue.
you can install RS on the same box as SQL Server and open the HTTP door to
allow external users to access the server.
if you use ISA Server (or a firewall like this one) you can publish the
server easily on the internet.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:B83002C5-DD7C-4220-818B-C796C2683889@.microsoft.com...
> Thanks, so I have a sql server but I don't want to install the reporting
> services piece on the sql server (using the IIS installed on SQL box)
> because
> I want people outside of the network to see the reports using the report
> manager.
> I believe that if I have it installed on the sql server then only people
> in
> the office will be able to see it. So, sql server reporting servies is
> only
> really every included in your purchase of sql server if you want to only
> display the data with people logged onto your network?
> Thanks
> "EMartinez" wrote:
>> On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
>> > Are you sure that's how the licensing works? I thought you only had to
>> > pay
>> > for additional licenses if you were doing it in a farm, or if your
>> > database
>> > server was 1 cpu and the web server had 2 CPU.
>> >
>> > So, If I run the setup on the web server then when i go into Reporting
>> > Services Configuration Manager on the web server and select the
>> > database on
>> > the sql server? Or do you do the configuration manager from the sql
>> > server.
>> >
>> > Thanks
>> >
>> > "Jeje" wrote:
>> > > you have to install RS on this second server... and you have to pay
>> > > for the
>> > > license...
>> > > you can use the first server to host the RS database, but you have to
>> > > go
>> > > through the setup process for the new web server.
>> >
>> > > "Don" <D...@.discussions.microsoft.com> wrote in message
>> > >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
>> > > > Hello, I'm installing reporting services on a new sql server 2005
>> > > > box.
>> > > > While
>> > > > on the machine, I go to Reporting Services Configuration Manager,
>> > > > I'm
>> > > > trying
>> > > > to create the report server virtual directory and report manager
>> > > > virtual
>> > > > directory. My issue is that I don't want to create them on the sql
>> > > > box
>> > > > but
>> > > > on another web server. I don't get an option to tell it to create
>> > > > a New
>> > > > folder on anywhere put the sql server.
>> > > > How can you do this?
>> >
>> > > > Thanks
>>
>> The licensing scheme that Jeje mentioned is correct (reference:
>> http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
>> link should help in terms of the Configuration process.
>> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
>> Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>