Forum Replies Created
Viewing 15 posts - 1,456 through 1,470 (of 5,109 total)
-
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table
What attempts have you made so far? Please do share your attempts. Could you post your data as something other than an excel spreadsheet please? DDL and DML statements for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Problem using expression in SSIS
mohanbabu.s - Sunday, November 11, 2018 8:43 AMPhil Parkin - Thursday, August 2, 2012 11:06 AMRE: question about Datetime conversion
The problem is you're declaring your variable as the wrong data type. A datetime should be stored as a datetime(2), not a varchar. When using CONVERT and supplying varchar as...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Send Email with ROW_COUNT value and file name
Jonathan AC Roberts - Friday, November 9, 2018 4:47 AMIf your in SSIS...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Subtracting in dynamic SQL
keneangbu - Thursday, November 8, 2018 9:08 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Subtracting in dynamic SQL
Also, be careful with syntax like CONVERT(varchar, @start_date). I doubt it'll be a problem with this specific scenario, but you should really be declaring your lengths for your...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
NineIron - Thursday, November 8, 2018 8:42 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Subtracting in dynamic SQL
keneangbu - Thursday, November 8, 2018 8:14 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
NineIron - Thursday, November 8, 2018 7:22 AM
And are the MRN and Name columns in the group in the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
NineIron - Thursday, November 8, 2018 7:13 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
Alternatively, you can just put the values in the high level of the group, like I have in this report:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
NineIron - Thursday, November 8, 2018 6:42 AMAccountNumber isn't a group, the combination of AccountNumber,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
NineIron - Thursday, November 8, 2018 6:07 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How to overcome missing 0x for varbinary?
So, you're saying that you have a varbinary value without 0x at the start? I didn't even think that was possible. As an example the following code doesn't work:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How can I prevent the added group items from repeating?
Merged cells? Very unclear what you're asking here, as the picture is of your Group properties, not the dataset.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukViewing 15 posts - 1,456 through 1,470 (of 5,109 total)