Passing multivalue in stored procedures

Hi guys,

I'm new in SSRS, Im having problems passing multivalue in stored procedures. Can someone help. please.

Thanks in advance.

Hi,

What is the stored procedure expecting? More than one parameter? Or a list of values concatenated with strings?

-Jessica

|||

I want to pass multiple value in the event type. If i pass a single value, it would work but for multiple value it fails.

Here's my storedd procedure:

GO

SETANSI_NULLSON

GO

SETQUOTED_IDENTIFIERON

GO

CREATEPROCEDURE [dbo].[usp_retrieve_audit_data]

-- Add the parameters for the stored procedure here

@.start_date asDateTime=NULL,

@.end_date asDateTime=NULL,

@.event asvarchar(20)=NULL

AS

BEGIN

SETNOCOUNTON;

-- Insert statements for procedure here

SELECT audit_log_id, date_created, event_type, event_name, event_status,

row_affected, updated_by

FROM audit_log

WHERE(date_created >= @.start_date)AND(date_created <= @.end_date)AND

(event_type IN(@.event))

END

|||

someone gave me this answer last time... but i've modified the column size

create a table valued function..

CREATEFUNCTION [dbo].[multival_prm]

(@.list ntext,

@.delimiter nchar(1)= N',')

RETURNS @.tbl TABLE(listpos intIDENTITY(1, 1)NOTNULL,

strvarchar(64))AS

BEGIN

DECLARE @.pos int,

@.textpos int,

@.chunklen smallint,

@.tmpstr nvarchar(64),

@.leftover nvarchar(64),

@.tmpval nvarchar(64)

SET @.textpos = 1

SET @.leftover =''

WHILE @.textpos <=datalength(@.list)/ 2

BEGIN

SET @.chunklen = 64 -datalength(@.leftover)/ 2

SET @.tmpstr = @.leftover +substring(@.list, @.textpos, @.chunklen)

SET @.textpos = @.textpos + @.chunklen

SET @.pos =charindex(@.delimiter, @.tmpstr)

WHILE @.pos > 0

BEGIN

SET @.tmpval =ltrim(rtrim(left(@.tmpstr, @.pos - 1)))

INSERT @.tbl (str)VALUES(@.tmpval)

SET @.tmpstr =substring(@.tmpstr, @.pos + 1,len(@.tmpstr))

SET @.pos =charindex(@.delimiter, @.tmpstr)

END

SET @.leftover = @.tmpstr

END

INSERT @.tbl(str)VALUES(ltrim(rtrim(@.leftover)))

RETURN

END

from your stored proc,

SELECT audit_log_id, date_created, event_type, event_name, event_status,

row_affected, updated_by

FROM audit_log

WHERE(date_created >= @.start_date)AND(date_created <= @.end_date)AND

(event_type inner join multiprm_val(@.event , default))

HTH|||Thanks thanks. I'll try this approach. Then I'll post my solution if its successful.|||opss... i forgotten something... the inner join part..... gotta join both the fields together ....|||

I get this done by useing dynamic SQL. You will need to add an a parm directly to your report.

Here's what your procedure code would look like:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATEPROCEDURE [dbo].[usp_retrieve_audit_data]

@.start_date asDateTime=NULL,

@.end_date asDateTime=NULL,

@.event as varchar(20)=NULL

AS

BEGIN

SET NOCOUNT ON;

DECLARE @.sql varchar(8000), @.crlf char(2)

SELECT @.crlf =char(13)+char(10)

SELECT @.sql =

N'SELECT audit_log_id, date_created, event_type, event_name, event_status, '+ @.crlf

+'row_affected, updated_by'+ @.crlf

+'FROM audit_log'+ @.crlf

