Welcome :Guest
 Sign In Register
Win Surprise Gifts!!!
Congratulations!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Sharad
Eminent IT
 Post New Web Links

## More Related Resource Links

### Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:ÃÂ ÃÂ CalculateÃÂ expected resolveÃÂ date exclude "Saturday" and "Sunday"ÃÂ ÃÂ based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode:ÃÂ Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1), ÃÂ  ÃÂ  IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) , ÃÂ  IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) , ÃÂ  IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

### Receive/Delete Multiple FTP Files based on condition using SCRIPT(VB) TASK

I am trying to receive and delete multiple FTP files from a remote FTP server using Script task Below is the code   Dim FTPConnMgr As ConnectionManager FTPConnMgr = Dts.Connections("FTP Connection Manager") Dim FTPClientConn As FtpClientConnection = New FtpClientConnection(FTPConnMgr.AcquireConnection(Nothing)) Dim FileTimeStampNew As String = "20100913021807" Dim remoteFileNames(0) As String remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "*" & FileTimeStampNew & ".*" 'Below hardcoded FileName works good. But the problem is there are lots of file in the FTP folder that I dont want to receive 'remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "Company_alpha_Full_20100913021807.xml" Dim localPath As String = Dts.Variables("FtpLocalDirectory").Value FTPClientConn.Connect() FTPClientConn.ReceiveFiles(remoteFileNames, localPath, False, False) FTPClientConn.Close() Dts.TaskResult = ScriptResults.Success End Sub End Class If i specifically mention the RemotefileNames this works fine but, when I say *.* it executes succefully but doesn't receives the file. Please advice how to receive multiple file based on a variable BR, AWM

### multiple executions of MERGE statement: Help with suitable TRANSACTION ISOLATION LEVEL

Folks, I am reasonably new to SQL Server. I am using SQL Server 2008 (no SP) on Windows XP. I am using the MERGE statement within a TSQL procedure to update a master/detail table pair (Master/Child), in which the MERGE inserts into the MASTER if a record based on the primary key doesn't exist and does, effectively nothing, if it does (well, it does an UPDATE set PK=PK so the record is passed on to the OUTPUT statement for insertion into the CHILD). Regardless as to the situation, the CHILD record has a record created when the MASTER exists or doesn't exist. Now, this code works fine with the standard TRANSACTION LEVELS. But I don't know what to do when I am running two instances of the same MERGE statement at the same time. One execution could create a record in the MASTER which the other process might try and create 5 minutes later. I really don't know what SET TRANSACTION ISOLATION LEVEL to use to allow both processes to run at the same time. I have looked at: ALTER DATABASE \$(usedbname) SET READ_COMMITTED_SNAPSHOT ON; ALTER DATABASE \$(usedbname) SET ALLOW_SNAPSHOT_ISOLATION ON; But these don't seem to work with their associated TSQL calls. I know this is a complex issue, but as a new SQL Server user, I didn't know where else to go. regards Simon

### Update Statement help from Multiple database

Hi I am having two separate datbase on same sever one datasbase name private from where i am executing my below query and other name is ODS Table name in Private=[A].[DimCapabilitySpecialty] Table name in ODS = [A].[CapabilitySpecialty]   both of them having column SpecialtyCd   i want to update the flag value of ODS table where there is particular specialitycd missing in source means table in private database   so for that i wrote below query   update A.DimCapabilitySpecialty set ActiveInd ='I' where SpecialtyCd !=[ODS].[A].[CapabilitySpecialty].[SpecialtyCd]   But it is giving me this error   Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "ODS.CapabilitySpecialty.SpecialtyCd" could not be bound.

### It is possible to alter multiple columns within a single alter table statement?

It is possible to alter multiple columns within a single alter table statement?

I tried & searched not getting it.

```Alter table au_de alter column m_user char(9),c_user char(9)

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ','.

```

```Alter table au_de alter column m_user char(9),alter column c_user char(9)
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.
```

