Brandie Tarvin (9/11/2012)

---

Forgive me a moment, Eugene, while I poo-poo your...

SELECT

f1, CountOfQ6_BRANCH = SUM(CountOfQ6_BRANCH)

FROM (

SELECT format(WEEK_DATE, "YYYYMM") as f1, Count(Q6_BRANCH) AS CountOfQ6_BRANCH

FROM TBL_AML_ERRORS

GROUP BY format(WEEK_DATE, "YYYYMM")

UNION ALL -- the keyword ALL is important if you don't want to eliminate...

sqlnaive (9/11/2012)

---

I've a table with one column as varchar(50). This table is hugely populated. I want to alter this column to datatype float. While altering it gives me the following...

Using the sample data provided, a simple calculation rCTE works fine with both positive and negative numbers.

DECLARE @AmountToAllocate INT = 21

;WITH Calculator AS (

SELECT

BucketID, TotalSize, Amount,

AmountLeftToAllocate = CASE...

shani19831 (9/11/2012)

---

Eugene Elutin (9/11/2012)

---

One of the column you return in one of your "selects" (I think it's a first one

) is of smalldatetime data type (we don't know which column...

jadelola (9/10/2012)

---

Hi,

Below is my revised table. Customers 1 and 2 will have 0 left but customer 3 will have 23 left has could only buy 27 units from him. The...

dwilliscp (9/10/2012)

---

Alexander Suprun (9/7/2012)

---

dwilliscp (9/7/2012)

---

To write new data using three outer joins or to use one outer join, and get most of the data, then use three updates to load...

jared 11265 (9/7/2012)

---

ChrisM@Work (9/7/2012)

---

Yvan Bouchard (9/7/2012)

---

How about just keeping the front-end part of the Foxpro application and have all the data in SQL Server? Lose the Foxpro database part? This...

SELECT b.*

FROM #tblBlocks b

WHERE NOT EXISTS (

SELECT 1

FROM #tblBlocks bi

WHERE bi.BlockID = b.BlockID

AND bi.BaseStage = 1)

Yvan Bouchard (9/7/2012)

---

How about just keeping the front-end part of the Foxpro application and have all the data in SQL Server? Lose the Foxpro database part? This would require pointing...

dwilliscp (9/7/2012)

---

The problem with...

Get well soon, GGeezer.

KumarSQLDBA (9/7/2012)

---

Hi ,

getting error while running this statement to store YYYYMM eg.201209 in database int column todatyearmonth.

eg,

convert(varchar(4),year([getdate()])) + convert(varchar(4),month([getdate()]),105) as todayyearmonth

Please help me how to proceed..

error:

Msg 241, Level 16,...

CELKO (9/6/2012)

---

.. it doesn't mean that I don't know any basics of data modeling, RDBMS or Date fields [sic] in SQL. I believe this forum is not just for...

DELETE aa

FROM aa

INNER JOIN bb

ON bb.ID = aa.ID

SET IDENTITY_INSERT aa ON

INSERT INTO aa (Id,Policynumber,date)

SELECT Id,Policynumber,date

FROM bb

SET IDENTITY_INSERT aa OFF