+'WHERE (date_created between '''+CONVERT(VARCHAR(30), @.start_date, 121)+''' AND '''+CONVERT(VARCHAR(30), @.end_date, 121)+''') AND'+ @.crlf

+'(event_type IN ('+ @.event +'))'+ @.crlf

EXEC(@.sql)

--PRINT @.sql

END

In you report add a parameter and call it @.Event_List of type string. Make it a multi select and add all of you default values. Wrap the values in single ticks ex. '1'

Hide the parm @.event and under "Default values" set it's "Non-queried" value to the following expression:

=JOIN(Parameters!Event_List, ",")

What is passed back in @.event will be a comma delimited list of values selected in @.Event_List and will look like '1','2','3'

This value is substituted in the dynamic sql above and your dataset will be for only the events selected by your user.

Passing in a default parameter date via a URL

Hi Guys,

What is the syntax for passing in a default parameter of current date via a URL.

cheers

If you don't want to have to deal with IFormatProvider and DateTimeStyles of DateTime.Parse() method, then you can simply use the "MM/dd/yyyy" format. For example:

string dateToConvert = "12/25/2006";
DateTime today = DateTime.Parse(dateToConvert);

So, in your url, simply do: myPage.aspx?date=12/25/2006

Then retrieve the query string (Request.QueryString["date"]), check to make sure it's not null and not empty, and then finally convert it using the above mentioned DateTime.Parse(...).|||

Thanks jcasp.

This isn't quite what I meant. I want the currentdate to be passed in which I do not know of beforehand. Usually in VB I use Now or Date what is the equivalent.

Cheers

|||

Hi,

you can use DateTime.Now in .NET.

Grz, Kris.

Passing DateTime Parameter to Subreport (Error)

Hi guys,

I have managed to pass a string parameter form the main report to the subreport with no problems, but when i try and use the same method to pass a datetime type, i am issued with the following error messase:

"[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘SubReportName’: The value provided for the report parameter 'MasterDate' is not valid for its type."

I cant see why it work for strings, but not for datetime. Any suggestions will be very much appreciated

Just to clarify, i am using the same dateTime type to define both main and sub report parameters|||Does anybody know why i am getting this error. Your help will be very much appreciated.|||Does anybody know why i am getting this error?

Passing C# Value to the ASP SQL Query

Hi Guys,

Im trying to pass a value from a C# page to the corresponding ASP page.

I want to use this value in my SQL Query on the asp page within a Details View.

Ive made the variable public in c# page.

And im trying to concatenate it to my sql query within the <asp: SqlDataSource.

Thanks.

Look at http://www.devx.com/webdev/Article/30811 (Passing Information Securely Between ASP and ASP.NET)From ASP to ASP.NET you could call MyAspNetPage.aspx?ID=1234 where 1234 is the id of the record to display.|||Im using these 2 lines of code in the C# Page to retrieve the UserId. UserNum ive made public.

Guid User = (Guid)Membership.GetUser().ProviderUserKey;

UserNum = User.ToString();

This is the select statement i want to use within the SQLDataSource.

SELECT * FROM [UserData] WHERE ([UserID] = @.UserNum)

@.UserNum i want to use as the parameter in the query.

I still cant get the value back into the @.UserNum of the query

|||Are you trying to pass information from an ASP.NET page to an ASP page?|||

No.

I retrieve the UserID in the Account.aspx.cs page (This is the C# Page)

I want to pass the retrieved value to the Account.aspx page because i need to use it in a query in a SQL Data Source.

I thought i could just call the variable like this @.UserNum withint the query.

But its not picking up the value from the C# page.

|||

Your question is now clear!

You need to populate the data control from within Account.aspx.cs. The SQL Data Source may get get some very quick results, but in the end end nothing beats regular coding.

|||

data control?

Im not sure what you mean?

|||I was using "Data Control" generically - I shoudl have said to populate the Details View - it shoudl be done entirely from code behind.|||

Oh ok.

I am using a query behind the details view to populate it.

But i need to retrieve the current logged in User-ID so that i can populate it correctly.

Thats is why i was using the c# page.

Is it possible to retrieve the current logged in User-ID within SQL?

|||

Assuming your back-end database is SQL Server, you can set up a stored procedure that takes the argument of the record id. To run it set up a command block and execute it.

Or you can just generate the SQL command dynamically as in http://www.dotnetjunkies.com/QuickStartv20/howto/doc/adoplus/GetDataFromDB.aspx

|||

We are using an MS SQL Server Database.

Is it possible to pass a value back from the C# page as a

<asp:Parameter> ?

|||Hi guys,

I still havent figured this out.

This is the code im using in the asp page.

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:ASPNETDB.MDFConnectionString %>"

SelectCommand="SELECT FirstName, SecondName, DeviceNum, MobileNum, Address, Town, City, Country FROM aspnet_AddInformation WHERE (UserId = @.UserNumVal)"UpdateCommand="UPDATE aspnet_AddInformation SET FirstName =, SecondName =, DeviceNum =, MobileNum =, Address =, Town =, City =, Country ="><SelectParameters><asp:ParameterName="UserNum"DefaultValue="<%= UserNumVal %>"/></SelectParameters></asp:SqlDataSource>

This is the code i use in the C# Page to retrieve the userId Number

publicString UserNum;protectedvoid Page_Load(object sender, System.EventArgs e)

{

Guid User = (Guid)Membership.GetUser().ProviderUserKey;

UserNum = User.ToString();

}

I want to use the value of UserNum within the query the SQL SelectCommand

I think i ahve to pass the value back as a parameter?

|||

We fixed the problem.

We needed to add the following line of code to the C# Page.

SqlDataSource1.SelectParameters.Add("userNum", userNum);

Thanks For all the help!

Passing an multi array to sql from java over jdbc

Hi Guys,

I am fairly new to PL and I am trying to solve this problem.

I need to pass a two dimensional array(A variable Name and Variable value) to a stored procedure in PL/SQL. I dont want to pass this data as a big string..I was hoping to passing it as an array because it would be easier to handle the data.

Basically I would be calling this procedure from a java program over JDBC.

My question is how do I create this...

Since I would be filling this from Java, it would be a parameter within the procedure something like

CREATE OR REPLACE PROCEDURE Test_Response ( pisa_response Varchar[][] )

Of course Varchar[][] is not supported by PL but just showed this to give more understanding of the problem

Any help on this would be really appreciated..

Thanks in advance..

Regards,
FreakieCheck the thread in the Java section of this "dbForums" for details.|||Hi Thanks 4 the reply...

From what I gathered.. I might need to send it as a string...but I do not want to do that...

I basically want to send it as an array of strings... I am not sure whether using ORacle.sql.array feature might help???

Regards,
Freakie|||Again, check the thread in the Java section of this forums. Its got
complete code to perform what your looking for, so long as your
running Oracle 9i.

pass variables to the sql

Hi guys,
I have a quick question .. every month we write lot of script to fix the data.. we use the same sql statements .. just the values are different..
from eg:
UPDATE PS_TEST_TBL
SET TESTFIELD1 = TEST1A
WHERE TESTFIELD2 = TEST2A
AND TESTFIELD3 = TEST3A
;
UPDATE PS_TEST_TBL
SET TESTFIELD1 = TEST1B
WHERE TESTFIELD2 = TEST2B
AND TESTFIELD3 = TEST3B
;
instead of writing multiple scripts can we put all the variables (in a file) and pass the file to the file with the sql..
is this possible.. we will save lot of time..

please advise.

Thanks,
SMYou can do this by saving all your update statments to .sql or .txt file.
so when ever u need to run the update just call the .sql or .txt file from Sql prompt

SQl>@.xx.sql or
SQl>@.c:\orawin\bin\aa.txt; Make sure you call the file from correct place.

If you want the values to be changed every time.U can do this as follws

UPDATE PS_TEST_TBL
SET TESTFIELD1 = &TEST1A
WHERE TESTFIELD2 = TEST2A
AND TESTFIELD3 = TEST3A; &TEST1A for numeric values and '&TEST1A' for char

So the system will prompt :Enter value for TEST1A

Originally posted by meelagupta
Hi guys,
I have a quick question .. every month we write lot of script to fix the data.. we use the same sql statements .. just the values are different..
from eg:
UPDATE PS_TEST_TBL
SET TESTFIELD1 = TEST1A
WHERE TESTFIELD2 = TEST2A
AND TESTFIELD3 = TEST3A
;
UPDATE PS_TEST_TBL
SET TESTFIELD1 = TEST1B
WHERE TESTFIELD2 = TEST2B
AND TESTFIELD3 = TEST3B
;
instead of writing multiple scripts can we put all the variables (in a file) and pass the file to the file with the sql..
is this possible.. we will save lot of time..

please advise.

Thanks,
SM|||Another way would be to create a stored procedure with the update statements, and pass the values in as parameters.

Pass data between two data flow tasks

Hi Guys,

I have yet another question. How can i pass data b/w 2 data flow tasks? I'm trying to get some data from one sql server and then I want to pass this whole bunch of data to another data flow task which is going to get some data from second sql server. I would probably combine them using union all and then save that as a transaction in a third sql server?

Information regarding how to pass the data with some detailed discussion would be fine with me.

thanks

Gemma

Would the Merge Join transformation work for you? You could just have two sources within a single DataFlow Task and then merge their outputs.|||

Hi karfast,

Thank you for your response. Yes you're right but how would i put a new column when i'm saving the data?

Gemma

|||

Add a derived column / lookup column / join column... It depends on what you want in the new column.

For example if you want to add a timestamp you could just throw in a current timestamp from a derived column. If you want to add in information based off of a key in your original data you would use a lookup transform and input the column based off of the foreign key. etc....

Hope this helps.

|||

Gemma wrote:

Hi Guys,

I have yet another question. How can i pass data b/w 2 data flow tasks?

Probably not relevant anymore but the answer to your original question is "Use raw files".

Raw file information

(http://blogs.conchango.com/tags/SSIS/raw+files/default.aspx)

-Jamie

PASS attendees ?

Any one of you guys flying into Orlando on Sunday especially with Jeanne in
town that day ? Do you think the MCO airport might be shut down ? Or are you
folks trying to leave early ? Im planning to arrive on Sunday and not too
sure if the airlines might even take off if the airport is closed down
there.. Any news ?
Ive got myself registered for the pre-conference on Monday and would not
like to miss it ..It's hard to say if it will be closed or not but I changed my ticket from
Sunday to Saturday and will have to leave a day earlier than planned. I
figured if it wasn't closed it was going to be a bumpy ride<g>.
Andrew J. Kelly SQL MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> Any one of you guys flying into Orlando on Sunday especially with Jeanne
in
> town that day ? Do you think the MCO airport might be shut down ? Or are
you
> folks trying to leave early ? Im planning to arrive on Sunday and not too
> sure if the airlines might even take off if the airport is closed down
> there.. Any news ?
> Ive got myself registered for the pre-conference on Monday and would not
> like to miss it ..
>
>|||Well all flights have been cancelled into Orlando beginning tomorrow...This
is sad.. Is PASS still on ? MCO is closed from tomorrow Saturday after
5pm...
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OBBSMRpoEHA.648@.tk2msftngp13.phx.gbl...
> It's hard to say if it will be closed or not but I changed my ticket from
> Sunday to Saturday and will have to leave a day earlier than planned. I
> figured if it wasn't closed it was going to be a bumpy ride<g>.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> > Any one of you guys flying into Orlando on Sunday especially with Jeanne
> in
> > town that day ? Do you think the MCO airport might be shut down ? Or are
> you
> > folks trying to leave early ? Im planning to arrive on Sunday and not
too
> > sure if the airlines might even take off if the airport is closed down
> > there.. Any news ?
> > Ive got myself registered for the pre-conference on Monday and would not
> > like to miss it ..
> >
> >
> >
>|||Where did you hear this? I just looked at Orlando Airports web site and
they state they have no plans to close MCO (Orlando International) due to
Jeanne. They have closed other airports in the area but not Orlando
according to their web site.
Andrew J. Kelly SQL MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O83EWupoEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Well all flights have been cancelled into Orlando beginning
tomorrow...This
> is sad.. Is PASS still on ? MCO is closed from tomorrow Saturday after
> 5pm...
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OBBSMRpoEHA.648@.tk2msftngp13.phx.gbl...
> > It's hard to say if it will be closed or not but I changed my ticket
from
> > Sunday to Saturday and will have to leave a day earlier than planned. I
> > figured if it wasn't closed it was going to be a bumpy ride<g>.
> >
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> > > Any one of you guys flying into Orlando on Sunday especially with
Jeanne
> > in
> > > town that day ? Do you think the MCO airport might be shut down ? Or
are
> > you
> > > folks trying to leave early ? Im planning to arrive on Sunday and not
> too
> > > sure if the airlines might even take off if the airport is closed down
> > > there.. Any news ?
> > > Ive got myself registered for the pre-conference on Monday and would
not
> > > like to miss it ..
> > >
> > >
> > >
> >
> >
>|||I called the number out there and also called Alaska airlines and they have
cancelled all flights up until Monday
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uMy$fbqoEHA.3728@.TK2MSFTNGP09.phx.gbl...
> Where did you hear this? I just looked at Orlando Airports web site and
> they state they have no plans to close MCO (Orlando International) due to
> Jeanne. They have closed other airports in the area but not Orlando
> according to their web site.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O83EWupoEHA.3324@.TK2MSFTNGP15.phx.gbl...
> > Well all flights have been cancelled into Orlando beginning
> tomorrow...This
> > is sad.. Is PASS still on ? MCO is closed from tomorrow Saturday after
> > 5pm...
> >
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > news:OBBSMRpoEHA.648@.tk2msftngp13.phx.gbl...
> > > It's hard to say if it will be closed or not but I changed my ticket
> from
> > > Sunday to Saturday and will have to leave a day earlier than planned.
I
> > > figured if it wasn't closed it was going to be a bumpy ride<g>.
> > >
> > >
> > > --
> > > Andrew J. Kelly SQL MVP
> > >
> > >
> > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> > > > Any one of you guys flying into Orlando on Sunday especially with
> Jeanne
> > > in
> > > > town that day ? Do you think the MCO airport might be shut down ? Or
> are
> > > you
> > > > folks trying to leave early ? Im planning to arrive on Sunday and
not
> > too
> > > > sure if the airlines might even take off if the airport is closed
down
> > > > there.. Any news ?
> > > > Ive got myself registered for the pre-conference on Monday and would
> not
> > > > like to miss it ..
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Just to clarify as of 10 PM PST, the airport has mentioned of a cutoff time
of 5pm ET on Saturday..Not exactly certain at this point. But infact the
airlines are beginning to cancel.. Atleast Alaska airlines which is the
airline i was supposed to be travelling has cancelled all flights from
Saturday up until Monday. So there goes day 1 of the pre-conference. I hope
i get a refund from PASS.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:Odw0LwroEHA.1988@.TK2MSFTNGP09.phx.gbl...
> I called the number out there and also called Alaska airlines and they
have
> cancelled all flights up until Monday
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uMy$fbqoEHA.3728@.TK2MSFTNGP09.phx.gbl...
> > Where did you hear this? I just looked at Orlando Airports web site and
> > they state they have no plans to close MCO (Orlando International) due
to
> > Jeanne. They have closed other airports in the area but not Orlando
> > according to their web site.
> >
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:O83EWupoEHA.3324@.TK2MSFTNGP15.phx.gbl...
> > > Well all flights have been cancelled into Orlando beginning
> > tomorrow...This
> > > is sad.. Is PASS still on ? MCO is closed from tomorrow Saturday
after
> > > 5pm...
> > >
> > >
> > > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > > news:OBBSMRpoEHA.648@.tk2msftngp13.phx.gbl...
> > > > It's hard to say if it will be closed or not but I changed my ticket
> > from
> > > > Sunday to Saturday and will have to leave a day earlier than
planned.
> I
> > > > figured if it wasn't closed it was going to be a bumpy ride<g>.
> > > >
> > > >
> > > > --
> > > > Andrew J. Kelly SQL MVP
> > > >
> > > >
> > > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > > news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> > > > > Any one of you guys flying into Orlando on Sunday especially with
> > Jeanne
> > > > in
> > > > > town that day ? Do you think the MCO airport might be shut down ?
Or
> > are
> > > > you
> > > > > folks trying to leave early ? Im planning to arrive on Sunday and
> not
> > > too
> > > > > sure if the airlines might even take off if the airport is closed
> down
> > > > > there.. Any news ?
> > > > > Ive got myself registered for the pre-conference on Monday and
would
> > not
> > > > > like to miss it ..
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

PASS attendees ?

Any one of you guys flying into Orlando on Sunday especially with Jeanne in
town that day ? Do you think the MCO airport might be shut down ? Or are you
folks trying to leave early ? Im planning to arrive on Sunday and not too
sure if the airlines might even take off if the airport is closed down
there.. Any news ?
Ive got myself registered for the pre-conference on Monday and would not
like to miss it ..
It's hard to say if it will be closed or not but I changed my ticket from
Sunday to Saturday and will have to leave a day earlier than planned. I
figured if it wasn't closed it was going to be a bumpy ride<g>.
Andrew J. Kelly SQL MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> Any one of you guys flying into Orlando on Sunday especially with Jeanne
in
> town that day ? Do you think the MCO airport might be shut down ? Or are
you
> folks trying to leave early ? Im planning to arrive on Sunday and not too
> sure if the airlines might even take off if the airport is closed down
> there.. Any news ?
> Ive got myself registered for the pre-conference on Monday and would not
> like to miss it ..
>
>
|||Well all flights have been cancelled into Orlando beginning tomorrow...This
is sad.. Is PASS still on ? MCO is closed from tomorrow Saturday after
5pm...
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OBBSMRpoEHA.648@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> It's hard to say if it will be closed or not but I changed my ticket from
> Sunday to Saturday and will have to leave a day earlier than planned. I
> figured if it wasn't closed it was going to be a bumpy ride<g>.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:e1NVTVooEHA.516@.TK2MSFTNGP09.phx.gbl...
> in
> you
too
>
|||Where did you hear this? I just looked at Orlando Airports web site and
they state they have no plans to close MCO (Orlando International) due to
Jeanne. They have closed other airports in the area but not Orlando
according to their web site.
Andrew J. Kelly SQL MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O83EWupoEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Well all flights have been cancelled into Orlando beginning
tomorrow...This[vbcol=seagreen]
> is sad.. Is PASS still on ? MCO is closed from tomorrow Saturday after
> 5pm...
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OBBSMRpoEHA.648@.tk2msftngp13.phx.gbl...
from[vbcol=seagreen]
Jeanne[vbcol=seagreen]
are[vbcol=seagreen]
> too
not
>
|||I called the number out there and also called Alaska airlines and they have
cancelled all flights up until Monday
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uMy$fbqoEHA.3728@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Where did you hear this? I just looked at Orlando Airports web site and
> they state they have no plans to close MCO (Orlando International) due to
> Jeanne. They have closed other airports in the area but not Orlando
> according to their web site.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O83EWupoEHA.3324@.TK2MSFTNGP15.phx.gbl...
> tomorrow...This
> from
I[vbcol=seagreen]
> Jeanne
> are
not[vbcol=seagreen]
down
> not
>
|||Just to clarify as of 10 PM PST, the airport has mentioned of a cutoff time
of 5pm ET on Saturday..Not exactly certain at this point. But infact the
airlines are beginning to cancel.. Atleast Alaska airlines which is the
airline i was supposed to be travelling has cancelled all flights from
Saturday up until Monday. So there goes day 1 of the pre-conference. I hope
i get a refund from PASS.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:Odw0LwroEHA.1988@.TK2MSFTNGP09.phx.gbl...
> I called the number out there and also called Alaska airlines and they
have[vbcol=seagreen]
> cancelled all flights up until Monday
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uMy$fbqoEHA.3728@.TK2MSFTNGP09.phx.gbl...
to[vbcol=seagreen]
after[vbcol=seagreen]
planned.[vbcol=seagreen]
> I
Or[vbcol=seagreen]
> not
> down
would
>

Partitionning a Table

Hi guys,

I am creating a program, and for that i implements function to partionate a Table (which are too big).
In Oracle it's simple :
ALTER TABLE myTable SPLIT PARTITION ....

But for MS Sql Server 2005, I encounter some problems.

Do you have an idea ?
How can i partitionate a Table without make TSQL Functions ?
Is it possible ?
how can I split Tables simply.

Thanks ;)

I don't think you can...

this article describes how to do it using a function:

http://msdn2.microsoft.com/en-us/library/ms186307.aspx

|||thanks ;)