Ubuntu

Technical Article

Update Using A Subqury

  • Topic

Can anyone think of a way to update one column when a subquery returns two values? Here is my SQL...UPDATE tmp_ar_exception SET count_fact = ( SELECT DISTINCT COUNT(F_AR_Detail.date_id) AS Expr1 FROM         tmp_ar_exception LEFT OUTER JOIN                       F_AR_Detail ON tmp_ar_exception.dt_id = F_AR_Detail.date_id GROUP BY F_AR_Detail.date_id )

You rated this post out of 5. Change rating

2005-04-28

1 reads

Technical Article

RE: Hexidecimal to Decimal

  • Reply

There might be a cleaner way to do this -- I just kind of dashed it off -- and I apologize for the bad variable names, but I'm too lazy to change them now ... But here's one way w/ no dynamic SQL: declare @x varchar(20) set @x = '0xFFFA01' set @x = right(@x, len(@x) […]

You rated this post out of 5. Change rating

2005-04-20

Technical Article

Can SQL Server 2000 STANDARD access more than 2GB?

  • Topic

I know that SQL Server Enterprise Edition can use more than 2 GB of memory using the AWE support. However, if a server has more than 2 GB and SQL Server Standard is instaled, is there any way that SQL Server will use more than 2GB? I think not, but if anyone knows otherwise, please […]

2005-01-19

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers