Viewing 15 posts - 8,341 through 8,355 (of 13,876 total)
rajeshjaiswalraj (6/18/2015)
Thanks for the reply....But how to run this from SSMS
Have you tried selecting Query / Results To File?
June 18, 2015 at 1:55 am
Douglas Osborne-229812 (6/17/2015)
Phil,Are you referring to a task like the one described here?
http://stackoverflow.com/questions/19521920/ssis-data-transformation-rows-to-COLUMNS
Thanks for the assist,
Doug
Not quite – that one is synchronous. I've looked for a decent example and cannot...
June 17, 2015 at 11:23 am
It doesn't seem to work like that.
The release seems to lag behind everything else by (quite) a few months. When it is released, it is released as a standalone module/package...
June 17, 2015 at 9:00 am
You mean for SSIS etc?
They're usually quite a long way behind. You may find this[/url] page of interest.
June 17, 2015 at 8:42 am
Douglas Osborne-229812 (6/16/2015)
Column1 100 Main Street
Column2 Appt #1
Column3 Havertown
Column4 PA
Column5 19083
Column5 0121
Column6 USA
Column7 S
Column1 200 Main...
June 17, 2015 at 1:25 am
Simple enough: in table A, you have a row containing CheckValue = 60 which matches three rows in table B, hence three results.
June 17, 2015 at 1:20 am
DSNOSPAM (6/16/2015)
June 16, 2015 at 11:36 am
Your function should be schema-qualified too.
And prefixing it with sp is very confusing!
June 16, 2015 at 11:06 am
DSNOSPAM (6/16/2015)
alter FUNCTION spGet_Rec_Count
(
@source_tbl varchar(100)
)
RETURNS bigint
AS
BEGIN
-- Declare the return variable here
DECLARE...
June 16, 2015 at 11:05 am
I want to access each row of inserted values like row by row
This will be ringing alarm bells among seasoned users of the site, who will be wondering why you...
June 16, 2015 at 7:56 am
Don't use nvarchar. Use nvarchar(size).
June 12, 2015 at 7:58 am
DanMcClain (6/12/2015)
June 12, 2015 at 7:13 am
Paul Sims-405749 (6/11/2015)
June 12, 2015 at 5:20 am
vipin_jha123 (6/12/2015)
What if out form both statement comes from 2 different table.Regards,
Vipin jha
JOIN the tables.
June 12, 2015 at 2:24 am
vipin_jha123 (6/12/2015)
Hi,I want to get output of below query in single row.
Select 'Name'
Select 'Surname'
Expected output is Name,Surname
Regards,
Vipin Jha
Continuing with your theme of minimal information:
Select Name, Surname
June 12, 2015 at 12:37 am
Viewing 15 posts - 8,341 through 8,355 (of 13,876 total)