### Need help with SELECT statement for multiple tables

Here's my current SELECT statement:

SELECT u.Email FROM UserProfiles p, aspnet_Membership u WHERE p.RulesCheckBox = 'True' AND u.UserId = p.UserId

This gives me a list of registered member email addresses that have selected the RulesCheckBox in their profile, so I can email them with an email script.  There is a relationship between the Membership table and the UserProfile table, so it finds the email addresses from the Membership table where that user has the RulesCheckBox checked in their profile (in UserProfiles table).  I'm wanting to add some additional names to this list, from a different table. The purpose is so I can manually add email addresses to the additional table, so the additional email addresses will also receive the same email, even though they aren't registered members of the site.

So how can I adjust that SELECT statement so this one is combined with it somehow?:

SELECT Email FROM ExtraEmails WHERE Rules = 'true'

### Insert multiple rows with a single INSERT statement

With SQL Server 2005 Express coming out, I have switched from MySql.ÃÂ  I'm having trouble with a very simple INSERT statement that has previously worked in both MySql and Oracle.ÃÂ  The statement is as follows:

INSERT INTO pantscolor_t (procode,color,pic) VALUES
ÃÂ ('74251', 'Black', '511black.jpg'),
ÃÂ ('74251', 'Charcoal', '511charcoal.jpg'),
ÃÂ ('74251', 'Khaki', '511khaki.jpg'),
ÃÂ ('74251', 'Navy', '511navy.jpg'),
ÃÂ ('74251', 'OD Green', '511odgreen.jpg');

However, when I attempt to execute this statement with Management Studio Express I get the following error:

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ','.

Any ideas?

### How to check for space in a password regex having multiple condition

Hi
I have a requirment where in the password field should accept all keys except space, it should have atleast one number , length should be 6 to 50
I tried following but did not work
1) Regex = @"^.*(?=.{6,50})(?=.*\d)(?=.*[a-zA-Z]).*\$"

2) ^(?=[^\s])(?=[^\s]{6,50})(?=[^\s]*\d)(?=[^\s]*[a-zA-Z]).*\$

Following are my test input text ( test case no 2 is having space at end)

ÃÂ ShouldNOT654321-1
ShouldNOT654321-2
Should654321-3
ShouldNOT 654321-4
Should NOT654321-5
S houldNOT654321-6
ShouldNOT65432 1-7
S houldNOT 654321-9
Should654321
1Should654321

Please help.

Thanks in Advance.
Rajendra Dewani

Regards Rajendra Dewani

### sql case statement with two condition

Hi

declare @year int,@month int

@year=2008

@month=1
while (@month <=13 and @year<=year(getdate()))
begin

SET @month=@month+1
SET @year=case @month when 13 then @year +1
ans @month =1 else @year end
SET @year=@year+1
end

in this case statemtent i also want that when year increase means when increment of year happens then month variable shouls chage oe reset to 1 so that loop can start from 1 month of new year..

but i get error in this case statement when i use and @month =1

please help me and provide needful step

### reading Multiple queries in If condition

I have search input on my web page txtSearch.text(Column name is JobNO ,this column present in all the 3 tables), when i submit a value click on search button it has to read 3 tables.is it appropriate writing 3 queries in if condition..something like follows but not sure of it

if  txtSearch.text<>"" then
Query=select * from ship
elseif txtSearch.text<>"" then
Query=select * from openorder
else
Query=select * from schedule
end if

when i give above input it should read 3 tables and write the value on grid view,i am held up here and thankful to you can any one provide the possible solution

### SQL Statement that returns result set based Max or Min Condition

I would like to return a result set that has mutliple rows containing Date and Time stamps and a value but I only want the record set returned if one of the records has a Minimum value in it of 50.  How would this be constructed so all the rows are returned and not just the Value=50 row?  I know GroupBy is probably used but am a sql novice.

Thanks!

### multiple join in one statement

1. select -----

from table1 t1 join table2 t2 on t1.a=t2.a

