Viewing 15 posts - 3,226 through 3,240 (of 3,475 total)
Open the report in design view.
Right-click a column, show properties.
Click on the Visibility tab.
When the report is initially run HIDE
Display can be toggled by this report item (choose a textbox)....
December 2, 2013 at 8:39 pm
While you could certainly do it that way, I absolutely would not. If you concatenate everything and dump it into a new column or create a calculated column, you're...
December 2, 2013 at 4:01 pm
Why do you need to create a table in SQL Server at all for this? You can base your report on a stored procedure and you're off to the...
December 2, 2013 at 3:23 pm
Brad,
Welcome to SSC... consider yourself schooled. (I'm still there, and I've been here for a while!)
Looks like you're a recovering Access/VB(A) programmer. Definitely true what Jeff said. ...
December 1, 2013 at 8:06 pm
One way to do what you want is to attempt the insert inside a TRY/CATCH block, and then use an OUTPUT parameter to return the error number to it when...
December 1, 2013 at 2:07 pm
BETWEEN 2013-11-26 13:49:00 AND 2013-11-26 13:49:59?
November 26, 2013 at 5:14 pm
https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Happy reading!
November 25, 2013 at 11:50 pm
You mean something like this?:
SELECT UniqueNum
,Somenum
, CHAR(ROW_NUMBER() OVER (PARTITION BY SomeNum ORDER BY UniqueNum ASC)+64) AS LetterSuffix
FROM #temp_Alpha_num
ORDER BY uniquenum,Somenum ASC;
so that when you get 121A to 121F and then...
November 25, 2013 at 5:19 pm
And if you want a pretty good introduction to backup and restore, look on YouTube for ScaryDBA - Grant Fritchey has a video on doing just backups (differential, full, TLog)...
November 23, 2013 at 10:16 pm
You can attach to lower versions, but not higher ones.
November 22, 2013 at 8:56 pm
What is your compatibility level set to on the database?
To figure it out, right-click the database, go to Properties and then Options. I would bet that it's set to...
November 22, 2013 at 2:30 pm
If you absolutely have to get the disk space free, then you can use SHRINKDATABASE or SHRINKFILE, but it does awful things to your databases. You have to reindex...
November 21, 2013 at 8:25 pm
Uncharted territory... so here goes... I attached the RDL as a TXT file. (So just change the extension back to RDL and you should be able to import it...
November 20, 2013 at 2:23 am
See if Grant Fritchey has anything posted about it on YouTube. he might, since he works for them.
November 19, 2013 at 9:13 pm
Gotta get out my book to be sure...
"Execution Context"
... an execution context can be specified for code. Specifying an execution context enables code to be run under a specific...
November 19, 2013 at 9:09 pm
Viewing 15 posts - 3,226 through 3,240 (of 3,475 total)