Viewing 15 posts - 2,356 through 2,370 (of 2,648 total)
select *
from @table
pivot
(
min(comment)
FOR comment_id IN ([1],[2],[3],[4],[5])
) AS PivotTable;
July 30, 2018 at 6:29 am
Thanks for the reply.
I understood the answers that were mentioned that I thank you...
July 29, 2018 at 7:46 pm
A few years ago someone was moving a database (without doing a backup first) and when they reconnected somehow the log file was elsewhere. This corrupted the mdf file.
To...
July 29, 2018 at 10:20 am
July 27, 2018 at 11:32 am
luissantos - Friday, July 27, 2018 7:14 AMHello,Thanks for all your replies , i will go create function to split values.
Many thanks
LS
As...
July 27, 2018 at 7:44 am
I want to use my variable on my CTE but my CTE query don´t...
July 27, 2018 at 6:46 am
July 27, 2018 at 6:14 am
July 27, 2018 at 6:08 am
I want to use my variable on my CTE but my CTE query don´t...
July 27, 2018 at 6:03 am
My table have 10000 records and i create the 5 store procedures...
July 26, 2018 at 3:25 pm
please...
July 25, 2018 at 5:33 pm
select
D.*
,H.[Customs_Recon_Entry_Num] as RH_Recon_entry
,max(cast([Recon_File_Date] as Date)) as Recon_File_Date
from
[NAFTAFORD].[STEP1_DUTYIMPACT_MAX3] D
LEft Join
[ADHOC].[ATS_RL] L
on...
July 25, 2018 at 2:40 pm
If you use SSIS's checkpoint files it will automatically start at the step that's failed.
https://www.mssqltips.com/sqlservertip/1408/integration-services-checkpoints-to-restart-package-from-failure/
July 25, 2018 at 2:33 pm
mikewill - Tuesday, July 24, 2018 9:33 PMThank you everyone for the help - Everyone's response was very helpful!
In summary,...
July 25, 2018 at 7:51 am
Viewing 15 posts - 2,356 through 2,370 (of 2,648 total)