left join table3 t3 on t1.a=t3.b

2. select -----

from table1 t1 join table2 t2 on t1.a=t2.a

left join table3 t3 on t2.a=t3.b

I'm not sure about the behavior of above 2 statements. What kind of result do i expect?

When should i use both kind of joins?

### Writing multiple if statement in where clause in Stored Procedure

Hi,

I have one Stored Procedure which returns some value. now i have some different conditions in my select query so can i write them in my where clause instead of writing the whole select query again for different conditions?

Like

My Current Select Statement in SP looks like :

Select

FName,LName,UniqueRef,City

From

tblContact

Where

UniqueRef='@UniqueRef'

Now i have two more conditions in my Select Statement that are

@ProductList varchar(max),

@StatusList Varchar(max)

and they gets the list of id of their name from another function that is made for them respectively fun_GetProductId and fun_GetStatusId

so with this my Select Statement in SP will look like

Select

FName,LName,UniqueRef,City

From

tblContact

Where

(UniqueRef='@UniqueRef' or @UniqueRef='') and

(Productid in (Select * From fun_GetProductId(@ProductList))) and

(StatusId in (Select * From fun_GetStatusId(@StatusList)))

### Selecting data from multiple tables whilst using a union statement.

Hi,

any help on this would be great.

I basically have a series of tables from one database that have an identical structure thus making retrieval of all records fairly easy (I just use a UNION ALL statement). However I need a list of values from another table within a different  database that contains information regarding the group of the data.

I so far have the following:

SELECT Table1.* FROM Table1 UNION ALL SELECT Table2.* FROM Table2 UNION ALL SELECT Table3.* FROM Table3 UNION SELECT Database.dbo.SRFILE.SR_GROUP FROM Database.dbo.SRFILE INNER JOIN Database.dbo.SRFILE.SRONUMBER = Table1.Incidentx

I keep receiving a unable to parse message however all I need to retreive is the SR_GROUP value but just don't know the correct syntax. Is it actually possible to do this as the structure of SRFILE is not the same as Table1/2/3.

Thanks again,

Jas

### How to find the statement which causes a 'FailedOperationException' when multiple commands are exe

When executing a large .sql file contents, which creates a lot of objects on a database, running the ExecuteNonQuery over a Database object, we're getting a FailedOperationException. Is there a way to find which of the SQL statements passed in the string is causing the exception, and have some more 'familiar' error message?

Are there other options to run the multiple T-SQL statements created with the SQL Server Management Studio database script generation feature?

We are using the SMO on a .NET Fx 3.5 app running against a SQL Server 2008 instance on a 32 bits computer.

Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt

### How do I handle IsSelected Condition in multiple DataTriggers case ?

Hi all,

I have a customize listBox in which I am defining a DatatTemplete for that ListBox, the code is something like:

```<ListBox Name="lstOfImages"
Background="Red" >

<ListBox.ItemTemplate>

<DataTemplate>

<Grid x:Name="mainGrid">

<Grid.ColumnDefinitions>
<ColumnDefinition Width="38"/>
<ColumnDefinition Width="*"/>
</Grid.ColumnDefinitions>

<Image x:Name="FirstCulomnPanel"
Grid.Column="0"
Height="40"
Width="38"
Source="ImagePath"
Visibility="Visible"
SnapsToDevicePixels="True"/>

<Border x:Name="SecondCulomnPanel"
Height="200"
Width="300"
HorizontalAlignment="Center"
Background="White"
VerticalAlignment="Center"
Grid.Row="0"
Grid.Column="1"
SnapsToDevicePixels="True"
```

### Multiple calculations in a single Statement in SQL Ce

Hi guys

I have a table that has a date, amount of litres, price per litre. The table is updated every month, what I have been trying to do is display the total revenue for each year ( amount of litres * price per litre this will give me the revenue for each month and then add each month together to return that years revenue) I can't seem to get this statement right, any tips?

Thanks

Paul

 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All