by: AJ |
last post by:
I'm writing my own little shopping cart system and am having a slight
problem at the final hurdle.
Visitor hits the site and once they add to their cart a row is created
in a table with the...
|
by: Mike R |
last post by:
Hi,
I cant figure out how to do this....
for example:
Select name from mytab order by col1
could return
Mike
|
by: throat.wobbler.mangrove |
last post by:
Hi,
I was hoping someone may be able to help me with a tricky T-SQL
problem.
I need to come up with a SELECT statement that does basically the
following:
Select RCRD_REFNO, MAX(MODIF_DTTM)...
|
by: Sebastien |
last post by:
I have the following statement which I run successfully in... 1 hour 10
minutes.
SELECT
a.tsgicd as ACCT_ID,
a.tsa5cd as SEC_ID,
CASE
WHEN (SUBSTRING(a.tsgicd, 6, 1) = 'R'
or...
|
by: rpuertas |
last post by:
Hello,
Visual Web Developer 2005 Express Edition and SQL Server 2005 Express: I
want to run a paged query within a TableAdapter. In the TableAdapter Query
Configuration Wizard" I write the next...
|
by: sunny |
last post by:
Hi,
I have the following data in my DB2 table ("Employee") :
EMPID MONTH SALARY
E340 JAN 3000
E340 FEB 2000
E340 ...
|
by: umeshpotdar |
last post by:
i want distinct rows from the table
i want to use "Row_Number" function with this
so
how can i use "Row_Number" function when distinct keyword is used
so i get the distinct rows as well as Row...
|
by: cberthu |
last post by:
Hi all,
I have written a nice application which is working nicely on a DB2
V9.1 LUW with the olap row_number, so far so good but now I have to
let this run on a mainframe (z/os) DB2 ver 8... and...
|
by: karpalmera |
last post by:
Hello! I am using UDB 8 in Z/OS and I am trying to execute this statement in SPUFI
select dept, name, row_number() over()
from staff
It just doesn't work. Here is the error message:...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|