Something like this should work.

DECLARE @date DATETIME

SET @date = GETDATE()

SELECT @date

SELECT DATEADD(dd, DATEDIFF(dd, 0, DATEADD(DD, 1 - DAY(@date), @date)), 0)

What your desired output is for any date given, give the first day of the month @ midnight, correct?

To get rid of the extra work of the case and sum, another option:

SELECT COUNT(Student_ID)

, Grade_Description

FROM Student s

...

DECLARE @test-2 INT, @divisor INT

SET @divisor = 3

SET @test-2 = 6

SELECT @test-2 / @divisor AS '6'

SET @test-2 = 5

SELECT

1. SET @ColName=" Function which will return the Column name"

2. Select @Result='Select ' + @Colname + ' from <my Table>'

I am only extending the result set to match what the op requested...

DECLARE @Today DATETIME

, @nMonths TINYINT

SET @Today = GETDATE()

SET @nMonths = 12

SELECT MonthEndDate = DATEADD(dd, -1,...

similar result, with out the replace function

DECLARE @text VARCHAR(250)

SET @text = 'Login succeeded for user ''domain\user''. Connection made using Windows authentication. [CLIENT: xxx.xxx.xxx.xxx]'

SELECT SUBSTRING(@text, CHARINDEX('''', @text) + 1, CHARINDEX('''', @text,...

Craig Farrell (11/9/2010)

---

Since we can't see the table on the left, or the results on your right, in the textboook, you need to screen shot the page, post it somewhere...

Please present some data so that a tested solution can be presented.

I'll even help (again) get you started.

SELECT '12-15 Hardley Street'

UNION ALL

SELECT '2A-C Hardley Street'

UNION ALL

SELECT...

I am not sure what in the requirements have changed. Can you please provide data in a consumable format, and the desired output for that data.

Also, you state SSIS...

cmrhema (10/19/2010)

---

Hi,

I have a column named Address in a table.

I have values such as

12-15 Hardley Street

2A-C Hardley Street

A-2c Hardley Street

A-B Hardley Street

I am required to keep the hyphen(-) intact in...

Tools -> Options

Text Editor

-> Editior Tab and Status Bar

-->Tab Text

----> Include DatabaseName False

----> Include FileName True

----> Include Login Name False

----> Include Server Name True

Or, whatever options you want. I...

sharonmtowler (10/4/2010)

---

the values are integers

i tried this

cast(( dbo.INVHDRPF.ININVY * 10000) + (dbo.INVHDRPF.ININVM* 100) + dbo.INVHDRPF.ININVY as datetime)

these were my results

YEAR MONTH DAY...

There may be other ways, but here is one way:

DECLARE @m INT

DECLARE @d INT

DECLARE @y INT

SET @y = 2010

SET @d = 4

SET @m = 10

SELECT CAST(CAST(@y...

Oh wow- this is 4 years old...I do not remember what was the issue. As a point of interest, some time after this post, I converted all backups to...