No announcements
Found 2802069 threads
-
2 VotesSQL to return the name of a month
Assuming DATETIMECOL may include days other than the first of the month, you can return a distinct list of the first date of each month ...Answered | 8 Replies | 4307 Views | Created by DeveloperNoobie - Monday, October 4, 2010 11:05 AM | Last reply by Atif-ullah Sheikh - Tuesday, October 5, 2010 4:36 AM
-
1 Votes
where statement on two different tables with same column name
I'd currently go with Kalman's answer ThanksAnswered | 7 Replies | 940 Views | Created by ITForums - Wednesday, July 30, 2014 8:49 PM | Last reply by Simon Hughes UK - Friday, August 1, 2014 10:22 AM -
1 Votes
Return Column Names Where Values Match
1)' Exec sp_executesql @SQL Select Stuff((Select ', ' + cols From #ListOfColumns For XML Path(''),Type) .value('text()[1]','nvarchar(max)'), 1,2, ...Answered | 10 Replies | 1117 Views | Created by 2012S4 - Wednesday, August 31, 2016 3:40 AM | Last reply by Tom Cooper - Thursday, September 1, 2016 2:17 AM -
0 Votes
get column name of selected cell
'column ...Answered | 2 Replies | 19733 Views | Created by cliftonmenig - Wednesday, November 17, 2010 11:55 PM | Last reply by .paul. _ - Thursday, November 18, 2010 12:46 AM -
0 Votes
Wildcard to Select Column Name using a parameter
Can you please post your TSQL query and some sample data?Answered | 3 Replies | 3347 Views | Created by daponc - Thursday, August 8, 2013 6:44 PM | Last reply by ironryan77 - Friday, August 9, 2013 3:18 PM -
0 Votes
Expression based Column Name in CSV
(This from a standards perspective is wrong) If so, can we get a "rendered display name" property that will allows SSRS developers have more control on the rendered ...Answered | 2 Replies | 6147 Views | Created by bsmitha - Tuesday, November 17, 2009 9:03 AM | Last reply by Joe_Cline - Monday, March 19, 2012 7:19 PM -
1 Votes
modify the returned column names?
[Month].Answered | 4 Replies | 3023 Views | Created by Andrew Goodnight - Friday, January 20, 2012 6:33 AM | Last reply by Darren Gosbell - Monday, January 23, 2012 8:26 AM -
0 Votes
Using a named column in a where clause
Use Derived table select * from ( select CONVERT(DATETIME, DATECOL, ...Answered | 2 Replies | 4361 Views | Created by DeveloperNoobie - Tuesday, August 24, 2010 7:54 AM | Last reply by Madhivanan - Tuesday, August 24, 2010 8:22 AM -
0 Votes
Select, where column = alias
Good answer: Please learn ISO-11179 standard rules for data element names.Answered | 5 Replies | 1136 Views | Created by XesChild - Tuesday, May 20, 2014 10:35 AM | Last reply by KEAARPEE - Tuesday, May 20, 2014 10:07 PM -
0 Votes
Showing a date as a month name
so, ok, you get the month number.Answered | 3 Replies | 4526 Views | Created by Boomscooter - Thursday, April 16, 2015 10:28 PM | Last reply by Bruce Hulsey - Friday, April 17, 2015 10:20 PM -
1 Votes
order by month and should not repeat the month name
; BY MONTH ( pr.daterequested ) Column "dbo.purchaserequest.DateRequested" is invalid in the ORDER BY clause because it is not ...Answered | 6 Replies | 1297 Views | Created by coolguy123SQL - Tuesday, June 18, 2013 2:53 PM | Last reply by coolguy123SQL - Tuesday, June 18, 2013 4:03 PM -
0 Votes
Dynamic column names
You can't have "dynamic" column names in the data flow - but you can request dynamic columns from your source, as long as when they get passed to ...Answered | 7 Replies | 3830 Views | Created by Jamal112 - Thursday, January 14, 2010 4:08 PM | Last reply by Nik - Shahriar Nikkhah - Thursday, January 14, 2010 5:53 PM -
0 Votes
How to find the table name and column name associated with the data enter by user
Replace your table name in YourTableName value and your Column name in YourColumnName Value Declare @tableName as sysname = ...Answered | 2 Replies | 1938 Views | Created by Pankaj067 - Friday, November 9, 2012 2:07 AM | Last reply by ganeshkuppuswamy - Friday, November 9, 2012 4:37 AM -
0 Votes
Cannot Sort the Name of the Month in ssrs Report
Amit, try the following: in the data set where you get the date, add another field (in the SQL) where you make the Year(date) + Month(date).Answered | 7 Replies | 5322 Views | Created by Amit Srivastava - Tuesday, July 21, 2009 7:46 AM | Last reply by JTeixeira_PT - Wednesday, July 22, 2009 9:52 AM -
0 Votes
Open Report to Current months' Data?
Hey All, So I have a report that has a rolling 12 months worth of data.Answered | 1 Replies | 392 Views | Created by LamdaLamda - Friday, July 15, 2016 4:03 AM | Last reply by Edward8520 - Monday, July 18, 2016 11:38 AM -
2 Votes
How to get fiscal Month Name in SSIS
In this approach you will have to see the issue for the column where month + 3 will be above 12.Answered | 20 Replies | 10098 Views | Created by MustafaH - Friday, November 20, 2009 2:01 PM | Last reply by Sudeep Raj - Friday, November 20, 2009 4:10 PM -
0 Votes
Getting name of month in a certain language
The database tier handles all of the database retrieval and data integrity.Answered | 3 Replies | 1062 Views | Created by Pedro Samuel - Tuesday, November 10, 2015 11:45 PM | Last reply by --CELKO-- - Wednesday, November 11, 2015 4:14 PM -
0 Votes
Dynamic filed name in the Where clause
You should have a column to store the month and another column to store the payment for the customer.Answered | 7 Replies | 2289 Views | Created by Rajeeshun - Monday, August 13, 2012 4:05 PM | Last reply by Rajeeshun - Thursday, August 16, 2012 1:11 PM -
3 Votes
Exporting data to a csv file and include column names
Checking "Column names in the first data row" does not work.Answered | 39 Replies | 26475 Views | Created by John Conklin - Tuesday, July 12, 2011 4:27 PM | Last reply by WBeatty - Monday, January 27, 2014 7:15 PM -
0 Votes
Display the month name in expression
Hi, try this, = MonthName(Month(Parameters!Answered | 1 Replies | 4613 Views | Created by AmarReddy23 - Wednesday, December 22, 2010 7:20 PM | Last reply by gk1393 - Wednesday, December 22, 2010 8:05 PM
No announcements
