473,587 Members | 2,527 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Convert Access to SQL Server

hariharanmca
1,977 Top Contributor
I am using IIF condition in MSAccess to split two kind of rows into column why it is not possible in SqlServer or how can i do.
Feb 9 '07 #1
4 1428
iburyak
1,017 Recognized Expert Top Contributor
IIF is a VBA function and just recognized by Access.

Use case instead.

[PHP]Case when condition then result1 else result2 end[/PHP]
Feb 9 '07 #2
dorinbogdan
839 Recognized Expert Contributor
In queries, I use SQL Case method as an equivalent to IIF:

Expand|Select|Wrap|Line Numbers
  1. Case When (anyFlag <> 0 ) Then  ... Else ...End
For more investigation, It may be helpful if include here some MSAccess sample.
Feb 9 '07 #3
hariharanmca
1,977 Top Contributor
In queries, I use SQL Case method as an equivalent to IIF:

Expand|Select|Wrap|Line Numbers
  1. Case When (anyFlag <> 0 ) Then  ... Else ...End
For more investigation, It may be helpful if include here some MSAccess sample.

Yes i already tryed that, but it wont run in Sql view
Feb 10 '07 #4
dorinbogdan
839 Recognized Expert Contributor
I know that a SQL View can contain Case statements.
For further investigation, it may be helpful if include here some of your MSAccess sample, and even the SQL View not working code.
Feb 12 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

12
8251
by: Guy | last post by:
I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS, to convert it on my own. I got a lot of forms and query to convert too. Can someday provide me with at least one tool name ? Thanks,
1
1584
by: Collegue | last post by:
Is it possibly to convert access database into other program like C++ or Delphy. Thanks
0
1046
by: Robert Scheer | last post by:
Hi. I have an .aspx page that refreshes itself from 30 to 30 seconds. The pages uses meta-tags in order to refresh. This page verifies some data on a table in my database, and if there is a certain info present, a sound is played using the bgsound tag. The page works ok, but if I minimize the page that sound won't play. Is it possible...
3
12928
by: Bill Nicholson | last post by:
What tools are available to convert Access projects (Forms, Code, Queries, Reports) to VB Dot Net? Does anyone have experience with this type of conversion? Please tell me I don't have to do it by hand! Thanks, Bill
8
7249
by: s_wadhwa | last post by:
SELECT DISTINCTROW "01C" AS dummy, Buildings.BuildingNumber, UCASE(Buildings.BuildingName) AS BuildingName, Buildings.MasterPlanCode, Buildings.UniformBuildingCode, Buildings.FunctionalCategoryCode, Buildings.OwnershipCode, Buildings.ConditionCode, Format$(,"0000000") AS dBasicGrossArea, Format$(,"0000000") AS dCoveredUnenclosedGrossArea,...
2
1663
by: keithgell | last post by:
I needed to import large CSV files into Access, when requested by a command in a .Net interface. Because Access does not have a bulk insert command, and I already have vba macros in Access that do the import, I simply called the vba macro from .Net using COM. Each time a csv file is successfully imported, I would like to raise a custom...
1
1186
by: ahpooh82 | last post by:
hi all, i having a problem to access server folder. i got one folder inside server, which i already shared. but when i access that folder fail. dim host as string = "\\serverId\folder\file.xml" doc.Load(host) ..... error :System.IO.IOException = {"Logon failure: unknown user name or bad password.
0
1078
by: nethajireddy | last post by:
hello Techies.. I already placed in this forum but I did not get exact solution for my problem, we are using windows 2000 server and configuration is P-III 500Mhz processors (2), 512MB RAM. when users try to access server some times they can not access or it's too slow, I checked in TCPview, there TIME_WAIT is keep on increasing...
1
2692
by: vinodkus | last post by:
dear sir/madam How to convert sql server data to ms access. Please help me Thanks in advance
0
1276
by: SteveBark | last post by:
Can anyone point me in the right direction as to what control structure I should put in place for the following requirement. I have an Access Server which I have 30 modems connected to. I need to utilise these modems to dial out and collect data from remote devices. The plan is to write a perl script that will process a list of devices to...
0
7920
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7849
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8347
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7973
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5718
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2358
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1454
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.