January 17, 2012 at 1:18 pm
rbond 51820 (1/17/2012)
Sometimes I just don't know enough to ask all the right questions......
Asking the right question is really tough, especially when it is new. There are lots of people that have been around this stuff for years that still can't ask the right questions. Don't worry, as you said, MOST of the people around here are friendly and helpful. But don't be surprised if your initial question just raises a lot of questions. As you gain some more knowledge you will start to anticipate those questions and soon you will be the one answering other people.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 17, 2012 at 6:00 pm
Interesting that the syntax is different for concatenation than in tsql.
In SSRS you'd use VBA, so the concatenate syntax should be =Fields!FieldName.Value & " " & Fields!OtherFieldName.Value. Weird.
Can't spell SSRS. Lol.
January 21, 2012 at 3:57 pm
Forgive me, I know there are technical definitions which relate to set theory, but in laymens terrms, here are the distictions between a few key concepts
Column: Represents everything in on vertical unit of your result set. If it were an excel spread sheet, "A" would be a column, and contain all the values in that colum
Row: Represents everything in a horizontal unit of your result set. If it were an excel spread sheet, 1, 2, 3, etc would be rows. A row will contain one instance of every column i.e. field values)
Field: A field technically refers to the intersection of a row and a column. If it were an excel spreadsheet, an example of a field would be A2, B10, ZZ101. A field contains a single data value.
As a side note, while this is not technically correct, may web developers or others not used to database terminology confuse the terms Field and Column. Sometimes contextually you can tell which is which, but in those cases, it would behoove you to ask of them "did you mean a column? As in everything under the title (for example) EmployeeID, or are you talking about a specific field relating to a signle employeeID?)
January 26, 2012 at 2:21 pm
...but the || does work....
Are you sure you're using SQL Server?
Edit: DOH! Really should learn to read the rest of the posts before I post annoying redundancy.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply